To keep a row visible while you scroll in Excel for Microsoft 365 on Windows, select View > Freeze Panes > Freeze Top Row. To keep several rows visible, select the first cell below them in column A, then choose View > Freeze Panes > Freeze Panes. The row stays on screen; it is not locked against editing.
What “locked row” means in Excel
People often say a row is “locked” when they want it to remain visible at the top of a worksheet as they move down through a long list. Excel calls this feature Freeze Panes. It fixes selected rows or columns in place in the worksheet window while the rest of the sheet scrolls. This is useful when column headings disappear from view, or when a label or identifier needs to remain visible beside the data.
Freeze Panes does not prevent someone from changing the cells in a row. It is also different from locking cells and protecting a worksheet, which are tools for restricting edits. The wording can be confusing: freezing is about what stays in view; cell protection is about what users can change. If your goal is only to keep headings visible, use Freeze Panes rather than worksheet protection.
Keep the top row visible
For a simple table with headings in row 1, use the dedicated Freeze Top Row command:
- Open the worksheet you want to work with.
- Select View on the ribbon.
- Choose Freeze Panes, then Freeze Top Row.
- Scroll down to confirm that row 1 remains visible.
The command freezes the worksheet’s first row, not necessarily the row that contains your headings. For example, if a title occupies row 1 and column labels are in row 3, Freeze Top Row will keep the title visible, not row 3. To keep rows 1 through 3 visible, use the custom selection method instead. This distinction is especially important when a worksheet has introductory notes, blank rows, or a multi-line heading area above its actual data.
Freeze Top Row affects the current worksheet, not every sheet in the workbook. If several worksheets need the same treatment, apply the command on each one. You can also freeze panes in one worksheet and leave another worksheet free to scroll normally.
Freeze several rows or both rows and columns
For a custom freeze, Excel uses the selected cell to decide which rows and columns stay in view. The rows above the selected cell and the columns to its left are frozen. The selected cell itself is not included. Select a cell in the worksheet body, then choose View > Freeze Panes > Freeze Panes.
- Freeze rows 1 through 3: select A4, then choose Freeze Panes. The rows above A4 stay visible, and no columns are frozen.
- Freeze column A and rows 1 through 3: select B4, then choose Freeze Panes. Column A is to the left of the selection, and rows 1 through 3 are above it.
- Freeze the first two columns only: select C1, then choose Freeze Panes. Columns A and B stay visible; no rows are frozen.
After freezing, a horizontal or vertical divider indicates the boundary between the fixed area and the scrolling area. The precise appearance depends on the worksheet and window size. If the result is not what you intended, unfreeze the panes and make a new selection rather than trying to drag the boundary.
How Freeze Panes works—and what it does not do
A frozen area remains in the worksheet window while the unfrozen area moves as you scroll. It does not change the order of rows, insert a duplicate heading, or make a special copy of the cells. The visible cells are still the original cells in the worksheet. Editing a frozen heading changes that cell just as it would without freezing.
Freeze Panes is also a view setting, not a print setting. A heading that stays visible on screen will not automatically repeat on every printed page. To repeat rows when printing, use Page Layout > Print Titles and set the rows to repeat at the top in the Page Setup dialog. Likewise, freezing a row does not make it a filter header; for sorting and filtering, format the data as a table or use the filter controls separately.
These distinctions help diagnose the request behind “Excel row locked scrolling.” If a row should stay on screen, freeze it. If it should repeat on printed pages, set print titles. If users should not edit it, consider cell locking and sheet protection, while remembering that protection is a separate feature and should not be treated as a substitute for appropriate file security.
Unfreeze rows and change the frozen area
Excel generally allows one frozen pane arrangement at a time on a worksheet. To remove it, select View > Freeze Panes > Unfreeze Panes. You can then choose a different option or select a new cell and freeze a different combination. For instance, change from just the top row to the first three rows by unfreezing, selecting A4, and choosing Freeze Panes.
If the Freeze Panes menu shows an option to unfreeze, that is a sign a frozen area is already active. Unfreezing does not delete rows, move data, or alter formulas; it only changes how the sheet scrolls. This makes it safe to adjust when the wrong rows or columns have been fixed in view.
Common problems and practical fixes
- The wrong row stays visible: Freeze Top Row always targets row 1. If your headings are lower down, unfreeze and use a cell directly beneath the rows you want to keep.
- The wrong columns are frozen too: The selected cell was not in column A. For rows only, select a cell in column A beneath the rows to freeze, such as A4 for the first three rows.
- Nothing seems to happen: Try scrolling the worksheet, not just looking at it immediately after choosing the command. Also check whether the worksheet is in a view or window arrangement that makes the boundary hard to notice.
- You cannot find Freeze Panes: Make sure you are on the View tab and looking for the Freeze Panes menu. In the Windows desktop app, its placement can vary slightly with ribbon layout or window size.
- A frozen row is not protected: Freezing has no effect on editing permissions. Use cell protection and worksheet protection if restricting edits is the actual goal.
- The row does not repeat on paper: Set Print Titles under Page Layout. Freeze Panes controls the on-screen view, not printed page headers.
In a shared workbook, frozen panes can also be a matter of personal preference. A colleague may prefer a different view, so it can help to explain which rows are kept visible and why. Always check the actual worksheet after changing the setting, particularly when the heading area contains merged cells, blank rows, or multiple levels of labels.
Excel for the web and Mac differences
In Excel for the web, the View tab also provides Freeze Panes options, though the ribbon layout and wording can vary with the browser window and product updates. Look under View for Freeze Panes; use the top-row option for row 1 or select the cell below the desired rows and choose the custom freeze command. If an option is unavailable in the browser version, open the workbook in the Excel desktop app and set it there.
In Excel for Mac, use the View menu or ribbon and choose Freeze Panes, then the relevant freeze or unfreeze option. Names and menu placement can differ somewhat from Windows, but the selection rule for a custom freeze is the same: rows above and columns to the left of the selected cell are kept in view. Keyboard shortcuts also differ between Windows and Mac, so the ribbon or menu path is the clearest cross-platform instruction.
Frequently Asked Questions
How do I lock a row in Excel so it stays visible when I scroll?
Choose View > Freeze Panes > Freeze Top Row to keep row 1 visible. For a different or multiple rows, select the cell directly below the rows to keep, then choose View > Freeze Panes > Freeze Panes.
How do I freeze row 3 instead of row 1?
To keep rows 1 through 3 visible, select A4 and choose View > Freeze Panes > Freeze Panes. Excel freezes all rows above the selected cell, so it cannot freeze row 3 alone while allowing rows 1 and 2 to scroll independently.
Can I freeze a row and a column at the same time?
Yes. Select a cell below the rows and to the right of the columns you want to freeze. For example, select B4 to keep rows 1 through 3 and column A visible, then choose Freeze Panes.
Why does Freeze Top Row keep the wrong row visible?
That command is specifically for worksheet row 1. If your headings are in a lower row, use the custom Freeze Panes command with a selection beneath the heading area instead.
How do I unlock or unfreeze a row in Excel?
Choose View > Freeze Panes > Unfreeze Panes. This removes the frozen view; it does not unlock protected cells or change worksheet protection settings.
Related
- Data Validation Process: Steps, Checks, and Best Practices
- Data Validation Named Range in Excel: Setup and Fixes
- Data Validation Reference Table in Excel
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Shortcut Keys With Ctrl, Alt, and Shift ExplainedExcel has several useful shortcuts that combine Ctrl, Alt, and Shift, but there is no single shortcut that…
- Signature Line in Word Without the X Placeholder SymbolTo add a signature line in Word without the “X,” make a blank paragraph and apply a bottom…
- Remove Duplicates in Excel: Steps, Checks, and Safe OptionsYes. In Excel for Microsoft 365 on Windows, select your data, choose Data > Remove Duplicates, select the…
- Excel: Import Multiple CSV Files Into One WorksheetTo import multiple CSV files into one Excel worksheet, put the files in a folder, then use Data…
- Excel Hide Columns Based on Date: Methods That WorkYes—Excel can hide columns according to dates, but a formula alone cannot change a column’s hidden state. For…
- Add a Drop-Down List in Excel: Setup, Tips, and FixesTo add a drop-down list in Excel for Microsoft 365 on Windows, select the cells, choose Data >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.