Freeze or unfreeze columns and rows

Freezing rows and columns allows you to keep some of your data in the same place as you scroll through the rest of your spreadsheet. This is particularly useful if you have headings or labels that you'd like to keep in one place as you scroll through a large data set.

You can freeze up to ten rows or five columns in any particular sheet. Here's how:

  1. Go to the View menu.
  2. Then, point your mouse to Freeze rows... or Freeze columns....
  3. Select one of the options. When you scroll, you'll notice the frozen row(s) or column(s).

To unfreeze rows or columns, follow these steps:

  1. Go to the View menu.
  2. Then, point your mouse to Freeze rows... or Freeze columns....
  3. Select the No frozen rows or No frozen columns option. When you scroll, you'll notice that there are no frozen row(s) or column(s).