How to Freeze Rows in Google Sheets

What Freezing Rows Does and Why It Matters

When you’re working with large spreadsheets, scrolling through hundreds of rows can make you lose track of your column headers. Freezing rows keeps a fixed set of rows visible at the top of your sheet while you scroll down through the data below. This is one of the most practical features in Google Sheets because it solves a real problem: you can always see what each column contains, even when you’re looking at data far down the page.

The freeze feature is essential for anyone working with large datasets, whether you’re tracking sales figures, inventory lists, student grades, or budget spreadsheets. Without frozen rows, you’d constantly have to scroll back to the top to remember which column contains dates, prices, or customer names. Freezing typically means locking the header row in place, though you can freeze multiple rows if your headers span more than one row.

Google Sheets makes freezing rows quick and intuitive. Once you set up your freeze, it persists when you share the sheet with others, so your collaborators see the same frozen layout. The freeze applies only to your view and other viewers’ views—it doesn’t lock the data itself or prevent editing. This distinction matters because you may want headers visible without protecting the underlying data from changes.

How to Freeze the Top Row

The single most common use case is freezing just the first row, which typically contains your column headers. To do this in Google Sheets, start by clicking on the second row (the row you want to be the first scrollable row). You don’t click on row 1 itself; you click on row 2, which is the first row of data below your headers.

With row 2 selected, navigate to the View menu at the top of the page. Click View, then hover over or click Freeze. A submenu appears with options including “1 row” and “Up to current row.” Click “1 row” to freeze the top row only. That’s it. Google Sheets immediately applies the freeze, and you’ll see a thin gray line appear between row 1 and row 2, indicating that the freeze is active.

Once the freeze is in place, scroll down your sheet and watch what happens. The header row stays glued to the top of your screen while everything below it scrolls normally. This makes it vastly easier to work with large datasets because you never lose sight of what each column represents. The gray line serves as a visual marker showing exactly where the freeze occurs.

How to Freeze Multiple Rows

Not every spreadsheet has a single-row header. Some sheets have two or three rows of headers, category labels, or other information you want to remain visible. Google Sheets handles this by letting you freeze any number of rows from the top.

To freeze multiple rows, first select the row number where you want the scrollable data to begin. If you want to freeze the top three rows, click on row 4. Then open View > Freeze and select “Up to current row.” Google Sheets freezes rows 1, 2, and 3, and row 4 becomes the first row that scrolls. You’ll see a thicker gray line after row 3 to show the freeze boundary. You can freeze as many rows as you need, though in practice most sheets freeze between one and five rows.

Changing the number of frozen rows is straightforward. Simply select a different row and use View > Freeze > Up to current row again. The new freeze setting replaces the old one, so you only ever have one freeze boundary per sheet. If you’ve frozen three rows but then decide to freeze only one, clicking on row 2 and selecting “Up to current row” switches the freeze instantly.

How to Freeze Columns

The same freezing logic applies to columns on the left side of your sheet. If you have a column with item names or IDs that you want to see while scrolling horizontally through many columns of data, freezing columns solves that problem. The process is identical to freezing rows, except you work with column letters instead of row numbers.

Click on the column letter where you want scrollable data to begin. If you want to freeze column A, click on column B. Then use View > Freeze > Up to current column. A vertical gray line appears after column A, and now when you scroll right, column A stays fixed on the left side of your screen.

You can also combine frozen rows and columns in the same sheet. For example, you might freeze row 1 (headers) and column A (item names). To do this, click on cell B2, then use View > Freeze > Up to current row. Wait, that’s not quite right. To freeze both simultaneously, select the cell at the intersection, meaning the cell in the first scrollable column and the first scrollable row. Click on that cell (B2 in this example), then open View > Freeze, and Google Sheets will lock all rows above and all columns to the left of your selected cell. The gray lines appear both horizontally and vertically, creating a four-way freeze.

How to Unfreeze Rows and Columns

Removing a freeze is even simpler than creating one. Open the View menu and select Freeze again. You’ll notice that the option that was previously selected (like “1 row” or “Up to current row”) now has a checkmark or appears highlighted. Click it again to toggle the freeze off. Alternatively, you can click any other freeze option to replace the current freeze with a new one.

When you unfreeze, the gray lines disappear and your sheet goes back to normal scrolling behavior. Any data you’ve entered remains unchanged; unfreezing only affects the display. This is important to understand because some users worry that unfreezing might delete or alter their data, which it never does.

Freezing Rows on Mobile: Google Sheets App

The Google Sheets mobile app for Android and iOS has the same freezing capability as the desktop version, though the interface works slightly differently due to the touch-based interaction. Open your sheet in the Google Sheets app and navigate to the row you want to freeze (select the first row below your headers).

On both Android and iOS, tap the menu icon (three horizontal lines on Android, or the sheet name area on iOS) and look for the Freeze option. Tap it and choose how many rows to freeze. The app immediately applies the freeze, and you’ll see a line marking the freeze boundary. The freeze persists whether you access the sheet on mobile or desktop—the setting is stored with the sheet itself, not your device.

Mobile freezing has the same limitations as desktop: you can only have one freeze boundary per dimension (rows or columns), and you can’t freeze more granular areas. However, for most mobile users who need to view data on the go, freezing the header row is usually sufficient. The mobile app handles frozen rows smoothly during scrolling without lag or jumping.

Freezing Rows vs. Locking Cells: Understanding the Difference

Freezing and locking are two separate features that serve different purposes, and it’s easy to confuse them. Freezing affects only how the sheet looks on your screen. It keeps certain rows or columns visible while you scroll, but it doesn’t protect the data from being edited. Anyone with editing access can still change, delete, or modify cells in frozen rows.

Locking cells is a protection feature that prevents editing. You can lock cells by opening the sheet protection settings (Data > Protect sheets and ranges), which let you specify which cells nobody can edit without the sheet password. You might lock frozen header rows to prevent someone from accidentally changing column names, or you might lock certain data cells while allowing editing in other areas.

These features work well together. A typical scenario would be freezing row 1 (for visibility) and then protecting row 1 (to prevent accidental edits to headers). You can also freeze and protect different ranges independently. For example, you might freeze rows 1-2 for visibility but protect only row 1, leaving row 2 editable. To understand more about creating structured data entry in Google Sheets, you might also consider combining freezing with drop-down lists.

Using Frozen Rows with Sorting and Filtering

One of the most powerful combinations in Google Sheets is using frozen rows together with sorting and filtering. When you freeze your header row and then apply an AutoFilter (Data > Create a filter), the filter controls appear in the frozen header row. This means the filter buttons stay visible while you scroll through your data, making it easy to adjust filters without having to scroll back to the top.

If you try to sort data in a sheet with frozen rows, Google Sheets is smart enough to exclude the frozen rows from the sort. This prevents your headers from getting shuffled into the middle of your data, which would be a disaster. The sort applies only to the unfrozen rows below, keeping headers in their proper place.

This intelligent behavior is why freezing is so essential for sheets with many rows. You can apply complex filters, sort by multiple columns, and always see what you’re sorting by because the headers remain frozen at the top. If you haven’t yet explored conditional formatting in Google Sheets, combining it with frozen rows lets you highlight important data while keeping column names visible.

Freeze Rows in Large Datasets

Large datasets with hundreds or thousands of rows benefit enormously from freezing. If your sheet has 500 rows of data and 30 columns, freezing both the header row and the first column creates a four-quadrant view. The top-left frozen area shows your fixed headers, the top-right shows column headers while you scroll horizontally, the bottom-left shows row labels while you scroll vertically, and the bottom-right shows your actual data that scrolls in both directions.

For very large sheets, consider whether you actually need every row visible. Using sorting and filtering to narrow down what you’re viewing, combined with frozen headers, often works better than trying to view thousands of rows at once. A practical workflow might be freezing row 1, filtering to show only relevant data, then scrolling through the filtered results with headers always visible.

Performance rarely becomes an issue with frozen rows in Google Sheets. The feature is lightweight and doesn’t slow down scrolling or calculations. Even sheets with thousands of rows and dozens of frozen rows handle smoothly, so freezing is a free optimization with no downside.

Keyboard Shortcuts and Workarounds

Google Sheets doesn’t have a direct keyboard shortcut for freezing rows, which means you always need to use the View menu. However, if you use the freezing feature frequently, you might consider creating a Google Apps Script macro to automate it. A simple macro can select row 2 and apply the freeze in one keystroke, saving a few clicks each time you create a new sheet.

To create a macro, open Tools > Macros > Create a new macro. Record yourself freezing row 1, then save the macro with a custom keyboard shortcut. The next time you open a sheet and want to freeze, use your shortcut instead of navigating the menu. This is especially useful if you create many new sheets with similar structures.

Another workaround for very specific use cases is using Google Sheets on the web versus the offline version. Both support freezing identically, so there’s no advantage to either version for this feature. The web version is recommended because it’s always up to date and syncs instantly with shared sheets.

Common Issues and Troubleshooting

Sometimes the freeze line doesn’t appear visually, even though the freeze is active. This usually happens when your header row and data rows have the same background color or when you’re zoomed in very close. The freeze still works; you just can’t see the gray dividing line clearly. Zooming out slightly or applying a background color to your header row makes the freeze line more obvious.

Another common issue is accidentally selecting the wrong row and freezing too many rows, or freezing starting from the wrong position. If this happens, simply select the correct row and use View > Freeze > Up to current row again to replace the freeze. There’s no limit to how many times you can adjust the freeze.

On mobile devices, some users report that the freeze appears not to work while scrolling, but this is usually a visual lag that resolves when scrolling stops. The frozen rows do stay in place even if it doesn’t look perfectly smooth during active scrolling. If the freeze genuinely isn’t working on mobile, try closing and reopening the app, or access the sheet through a web browser instead.

FAQ