How you can freeze your column headings in Excel 2000!

Posted By : Michal of Data Doctors on April 16, 2003

Follow us on Facebook   Follow us on Twitter   Follow us on LinkedIn

Let Data Doctors be your personal IT department today

How can I keep my column headings in view while scrolling down the spreadsheet in my MS Excel 2000?

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

About the author

Posted by Michal of Data Doctors on April 16, 2003

Need Help with this Issue?

We help people with technology! It's what we do.
Contact or Schedule an Appointment with a location for help!