format question

[Bassman]

Hello,
How do I lock a row from moving when I scroll? I what the header to
stay put!

 

[daddylonglegs]

If you have headers in row 1 select A2 and use Window > Freeze Panes

 

[Lars-Åke Aspelin]

Hello,
How do I lock a row from moving when I scroll? I what the header to
stay put!

Have a look at "Freeze panes" in the Excel help.

Hope this helps / Lars-Åke

 

[Ben M. Schorr - MVP (OneNote)]

Freeze Panes. The exact way to do it depends a little on the version of
Excel you're using. Check the Help system in Excel.

--
-Ben-
Ben M. Schorr, MVP
Roland Schorr & Tower
http://www.rolandschorr.com
http://www.officeforlawyers.com
Author - The Lawyer's Guide to Microsoft Outlook 2007:
http://tinyurl.com/5m3f5q

 

[Bassman]

Have a look at "Freeze panes" in the Excel help.

Hope this helps / Lars-Åke

I knew it would be easy. I have spent a lot of time trying to figure
out. I have a sheet someone else sent me...(my excel teacher) that
looks great and I have been looking every where so I can add to my new
project at work. I have not tried yet but I am sure I can handle now.