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 |
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 |
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 |
"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 |
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 |
All times are GMT +1. The time now is 05:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com