New to Excel - Filling out data

[The Accountant]

Hello! New to the forum here

Ok, so I'm doing something on Excel that requires me to fill in a lot of data manually.
Ok, under is a screenshot of the table I made, but my problem is that I want the top row with the names of the columns to always be on top when I scroll down.
Does anyone know how I do this, if you know what I meant of course.


I'm grateful for any help, good or bad

- The Accountant (I'm not an accountant)

[BobBridges]

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.

[The Accountant]

Originally Posted by BobBridges

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