Freezing or Unfreezing Rows in Google Docs Spreadsheets

You can freeze up to ten rows or five columns in any particular sheet in Google Spreadsheets.

Freezing Columns and Rows

  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).

Unfreezing Columns and Rows

  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).

Comments

  1. We should be able to freeze any column/row that we want, not limited to the first few rows/columns. Please fix.

Speak Your Mind

*