How to freeze rows and columns in Google Sheets
Freezing keeps important rows or columns visible while you scroll through the rest of your data. Perfect for keeping headers visible when scrolling down long datasets, or keeping row labels visible when scrolling right across many columns. This guide covers 3 methods — View menu, drag-to-freeze, and freezing to a specific cell.
⚡ Quick Answer
Go to View → Freeze and choose how many rows or columns to freeze. Options include 1 row, 2 rows, up to current row, 1 column, 2 columns, or up to current column. The frozen area stays visible while the rest of the sheet scrolls.
📋 3 methods in this guide
- Using the View menu Most common
- Drag-to-freeze Fastest
- Freeze up to a specific cell Flexible
Using the View menu
The most common method. Provides preset options for the most common freeze configurations.
Open View menu
A submenu appears with freeze options.
Choose what to freeze
Options for rows: No rows, 1 row, 2 rows, Up to current row. Options for columns: No columns, 1 column, 2 columns, Up to current column. Click your choice.
Verify the freeze
A thick grey line appears at the freeze boundary. Scroll down (or right) — the frozen rows/columns stay in place while everything else moves.
For most spreadsheets: freeze 1 row (the header row) so column names stay visible while scrolling. If you also have row labels in column A, freeze 1 column too. This is the "keep landmarks visible" pattern used in nearly every professional spreadsheet.
Drag-to-freeze
The fastest method once you know where to grab. Google Sheets has invisible drag handles just below row 1 and just right of column A.
Find the freeze bars
Look at the top-left corner where the row numbers meet the column letters. Just below the "1" (row header) and just to the right of the "A" (column header), you'll see thick grey lines. These are the drag handles.
Drag to set freeze position
Click and drag the horizontal grey line down to freeze rows above your cursor. Drag the vertical grey line right to freeze columns to the left of your cursor. Release when you reach the desired position.
Unfreeze by dragging back
To unfreeze, drag the grey lines back to their starting positions (just below row 1 and just right of column A).
Freeze up to a specific cell
Best when you want to freeze more than 2 rows/columns and don't want to count drag distances precisely.
Click the cell just below/right of your freeze target
Example: to freeze rows 1-5, click cell A6 (the first row that should scroll). To freeze columns A-C, click cell D1 (the first column that should scroll).
Use "Up to current row/column"
Sheets freezes everything above the row containing your selected cell. Same logic works for columns with "Up to current column".
Freeze both rows and columns at the same time
You can combine both freezes for a "top-left corner stays fixed" effect — useful when you have both header rows and label columns.
Freeze rows first
View → Freeze → 1 row (or however many).
Then freeze columns
View → Freeze → 1 column (or however many). Both freezes apply. Now scrolling right shows column labels stay put; scrolling down keeps headers visible; the top-left corner stays completely fixed.
Common use cases
| Data type | Recommended freeze |
|---|---|
| Basic table with header row | 1 row |
| Table with multi-row title + header | 2 rows or up to current row |
| Matrix with row labels in column A | 1 row + 1 column |
| Financial model with title, subheaders, categories | 3-4 rows + 1-2 columns |
| Pivot table review | 1 row (headers) + 1 column (row labels) |
Troubleshooting
This happens if you accidentally sorted your header row into the data. Undo (Ctrl+Z) to restore. When sorting, always use Data → Sort range → Data has header row to prevent the header from being sorted.
The freeze line is thin and grey. On light backgrounds it can be hard to see. Try zooming in (View → Zoom → 125%) or scroll a bit — you'll see the freeze effect immediately.
Freeze settings are per-user, per-view — they're saved with your view of the sheet but don't apply to other viewers. Each collaborator sets their own freeze preferences.
Frequently asked questions
How do I freeze the top row in Google Sheets?
Click View menu, hover over Freeze, and select 1 row. The first row (usually your header) stays visible at the top as you scroll down. A thin grey line appears below the frozen row to indicate the freeze boundary.
How do I freeze multiple rows in Google Sheets?
To freeze multiple rows, click the row where you want the freeze to end (freezing everything above it), then go to View → Freeze → Up to current row. Alternatively, click and drag the thick grey line below the row headers down to include more rows.
How do I unfreeze rows in Google Sheets?
Go to View menu, hover over Freeze, and select No rows (or No columns). The freeze lines disappear and all rows scroll together. You can also drag the freeze line back to its original position at the top.
Can I freeze both rows and columns at the same time?
Yes. Set the row freeze first (View → Freeze → 1 row for header), then set the column freeze (View → Freeze → 1 column for row labels). Both freezes apply simultaneously — the top-left corner stays fixed while the rest of the sheet scrolls in both directions.
Is there a keyboard shortcut to freeze rows in Google Sheets?
Google Sheets doesn't have a dedicated keyboard shortcut for freezing rows or columns. The fastest method is dragging the grey freeze lines that appear just below the row 1 header and just right of the column A header. Grab them with your mouse and drag to set the freeze boundary.