How to Lock Cells in Excel While Scrolling a Worksheet

To keep headings or columns visible while you scroll in Excel for Microsoft 365 on Windows, select the cell just below and to the right of the rows and columns you want to keep on screen, then choose View > Freeze Panes > Freeze Panes. If you mean preventing people from changing cell contents, use Review > Protect Sheet instead. These are different features: freezing affects what stays visible as you scroll; protection affects what can be edited.

Excel cannot pin any random cell in the middle of a worksheet while the rest of the grid scrolls around it. Freeze Panes keeps rows at the top and columns at the left in view. If your goal is to keep a title row, labels, or an identifying column visible as you work through a large sheet, it is usually the right tool. If you want cells to remain unchanged, follow the worksheet-protection instructions below.

What You’ll Need

Excel for Microsoft 365 on Windows, or Excel for the web or Mac if you want to use the version notes below.
A worksheet with data arranged so the rows or columns you want to keep visible are at the top or left of the sheet.
If you want to prevent edits, decide which cells should remain editable before turning on sheet protection. A password is optional.

Step-by-Step

Keep rows or columns visible while scrolling

Open the worksheet and identify what should stay visible. For example, a sales table may have its headings in row 1 and employee names in column A. Freeze Panes can keep those top rows and left-hand columns in view while you move through the rest of the sheet. It does not move, copy, or alter the underlying data.
Select the cell below and to the right of the area to freeze. Excel freezes every row above the selected cell and every column to its left. To keep row 1 visible, select a cell in row 2. To keep column A visible, select a cell in column B. To keep row 1 and column A visible together, select B2. For a larger frozen area, select the first cell outside it: selecting C4 freezes rows 1 through 3 and columns A through B.
Open the Freeze Panes menu. On Windows, choose the View tab on the ribbon, then choose Freeze Panes in the Window group. In the menu, choose Freeze Panes to freeze both the rows above and columns to the left of your selection. The menu also offers Freeze Top Row and Freeze First Column for common one-step cases.
Check that the right area is fixed. Scroll down or across the worksheet. The frozen rows should remain at the top, and the frozen columns should remain on the left. A thin line at the edge of the frozen area indicates where the scrolling section begins. If the wrong rows or columns stay visible, unfreeze and repeat the selection carefully.
Use a preset when you only need one edge. If you only want the first row, choose View > Freeze Panes > Freeze Top Row; you do not need to select a cell first. To keep only column A visible, choose View > Freeze Panes > Freeze First Column. These presets are convenient for a simple table, but they do not freeze both a heading row and a label column at once.
Remove the freeze when it is no longer useful. Choose View > Freeze Panes > Unfreeze Panes. This returns the worksheet to ordinary scrolling without deleting or changing any data. If the menu offers Unfreeze Panes, a freeze is currently active. You can then select a different cell and apply a new freeze arrangement.

Prevent cells from being edited

Decide which cells people should be allowed to change. By default, Excel marks cells as locked, but that setting has no effect until you protect the worksheet. If users should enter information in certain cells, select those cells first. To select a range, drag across it or enter its address in the Name Box to the left of the formula bar.
Unlock the cells that should remain editable. Right-click the selected cells and choose Format Cells, then open the Protection tab and clear Locked. Choose OK. Repeat for any other input ranges. Leave the cells you want to protect marked as Locked. The locked setting controls editing after protection is enabled; it does not freeze the cells on screen.
Turn on worksheet protection. Choose Review > Protect Sheet. In the dialog, choose which actions users are permitted to perform, such as selecting locked or unlocked cells. You can enter a password, but it is optional. If you set one, keep it somewhere safe: Excel may require it to remove protection later. Choose OK, and confirm the password if Excel asks you to.
Test the result. Try changing one of the cells that should be protected; Excel should block the edit. Then try an unlocked input cell; it should still accept changes if the selected protection options allow users to select it. To make changes to protected cells yourself, choose Review > Unprotect Sheet, enter the password if prompted, make the changes, and protect the sheet again if needed.

In Excel for Mac, the equivalent Freeze Panes controls are on the View tab, under Freeze Panes; menu wording or layout can vary slightly by release. Worksheet protection is available from the Review tab. In Excel for the web, use the View tab and its Freeze Panes options to keep rows or columns visible; some desktop dialog options may be arranged differently or unavailable. If you cannot find a command, check that you are editing the workbook in Excel rather than viewing it in a read-only preview.

Common Mistakes

Choosing the wrong cell before freezing. Excel freezes rows above and columns to the left of the active selection, not the row and column containing it. Selecting A2 freezes row 1 but no columns; selecting B1 freezes column A but no rows. For row 1 and column A together, select B2.
Expecting Freeze Panes to protect content. A frozen heading can still be edited unless the sheet is protected. Freeze Panes is a viewing aid, not a security or editing control.
Expecting protection to keep cells visible. Protect Sheet restricts permitted actions, but the worksheet still scrolls normally. Use Freeze Panes if labels disappear as you move through the data.
Trying to freeze a cell in the middle of the sheet. Freeze Panes only fixes a continuous block of top rows and left columns. It cannot hold a separate interior cell in place while other cells scroll independently.
Forgetting that locked cells are not protected until the sheet is protected. Clearing or checking Locked in Format Cells alone does not block edits. You must turn on Protect Sheet for the setting to take effect.
Protecting the sheet before unlocking input cells. If all cells remain locked, users may not be able to enter data where you expect. Unprotect the sheet, unlock the intended input ranges, and protect it again.

Tips

Keep the frozen area compact. Freeze only the headings and identifying columns people need as context. A tall frozen section or several wide frozen columns leave less room for scrolling through the actual data.
Use a clear test point. Before sharing the workbook, scroll well down and to the right. This quickly confirms whether the intended headings and labels remain visible in both directions.
Separate input cells visually. A fill color or clear label can show users which cells are intended for entry. Formatting is only a visual cue, so pair it with unlocked cells and sheet protection if you need to restrict edits.
Set protection permissions deliberately. Protect Sheet lets you permit or block actions such as selecting locked cells, formatting cells, or sorting. Choose only the permissions your users need. Protection is designed to prevent accidental changes, not to encrypt sensitive workbook data.
Save after setting up the view and protection. Save the workbook, close it, and reopen it to confirm the arrangement behaves as expected for the people who will use it. If the workbook is shared, ask another user to check the protected input areas.

Troubleshooting

The wrong row or column stays visible. Choose View > Freeze Panes > Unfreeze Panes first. Select the cell below and to the right of the exact area you want frozen, then apply Freeze Panes again. Remember that selecting C4 freezes rows 1 to 3 and columns A to B.

The Freeze Panes command is unavailable or does not seem to work. Confirm that the workbook is open for editing and that you are on the worksheet you intend to change. If the sheet is protected or the workbook is in a restricted view, remove the restriction or open an editable copy if you have permission. Also check whether the worksheet is already frozen; choose Unfreeze Panes before setting a different boundary.

Some headings disappear but others stay. Check whether you froze the right number of rows and columns. Freeze Panes only keeps rows above and columns left of the selected cell. It will not keep a heading farther down the sheet fixed while you scroll past it. Move the headings to the top, or use a layout that places the labels in the frozen top area.

Users can still edit cells after you marked them Locked. Protect Sheet may not be enabled, or the cells may have been unlocked previously. Choose Review > Unprotect Sheet if necessary, select the cells, open Format Cells > Protection, and check Locked. Then choose Review > Protect Sheet. Test by attempting a change in a locked cell.

Users cannot enter data in the intended input cells. Unprotect the worksheet, select the input range, clear Locked in Format Cells > Protection, and turn protection back on. Also review the Protect Sheet options to ensure users can select unlocked cells. If protection uses a password you do not know, ask the workbook owner; do not assume Excel can recover it.

The worksheet scrolls but the frozen area seems unusually large. Unfreeze and inspect the selection you used. A selection far down or far to the right freezes every row above and column to the left, even if you intended to freeze only one heading row. Select B2 for just the first row and first column, or A2 for the first row alone.

Frequently Asked Questions

Can I lock just one cell so it stays visible while scrolling?
Not with Freeze Panes. It keeps a continuous block of rows at the top and columns at the left, rather than pinning one arbitrary cell. Put the important label in a top row or left column and freeze that area.

How do I freeze the top row and first column at the same time?
Select B2, then choose View > Freeze Panes > Freeze Panes. Excel keeps row 1 and column A visible as you scroll.

Will freezing panes change or move my data?
No. It changes the worksheet view only. It does not rearrange cells, edit values, or prevent someone from changing the data.

Can I freeze more than one row or column?
Yes. Select the cell immediately below the last row and immediately to the right of the last column you want fixed, then choose Freeze Panes. For example, select C4 to freeze the first three rows and first two columns.

Does Protect Sheet stop cells from moving when I scroll?
No. Protection restricts actions such as editing locked cells, depending on the permissions you set. Use Freeze Panes to keep rows or columns visible while scrolling.

Can I use both Freeze Panes and Protect Sheet?
Yes. They solve separate problems: freeze the headings or labels for easier navigation, then protect the sheet if you also need to restrict edits. Set up and test each feature independently.

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.