Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Continuous View
I would like to know how to view rows continuously as I scroll down an Excel
sheet. I have a spreadsheet that has column names at the top of the page. The titles use up rows 1-3. How can I always see rows 1-3 when I scroll down to the bottom of my data? I have seen it on other Excel spreedsheets but I don't know how to do it. |
#2
|
|||
|
|||
Stacey
select cell A4 and then, from the menu, Window | Freeze panes Regards Trevor "Stacey" wrote in message ... I would like to know how to view rows continuously as I scroll down an Excel sheet. I have a spreadsheet that has column names at the top of the page. The titles use up rows 1-3. How can I always see rows 1-3 when I scroll down to the bottom of my data? I have seen it on other Excel spreedsheets but I don't know how to do it. |
#3
|
|||
|
|||
You can either split the excel window or use the freeze panes facility. See
http://www.allaboutoffice.co.uk/exsplit.htm Andrea Jones http://www.allaboutoffice.co.uk http://www.stratatraining.co.uk http://www.allaboutclait.com "Stacey" wrote: I would like to know how to view rows continuously as I scroll down an Excel sheet. I have a spreadsheet that has column names at the top of the page. The titles use up rows 1-3. How can I always see rows 1-3 when I scroll down to the bottom of my data? I have seen it on other Excel spreedsheets but I don't know how to do it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I display a worksheeet in full screen view | Excel Discussion (Misc queries) | |||
Formula for Continuous Services Dates | Excel Worksheet Functions | |||
Can I view an excel file without having the excel programme. | Excel Discussion (Misc queries) | |||
Page Break View - not the usual question | Excel Discussion (Misc queries) | |||
View and Cell Sum Range | Excel Discussion (Misc queries) |