How to keep 1st column visable when scrolling

T

TomC

I am trying to figure out how to keep the 1st column visable when scrolling
across the spreadsheet.
 
R

Ron Coderre

Try this:

Select the 1st cell under and to the right of the rows/columns you want to
always display.

From the Excel main menu:
<window><freeze panes>

Note: to unfreeze the panes <window><unfreeze panes>

Example:
Select cell C3
<window><freeze panes>
Now columns A and B, and rows 1 and 2 will always be visible as you scroll.

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Top