You can freeze up to ten rows or five columns in any particular sheet in Google Spreadsheets.
Freezing Columns and Rows
- Go to the View menu.
- Then, point your mouse to Freeze rows… or Freeze columns….
- Select one of the options. When you scroll, you’ll notice the frozen row(s) or column(s).

Unfreezing Columns and Rows
- Go to the View menu.
- Then, point your mouse to Freeze rows… or Freeze columns….
- 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).



We should be able to freeze any column/row that we want, not limited to the first few rows/columns. Please fix.
Maricar – you should direct your comments to the software programmers at the http://openoffice.org site – I just help people with solutions. I don’t actually write the software. Good luck!