3 replies
by john.a.wills Accepted solution
by markp24 Accepted solution
Im going to provide two answers
1) if you want to Freeze the cells so while your scrolling in the work sheet you always see the headings or rows to the lelt.
a) please review this site "http://office.microsoft.com/en-us/excel-help/freeze-or-lock-rows-and-columns-HP001217048.aspx"
here is a quote showing the details
Freeze panes to lock specific rows or columns
1.On the worksheet, do one of the following:
To lock rows, select the row below the row or rows that you want to keep visible when you scroll.
.
.
2.On the View tab, in the Window group, click the arrow below Freeze Panes.
3.Do one of the following:
To lock one row only, click Freeze Top Row.
To lock one column only, click Freeze First Column.
To lock more than one row or column, or to lock both rows and columns at the same time, click Freeze Panes.
the other option to print the first row on every page, you want to goto page setup and under sheet select the rows to repeat
more details here
"http://www.lytebyte.com/2009/08/18/how-to-print-first-row-or-header-row-on-every-page-in-excel/"
by john.a.wills Accepted solution
This discussion is closed to new replies.
Trending Software posts
Sort by Trending