How to Freeze Rows and Columns in Google Sheets

When working with large datasets in Google Sheets, scrolling down or across your spreadsheet quickly becomes frustrating. As you move away from the top-left corner of the document, you lose sight of your header rows and column labels, making it difficult to understand what data belongs in which category.

To solve this, Google Sheets allows you to “freeze” specific rows and columns. Freezing locks the designated headers in place so that they remain permanently visible on your screen, regardless of how far down or across the spreadsheet you scroll.

How to Freeze the Top Header Row

Freezing the very first row is the most common use case, as it usually contains the titles for your data columns (e.g., Date, Revenue, Client Name).

1. Open your spreadsheet in Google Sheets.
2. Look at the menu bar at the very top of the screen and click on View.
3. Hover your cursor over the Freeze option in the dropdown menu.
4. Select 1 row from the sub-menu.

A thick grey line will appear directly underneath row 1, indicating that the row is now locked. You can now scroll down thousands of rows, and your header row will stay pinned to the top of the window.

How to Freeze Multiple Rows or Columns

If your spreadsheet has a more complex structure, you might need to lock several rows or a specific column (such as a list of employee names in Column A) while scrolling horizontally through months of data.

To freeze multiple rows or columns:

1. Select the specific row or column you want to freeze up to. For example, if you want to freeze the first three rows, click the number 3 on the left-hand side to select the entire row.
2. Click on View in the top menu.
3. Hover over Freeze.
4. Select Up to row 3 (or “Up to column C” if you are freezing columns).

You can freeze both rows and columns at the same time. If you freeze Row 1 and Column A, the top-left cell (A1) will remain entirely static while the rest of the spreadsheet scrolls freely in all directions.

The Drag-and-Drop Freezing Shortcut

Using the View menu is simple, but there is a much faster, visual way to freeze rows and columns using only your mouse.

1. Look at the very top-left corner of your spreadsheet, where the row numbers and column letters meet (the empty grey box above row 1 and to the left of column A).
2. You will notice thick grey borders on the bottom and right edges of this empty box.
3. Hover your cursor over the thick grey line at the bottom of the box until your cursor turns into a hand icon.
4. Click and drag the thick grey line down the screen. Drop it underneath the row you wish to freeze.
5. To freeze columns, hover over the thick grey line on the right side of the box, click, and drag it horizontally across the screen.

How to Unfreeze Rows and Columns

If you no longer need your headers locked, unfreezing them is just as straightforward.

You can either use the drag-and-drop method to drag the thick grey lines back to their original position in the top-left corner, or use the menu:

1. Click View.
2. Hover over Freeze.
3. Select No rows or No columns to remove the locks entirely.