← Using a Computer, in Practice
Spreadsheets · 57 of 111
Freeze the top row so headings stay
Expert guidance
Do this
Google Sheets: View, Freeze, 1 row.
LibreOffice Calc: click cell A2, then View, Freeze Rows and Columns. Everything above and to the left of the cell freezes.
To undo it, in Sheets choose View, Freeze, No rows, and in Calc choose the same command again.
Why this way
You stop guessing which column is which, so you make fewer mistakes when you type in row 80. Freeze the first column too if your names scroll off to the left. It changes the view only, not your data. Expert guidance.
Do it today
Freeze the top row of your longest sheet. One minute.
Where these facts come from
- Freeze, group, hide, or merge rows & columns, Google Docs Editors Help.
- Freezing Rows or Columns as Headers, LibreOffice Help.
General information. Menus and apps change, so look for the idea if a button has moved. You use it at your own risk: see our terms. Spotted a mistake, or know something better? Tell us.
