Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excel 2000 spreadsheet
I'm working in a large spreadsheet. I want to see the column headings stay
on top of my spreasheet as I'm scrolling down thru multiple pages. Thank you very much |
#2
|
|||
|
|||
Select a cell in column A in the row below the heading rows.
Then select Windows | Freeze panes regards Trevor "SunnyLee" wrote in message ... I'm working in a large spreadsheet. I want to see the column headings stay on top of my spreasheet as I'm scrolling down thru multiple pages. Thank you very much |
#3
|
|||
|
|||
Use "Freeze Panes".
This old post should help explain: http://tinyurl.com/2qdzt -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "SunnyLee" wrote in message ... I'm working in a large spreadsheet. I want to see the column headings stay on top of my spreasheet as I'm scrolling down thru multiple pages. Thank you very much |
#4
|
|||
|
|||
"SunnyLee" wrote: I'm working in a large spreadsheet. I want to see the column headings stay on top of my spreasheet as I'm scrolling down thru multiple pages. Thank you very much |
#5
|
|||
|
|||
Thank you so much Trevor...you made my day and this info is certainly going
to help me at work. Lee "Trevor Shuttleworth" wrote: Select a cell in column A in the row below the heading rows. Then select Windows | Freeze panes regards Trevor "SunnyLee" wrote in message ... I'm working in a large spreadsheet. I want to see the column headings stay on top of my spreasheet as I'm scrolling down thru multiple pages. Thank you very much |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I use Excel 2003 to sit for exams which are in Excel 2000 | Excel Discussion (Misc queries) | |||
Excel Programs developed in Office 2000 on Windows 2000 | Excel Discussion (Misc queries) | |||
Excel 2003 V's Excel 2000? | Excel Worksheet Functions | |||
i want to connect excel with sql server 2000 as database with macr | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |