Freezing rows and columns: Basic how-to

Even if you do have column headers, once you scroll down more than a screen you can’t see them anymore. Unless, that is, you freeze them.

Freezing allows you to specify any number of currently showing rows and/or columns to always display. You could, in theory, tell it to freeze all but the bottom row, and all but the rightmost column, but if you did you could only move around one cell. Generally when working with a large detailed list I freeze between one and three rows at the top, and sometimes the leftmost column. For example, a list of student scores might freeze row 1, which contains the names of the assignments, and column A, which contains the student names.

General instructions:
Once you’ve frozen rows or columns, you un-freeze using the same commands as you use to freeze. You do not have to be in any particular cell to do so. Also, once you’ve frozen a row or column the only way to change what’s frozen is to un-freeze and then freeze again in the new location.

Frozen rows/columns are usually indicated by a particularly strong line separating them from the unfrozen ones.

In Excel 97:

  1. Select the cell in the row below and the column to the right of the ones you want to always display.
  2. Click on the Window header, or type Alt-W.
  3. In the menu that appears, click on “Freeze Panes” or type F.

In Excel 2007:

  1. Select the cell in the row below and the column to the right of the ones you want to always display.
  2. Click on the “View” tab.
  3. In the “View” tab, look for the “Window” group. For me it’s the largest group, and it’s located 2nd from the right.
  4. At the bottom left of the “Window” group, look for “Freeze Panes”, and click on it.
  5. In the menu that appears, click on “Freeze Panes” or type F.

Note: The shortcut for Excel 97 (Alt-W-F) still works in Excel 2007.

In Google Spreadsheet:

  1. Click on the View header.
  2. In the menu that appears click on either “Freeze Rows” or “Freeze columns”.
  3. In the sub-menu that appears, click on the number of rows or columns you want frozen.

In OpenOffice Calc:

  1. Select the cell in the row below and the column to the right of the ones you want to always display.
  2. Click on the Window header, or type Alt-W.
  3. In the menu that appears click on Freeze or type F.

In Microsoft Works Spreadsheet:

  1. Select the cell in the row below and the column to the right of the ones you want to always display.
  2. Click on the Format menu, or type Alt-O.
  3. In the menu that appears click on “Freeze Titles” or type “Z”.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s