How to Freeze Rows and Columns in Google Sheets to Keep Headers Visible

When working with large spreadsheets containing hundreds of rows of data, scrolling down to line 150 often means you lose sight of the column headers at the very top. Without those headers, it becomes incredibly difficult to remember whether column ‘F’ represents gross revenue, net profit, or projected costs, leading to dangerous data entry errors.

To solve this, Google Sheets allows you to “freeze” specific rows or columns. Freezing locks them in place so that no matter how far down or to the right you scroll, those essential reference headers remain permanently visible on your screen.

Freezing Rows for Vertical Scrolling

If you have a long list of data and you want your title headers at the top to stay visible, you need to freeze the top row.

1. Open your spreadsheet in Google Sheets.
2. Look at the main toolbar at the top of the screen and click on View.
3. From the dropdown menu, hover your mouse over Freeze.
4. A sub-menu will appear with several options. If your headers are only on the very first line, click 1 row. If your headers take up two lines, click 2 rows.
5. You will instantly see a thick grey line appear beneath the row you just froze. Now, try scrolling down. The data will move, but the top row will remain pinned to the top of the window.

Freezing Columns for Horizontal Scrolling

If your spreadsheet is extremely wide and you want to keep the names of your clients or products visible on the left side while you scroll horizontally through months of data, you need to freeze a column.

1. Click on View in the top toolbar.
2. Hover over Freeze.
3. In the sub-menu, select 1 column (to freeze column A) or 2 columns (to freeze columns A and B).
4. A thick grey line will appear to the right of the frozen column. Scrolling to the right will now keep those initial columns locked to the left side of your screen.

The Drag-and-Drop Method

For a much faster, visual way to freeze rows and columns without using the menus, you can use the grey handle lines built directly into the spreadsheet grid.

1. Look at the very top-left corner of your spreadsheet, the empty grey square located directly between the “A” column header and the “1” row header.
2. You will notice a thick grey border on the bottom and right side of this empty square.
3. Hover your mouse cursor exactly over the thick grey line at the bottom of the square. Your cursor will turn into a small hand icon.
4. Click and drag that line down below row 1 (or wherever you want to freeze) and let go. You have just frozen a row.
5. Similarly, hover over the thick grey line on the right side of the square, click, and drag it to the right to freeze a column.

Unfreezing Rows and Columns

If you no longer need the data locked in place, removing the freeze is just as easy.

1. Click View > Freeze.
2. Select No rows to unfreeze the top section.
3. Select No columns to unfreeze the left section.