
Tips.Net > ExcelTips Home > Excel's Environment and Interface > Panes > Keep Your Headings in View
Summary: How to keep your heading visible while working on the lower rows of the Excel spreadsheet. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)
If you work with Excel tables, particularly ones that are quite large, you know it can be confusing to remember what each column is for. To overcome this problem, divide the current worksheet window into panes. (Use the pane divider--the small bar just above the vertical scrollbar at the upper-right corner of the screen.) Each pane will give you a view of different parts of your document. In the top pane, display the headings for your table. You may want to make the pane small so there is more room to work in the other pane. For instance, you may only want to display a row or two in the top pane. In the bottom pane, do your table work. In this way you will always be able to see your column headings.
Tip #1924 applies to Microsoft Excel versions: 97 2000 2002 2003
Make Home Buying Less Stressful! Why face the annual problems associated with Christmas debt? Learn how to avoid that debt and conquer your financial challenges.
Check out Buying a Home Checklist today!
Want to make Excel do even more? The way is easy when you know how to use macros. This great e-book makes it easy. (more information...)
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site