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 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 … [Read more...]

FAQ: Locking/Freezing Heading Rows in OpenOffice Calc [and Freezing Columns, too!]

Amazon affiliate: Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting Let's say you have a number of rows of data, and you need to be able to scroll or search up and down them, but whenever you do, you lose sight of the headings. These instructions work for Calc in both OpenOffice.org AND NeoOffice. In order to freeze the header rows so that they don't … [Read more...]