Freeze your Excel 2007 headers

Freezing panes allow you to hold sections of a worksheet in place so they are visible at all times whilst scrolling through the worksheet. This is especially useful for holding the column and row headings in place whilst you scroll large worksheets.

Freeze Panes

  1. Click the View tab on the Ribbon
  2. Click the Freeze Panes button in the Window group

A list appears with three options

Freezing panes in Excel 2007
Freezing panes in Excel 2007
  • Freeze Panes: Freezes the worksheet above and to the left of the selected cell. Ensure that you select the required cell before clicking this option. Frozen panes cannot be moved once they are set. You would need to unfreeze the panes and then freeze them again.
  • Freeze Top Row: Freezes the top row, keeping it visible whilst you scroll through the rest of the worksheet. This is possibly the most popular option.
  • Freeze First Column: Freezes the first column, keeping it visible whilst you scroll through the rest of the worksheet. Solves the nightmare that is horizontal scrolling.

3. Select the desired option from the list.

The headers are frozen and the worksheet can be navigated as required.

To unfreeze panes, click the Freeze Panes button in the Window group and select Unfreeze Panes.

Visit Computergaga.com for further Microsoft Excel training

More by this Author

  • Create an Interactive Excel Chart using Option Buttons
    6

    Form controls can be added to an Excel spreadsheet to create interactivity with the user. This article looks at using option button controls to allow a user to choose the data they want to see on a chart. The first...

  • Simulate a Cup Draw using Excel
    0

    Microsoft Excel can do some amazing things. I like to attempt little projects testing what Excel can do. I was asked the other day to simulate a cup draw using Excel and this is the result. This article will give you...

  • Brock Lesnar Nutrition and Workouts
    2

    Brock Lesnar is a phenomenon of a man and an athlete. Brock Lesnar weighs a lean 265 lbs and yet possesses extreme speed, agility and athleticism. How a man carrying so much muscle mass can maintain such high levels of...


Comments 3 comments

thevoice profile image

thevoice 6 years ago from carthage ill

well informed


askjanbrass profile image

askjanbrass 6 years ago from St. Louis, MO

I JUST learned how to use freeze pans the other day and it feels revolutionary. I can't believe how something so simple can actually save me a bit of time and effort!


valeriebelew profile image

valeriebelew 6 years ago from Metro Atlanta, GA, USA

I don't have occasion to use excell at this point, but if that ever changes, I will return to this article. Good luck hubbing. We need some good computer geeks around. Welcome to hubpages.

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.


    Click to Rate This Article
    working