When working with large datasets in Google Sheets, scrolling down to view row 500 means you lose sight of the header row at the top, leaving you guessing what each column represents. Similarly, scrolling horizontally to the right means you lose sight of the critical identifying information (like a client name or product ID) located in the first column.
The solution is to “freeze” these rows and columns so they remain permanently locked to the edges of your screen, no matter how far you scroll. While many users know how to freeze the top row or the first column independently, you can actually freeze both simultaneously to create an always-visible crosshair for your data.
This guide explains exactly how to freeze both the top row and the first column at the same time using Google Sheets.
Method 1: Using the View Menu
The most straightforward way to lock your headers in place is by using the traditional View menu at the top of the Google Sheets interface.
- Open your spreadsheet in Google Sheets.
- First, lock the top row. Click on View in the top menu bar.
- Hover your mouse over Freeze.
- From the drop-down menu, select 1 row. A thick grey line will appear beneath the first row, indicating it is now locked in place.
- Now, lock the first column. Click on View again.
- Hover over Freeze.
- This time, select 1 column. A thick grey line will appear to the right of Column A.
You have now successfully frozen both axes. If you scroll down, Row 1 stays on screen. If you scroll right, Column A stays on screen. You can scroll diagonally into the depths of your dataset, and both headers will remain perfectly visible.
Method 2: Using the Drag-and-Drop Handles
For power users, Google Sheets includes a much faster, visual method for freezing rows and columns without ever opening a menu. This method uses the blank grey square located in the very top-left corner of your spreadsheet (above row 1 and to the left of column A).
If you look closely at this grey square, you will see two thick, dark grey borders: one on its bottom edge and one on its right edge. These are draggable freeze handles.
- Open your spreadsheet.
- Move your mouse cursor over the thick grey line at the bottom of the empty top-left square. Your cursor will turn into a small hand icon.
- Click and hold the left mouse button, then drag the grey line down so it rests immediately below Row 1. Release the mouse button. The top row is now frozen.
- Move your mouse cursor over the thick grey line on the right side of the empty top-left square. The hand icon will appear again.
- Click and hold, then drag the grey line to the right so it rests immediately after Column A. Release the mouse button. The first column is now frozen.
This drag-and-drop method is incredibly versatile because it allows you to freeze multiple rows or columns instantly. If your header data spans two rows, simply drag the horizontal line down below Row 2 instead.
How to Unfreeze Rows and Columns
If you need to return your spreadsheet to its normal, unfrozen state, the process is just as simple.
You can either drag the thick grey lines back to their original resting places in the top-left corner, or use the menu system:
- Click View > Freeze > No rows.
- Click View > Freeze > No columns.
Freezing both axes simultaneously is one of the most effective ways to make a massive Google Sheet legible, preventing constant scrolling and reducing data entry errors.