Google Sheets Freeze Rows Greyed Out? Causes and Fixes

If Freeze rows is greyed out in Google Sheets, first make sure you can edit the spreadsheet and that you are not currently typing in a cell; then click a cell in the sheet grid and open View > Freeze. If the options are still unavailable, check whether the file is view-only or whether you are using a preview rather than the editable spreadsheet.

What Freeze does in Google Sheets

Freezing keeps selected rows visible at the top of a sheet while you scroll down. It is useful when a long table has headings such as Date, Customer, and Amount: you can move to row 200 and still see what each column means. Frozen rows remain part of the sheet; the feature does not lock cells against editing, create a separate header, or change the data.

In Google Sheets in a web browser, the usual menu path is View > Freeze. Depending on the current selection and the sheet, the submenu offers choices such as No rows, 1 row, 2 rows, or Up to current row. To freeze a custom number of rows, select a cell in the last row you want to keep visible, then choose View > Freeze > Up to current row. For example, selecting a cell in row 3 and freezing up to that row keeps rows 1 through 3 in place.

Freezing is applied to the current sheet tab, not automatically to every tab in the spreadsheet. Each tab can have its own frozen rows and columns. It affects how the sheet appears as you scroll; it does not alter the data for collaborators or change how the sheet prints.

Check editing access first

The most important thing to check is whether your account has permission to edit the file. A viewer or commenter can inspect a spreadsheet but cannot change its layout, and editing commands may be unavailable. Look near the top of the page for an indication that you have view-only access, or ask the owner to grant you Editor access. If the file belongs to an organization, its sharing policy may limit what the owner can grant.

Do not confuse a protected range with a view-only file. Protected sheets and ranges are intended to restrict changes to specified cells or areas. A range protection by itself does not necessarily disable view controls such as freezing rows. If you can edit other cells but Freeze is still grey, check that the sheet is not open in a read-only state and that the restriction is actually an editing restriction on the file, rather than assuming a protected header is the cause.

Confirm that you are signed in to the Google account that has editing access.
Check the sharing details or ask the owner to verify your role.
If you opened a link in a preview, request access or open the actual spreadsheet in Google Sheets.

Exit cell editing and return to the grid

When the insertion cursor is active inside a cell or the formula bar, Sheets is in the middle of an edit. Some sheet commands may be unavailable until that edit is finished. Press Enter to accept the change, or press Esc to cancel it, then click a normal cell and check View > Freeze again. If you are editing a formula, make sure you do not accidentally discard work by cancelling; copy the formula first if you are unsure.

Also make sure the selection is in the spreadsheet grid. Clicking a chart, drawing, image, or another object can put focus on that object rather than on a cell. Click a cell in the row area, such as A1, and reopen the View menu. If you have a cell selected but the menu remains disabled, click a different cell once and check whether the sheet has finished loading or is showing a transient state.

Use the correct menu choice for the rows you need

It is possible for the option you expect to be unavailable because the current selection does not match what you want to do. The basic choices are quick presets: choose 1 row to keep the first row visible, or 2 rows to keep the first two visible. To freeze a larger header, click a cell in the last row of that header and use the option to freeze up to the current row. If you select a cell in row 5, for instance, this keeps rows 1 to 5 visible, not row 5 alone.

Click a cell in the last row that should remain on screen.
Open View > Freeze.
Choose the option that freezes up to the current row, or choose a preset for one or two rows.
Scroll down to confirm the intended rows stay at the top.

If the sheet already has frozen rows, the menu may show the existing state through a checked choice or offer other freeze settings. To remove the freeze, use View > Freeze > No rows. This changes the display behavior but does not delete any content. If you are trying to freeze both the header and the first column, use the corresponding options under the same Freeze submenu; rows and columns are separate settings.

Check which screen or file you opened

Freeze controls are meant for an editable spreadsheet view. A downloaded file opened in a computer preview, a published-to-the-web page, or a static export is not the same as the working Google Sheets grid. Open the original file in Google Sheets rather than relying on a preview. If the link opens a page that only displays data, use the owner-provided editable link or ask for permission.

Google Sheets can also work with Microsoft Excel files. If you are viewing an .xlsx file in Sheets, look for the normal spreadsheet grid and check whether you have edit access; the filename extension alone does not explain a disabled command. If the file behaves unexpectedly, the owner can consider converting it to Google Sheets using File > Save as Google Sheets, where that option is available. Conversion creates a Google Sheets version, so it is sensible to keep the original if preserving the Excel file matters.

Freeze is a Google Sheets interface feature, so instructions for Excel are not interchangeable. Excel has its own Freeze Panes command and its own ribbon layout. If you are actually working in Excel rather than Sheets, follow the instructions for your Excel version instead of looking for the Sheets View menu.

Try browser and loading checks only after permissions

If you have edit access, are in the grid, and the menu is still grey, try a simple refresh after making sure any unsaved cell edit is committed. Wait for the spreadsheet to finish loading, then test the command again. You can also open the file in a current supported browser or a private window to see whether a browser extension or cached page state is interfering. These are general troubleshooting checks, not special requirements for freezing rows.

If the problem occurs only in one browser profile, temporarily disabling extensions that alter pages can help isolate the cause. Avoid removing extensions or changing account settings unnecessarily. If the command is unavailable for several editors and across browsers, ask the file owner to check access and the file state. For a work or school account, an administrator may control sharing or browser access, so the owner may need to involve that administrator.

Common misconceptions and useful alternatives

Freezing rows is not the same as protecting them. A frozen heading stays in view, but an editor can still change its text unless a separate protection rule restricts editing. Conversely, protecting a header does not make it stay visible when scrolling. These features solve different problems: freeze for navigation, protection for limiting edits.

It is also different from grouping or hiding rows. A collapsed group hides detail rows temporarily, while freezing keeps chosen rows visible. Filters can help narrow a table to relevant records, but they do not pin the header in place. For a large data set, you might use both a frozen header and a filter, provided the sheet’s layout and permissions allow those features.

Use frozen rows when you need column labels to remain visible during vertical scrolling.
Use protected ranges when you need to limit who can edit particular cells.
Use filters or filter views to focus on matching records rather than to keep headings fixed.
Use row grouping when readers need to expand and collapse sections of detail.

If you cannot change the original because you have view-only access, you may be able to make a copy if the owner allows copying. A copy is separate from the source and will not update the original, so it is not a substitute when collaborators need the change in the shared file. The cleanest fix is usually to ask for the required edit permission.

Frequently Asked Questions

Why is Freeze greyed out in Google Sheets?
Usually the file is not editable for your account, the spreadsheet is open in a preview or read-only view, or you are editing a cell or focused on an object instead of the grid. Check access, finish any active edit, and select a cell before reopening View > Freeze.

How do I freeze more than two rows?
Click a cell in the last row you want to keep visible, then choose View > Freeze > Up to current row. Freezing up to row 4 keeps rows 1 through 4 visible as you scroll.

Can I freeze a row that is not at the top?
Sheets freezes rows from the top through the row you select; it does not pin an isolated middle row while allowing the rows above it to scroll independently. If you choose row 5, rows 1 through 5 are frozen together.

Does protecting a row stop me from freezing it?
Protection controls editing, while freezing controls what remains visible during scrolling. A protected range is not the same as view-only access. If Freeze is disabled, check your file-level editing access and current screen before changing protection settings.

How do I unfreeze rows in Google Sheets?
Open View > Freeze > No rows. The rows will scroll normally again, and the values and formatting in them remain unchanged.

Will freezing rows change the printed sheet?
No. Freezing is for on-screen navigation while scrolling. It does not by itself repeat a header on printed pages; print settings are separate.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.