RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: Enterprise
Expertise: Beginner
Sep 11, 2007

Make Column Headings Behave as a Fixed Header Row in Excel

Excel spreadsheets can grow to a very large number of rows. After the spreadsheet grows beyond a single page, the column headings scroll off the page, making it very difficult to remember what the column headings are. The following steps show how to make the column headings behave as a fixed header row:
  • Select the row below your column headings.
  • On the Window tab, select Freeze Panes.
Now, the column headings will be frozen and constantly visible, as you scroll down.

Note: You can reverse by selecting "Unfreeze Panes" from the same menu.

Srinath MS
Close Icon
Thanks for your registration, follow us on our social networks to keep up-to-date