how do I keep the top line static in excel files
 

how do I keep the top line static in excel files
 

Click on the 1 (or 2, or 3...) row header (the numbers at far left)
Use command Windows | Freeze
Later use Windows | Unfreeze
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"will" wrote in message
...

how do I keep the top line static in excel files
 

Clicking on row 2 or 3 is OK, but for me clicking on row 1 (or column A)
puts the freeze pont at the centre of the window. For other conditions it
freezes everything above and to the left of the selected cell.
--
David Biddulph

"Bernard Liengme" wrote in message
...
Click on the 1 (or 2, or 3...) row header (the numbers at far left)
Use command Windows | Freeze
Later use Windows | Unfreeze
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"will" wrote in message
...

how do I keep the top line static in excel files
 

Many thanks thats great

"David Biddulph" wrote:

Clicking on row 2 or 3 is OK, but for me clicking on row 1 (or column A)
puts the freeze pont at the centre of the window. For other conditions it
freezes everything above and to the left of the selected cell.
--
David Biddulph

"Bernard Liengme" wrote in message
...
Click on the 1 (or 2, or 3...) row header (the numbers at far left)
Use command Windows | Freeze
Later use Windows | Unfreeze
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"will" wrote in message
...