Skip to content

← 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

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.

← All 111 things to do