Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
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
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap