Loading
Excel.Tips.Net ExcelTips (Menu Interface)

Keep Your Headings in View

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.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (1924) applies to Microsoft Excel 97, 2000, 2002, and 2003.

Related Tips:

Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!

 

Leave your own comment:

*Name:
Email:
  Notify me about new comments ONLY FOR THIS TIP
Notify me about new comments ANYWHERE ON THIS SITE
Hide my email address
*Text:
*What is 5+3 (To prevent automated submissions and spam.)
 
 
           Commenting Terms

Comments for this tip:

Henry Noble    19 Mar 2016, 11:21
In Excel 2010 there is a similar bar in the lower-right corner that can be dragged out to enable scrolling vertical panes.
Both horizontal and vertical bars can be active at the same time.
 
 

Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us

 

Advertise with Us

Our Privacy Policy

Our Sites

Tips.Net

Beauty and Style

Cars

Cleaning

Cooking

DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)

Gardening

Health

Home Improvement

Money and Finances

Organizing

Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2016)

Our Products

Helpful E-books

Newsletter Archives

 

Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2016 Sharon Parq Associates, Inc.