Excel 2003: keep first col when scrolling to rest

  johnincrete 17:28 30 Jun 2009

Excel allows you to keep column heads on the screen while you scroll down. Is there any way to keep column 1 on the screen while scrolling over the rest?

  scotty 17:36 30 Jun 2009

Select a cell in column B, then under Windows menu, select freeze pane.

  johnincrete 05:06 01 Jul 2009

I already have the column heads "frozen" so the only option I get is to unfreeze panes irrespective of the row in column B

  wiz-king 05:26 01 Jul 2009

Unfreeze panes, select cell B2 (assuming you headers are in row A) freeze, that should freeze headres and col A

  wiz-king 05:48 01 Jul 2009

'Row A' = Row 1

  johnincrete 15:52 01 Jul 2009

Thanks - that's just what I wanted. It will save me much horizontal scrolling & time

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?