Forgot your password?

Quick Microsoft Excel Tips: Lock Headers

By Edited Mar 9, 2016 1 0

Quick Excel Tip of the Day: Lock Headlines

Hi Everyone, 

Looking to move your Excel reports from impressive to brilliant? Follow these quick excel tips that separate the experts from the rookies.

Have you ever been presenting an excel document over a projector and when you scroll down too far people can't see the column headers? I cringe when this happens to people because it causes mass confusion in the meeting and can be solved in SECONDS. 

Locking headers will not only help the person while creating the file, but especially everyone exposed to the file that may not know what the columns represent without reading the headers.

Here's how to do it:

  1. Let's pretend my headers on row 5
  2. Highlight the row after the header row, in this case row 6

Excel 2003

  1. Click the window menu from the toolbar
  2. Select Freeze Panes
  3. Scroll up or down and the header row will stick up at the top
  4. To remove, select window from the toolbar
  5. Select Unfreeze Panes

Excel 2007 and later

  1. Click the View tab in the ribbon (the ribbon is the top menu bar in the new excel versions)
  2. Select Freeze Panes dropdown menu under the Window group of icons
  3. Select Freeze Panes
  4. Scroll up or down and the header row will stick up at the top
  5. To remove, select Freeze Panes dropdown menu under the Window group of icons
  6. Select Unfreeze Panes

If you want to get really fancy you can freeze a row and a column by selecting one cell instead of an entire row. Let's say my header is in row 5 and column C is really important as well, I will select cell D6 and freeze panes so that regardless of where I scroll these two areas are in focus.

Don't miss my first post on how to hide gridlines here

Thanks, and talk to you tomorrow



Add a new comment - No HTML
You must be logged in and verified to post a comment. Please log in or sign up to comment.

Explore InfoBarrel

Auto Business & Money Entertainment Environment Health History Home & Garden InfoBarrel University Lifestyle Sports Technology Travel & Places
© Copyright 2008 - 2016 by Hinzie Media Inc. Terms of Service Privacy Policy XML Sitemap

Follow IB Technology