How you can freeze your column headings in Excel 2000!
Question
How can I keep my column headings in view while scrolling down the spreadsheet in my MS Excel 2000?
Answer
This question was answered on April 16, 2003. Much of the information contained herein may have changed since posting.
The Freeze Pane Option
If you are tired of loosing sight of Your column headings in Excel 2000 then you have come to the right place. The solution to this annoying problem is the 'Freeze Panes' option in the program.
Would you like to see the column headings on your Microsoft Excel spreadsheets no matter how far down you scroll? Here is one way to keep the column headings constantly visible:
1. Select the row just BELOW your column headings
2. Click on Window (the menu option next to tables)
3. Then click Freeze Panes on the Windows menu
The 'frozen' column headings don't scroll, but stay visible as you scroll through the rest of the worksheet.
Author
Posted by Michal of Data Doctors on April 16, 2003
Newsletter
Sign up for our weekly newsletter and get free tips and tricks to keep your computer running well.
See the Newsletter Archives
