View Single Post
 
Old 12-16-2013, 12:32 PM
The Accountant The Accountant is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Dec 2013
Location: Norway
Posts: 2
The Accountant is on a distinguished road
Default

Quote:
Originally Posted by BobBridges View Post
Sure, it's called "freezing" the top (header) rows; and you can do it with the leftmost columns, too, if need be. Try this:

Move the selection to the topmost cell that you want to be part of the data, ie below the header rows. In your screen shot that would be A5.

If you're using Excel 2010, go to the ribbon and select View, Freeze Panes. You can select the desired option from there.
Thank you very much, worked like a charm Didn't know it was that easy!

-The Accountant
Reply With Quote