keep first row fixed

[andrewm]

Hi,

sorry might be the wrong place to ask question.
I have a very large excel spreadsheet that scrolls down.
date name etc
1/1/05 John
2/1/-5 andrew

I would like the headings (a1, b1...)of the columns to remain static so
when I scroll several pages down I know what the names of the rows are.

Is there a way around this

andrewm

 

[greg7468]

Andrew,

Highlight row 2

Go to Window > Split

HTH.

 

[olasa]

Click on Row 1 so that whole row 1 is highlighted.
Then goto the menu and select Windows>Freeze Pane.

Do the same to Unfreeze.

Ola Sandström