GCFLearnFree.org

This class helped me get a promotion at work. I would recommend it to anyone!”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Excel 2010
  • Worksheet Basics

Excel 2010

Single page view print copy

Worksheet Basics

Freezing worksheet panes

Video: Freezing Worksheet Panes in Excel 2010

Launch video!Watch the video (1:50).

The ability to freeze specific rows or columns in your worksheet can be a useful feature in Excel. It is called freezing panes. When you freeze panes, you select rows or columns that will remain visible all the time, even as you are scrolling. This is particularly helpful when working with large spreadsheets.

To freeze rows:

  1. Select the row below the rows you want frozen. For example, if you want rows 1 and 2 to always appear at the top of the worksheet even as you scroll, then select row 3.
    Selecting row 3 Selecting row 3
  2. Click the View tab.
  3. Click the Freeze Panes command. A drop-down menu appears.
  4. Select Freeze Panes.
    Selecting the Freeze Panes command from the View tab Selecting the Freeze Panes command from the View tab
  5. A black line appears below the rows that are frozen in place. Scroll down in the worksheet to see the rows below the frozen rows.
    Rows 1 and 2 are frozen Rows 1 and 2 are frozen

To freeze columns:

  1. Select the column to the right of the columns you want frozen. For example, if you want columns A and B to always appear to the left of the worksheet even as you scroll, then select column C.
    Selecting column C Selecting column C
  2. Click the View tab.
  3. Click the Freeze Panes command. A drop-down menu appears.
  4. Select Freeze Panes.
    Selecting the Freeze Panes command from the View tab Selecting the Freeze Panes command from the View tab
  5. A black line appears to the right of the frozen area. Scroll across the worksheet to see the columns to the right of the frozen columns.
    Columns A and B are frozen Columns A and B are frozen

To unfreeze panes:

  1. Click the View tab.
  2. Click the Freeze Panes command. A drop-down menu appears.
  3. Select Unfreeze Panes. The panes will be unfrozen, and the black line will disappear.
    Selecting the Unfreeze Panes command from the View tab Selecting the Unfreeze Panes command from the View tab
previous next
previous 1 2 3 4 5 6 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.