Header Row in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spread sheet with many columns and rows and I would like for the
First line of each column to remain visible as a user scrolls down the rows
so that he/she will be able to see that that data represents by simply
looking up(instead of scrooling all the way back up) to see that is the
heading of that column.

Any help would be appreciated.

Larry Hughes
 
Hi Larry,

Select the row 2, if you want to freeze row 1

click on the menu WINDOW | FREEZE PANEL

Does this Help?
regards from Brazil
Marcelo

"Larry Hughes" escreveu:
 
and for the same thing in printed worksheets
file, page setup, sheets, Rows to repeat at top: $1:$1
file, peg setup , Sheets, Columns to repeat at left: $A:$A
there is a little more flexibility in printing to allow you o not print headings
on the first page(s) until you need a page break after your designated entries.
More information on both see
http://www.mvps.org/dmcritchie/excel/freeze.htm
 
Larry Hughes said:
I have a spread sheet with many columns and rows and I would like for the
First line of each column to remain visible as a user scrolls down the rows
so that he/she will be able to see that that data represents by simply
looking up(instead of scrooling all the way back up) to see that is the
heading of that column.

Any help would be appreciated.

Larry Hughes
Click to expand...
 
According to the guidelines of how to post and the opinion of the majority, we are supposed to do research before we post. This makes sense. However, sometimes I have a different view. If the OP had found the answer from Excel Help, then he/she might not have posted. As a result, I would not have known about your web site which is a gift. You know if I know how to do something, I probably won't research. Thanks.

Epinn

Also you might want to so see
http://www.mvps.org/dmcritchie/excel/freeze.htm
which covers some related things.


I went to Excel Help and did a search and found the following link.

http://office.microsoft.com/en-us/excel/HA012001021033.aspx?pid=CL100570551033

Epinn
 
Back
Top