#1
|
|||
|
|||
New to Excel - Filling out data
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) |
#2
|
||||
|
||||
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. |
#3
|
|||
|
|||
Quote:
-The Accountant |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
[Excel 2007] Building Power Point Slides from data in an Excel Table | bremen22 | Excel Programming | 1 | 08-07-2013 11:01 AM |
filling in forms | mepossem | Word | 3 | 05-25-2013 02:35 AM |
filling a text box | mrmagoo | Excel | 1 | 07-05-2012 03:44 PM |
saving data in excel 2010 from excel 2003 | johnkcalg | Excel | 1 | 02-06-2012 07:33 PM |
Filling the consecutive cell by day. | aligahk06 | Excel | 1 | 09-15-2010 08:17 AM |