To edit frozen panes in Excel, open View > Freeze Panes, choose Unfreeze Panes, then select the cell that sets the new freeze boundary and choose Freeze Panes again. You can also freeze just the top row or first column. Freeze panes keep chosen headings visible while you scroll; they do not lock cells or change what prints.
What You’ll Need
- A workbook open in Microsoft Excel for Microsoft 365 on Windows. The same basic steps are available in current Excel for Mac and Excel for the web, though the ribbon layout may differ.
- A clear idea of which rows and columns should stay on screen. For example, to keep a header row and a names column visible, identify the first cell below and to the right of those areas.
- Edit access to the workbook. If it is read-only, make a copy or ask for permission before changing and saving the pane settings.
Step-by-Step
- Open the worksheet and check its current view. Select the sheet where you want to adjust the panes. If you are in a view that does not offer the usual worksheet controls, go to View > Normal on the Windows ribbon. Look for a thicker gray line across the sheet or down it; that line often marks a freeze boundary. A workbook can have different pane settings on different worksheets, so check the sheet you actually use.
- Unfreeze the current panes. On the ribbon, select View > Freeze Panes > Unfreeze Panes. This removes the existing freeze setting from the active worksheet; it does not delete or move any cells. If the dropdown shows a freeze option instead of Unfreeze Panes, there may not be panes frozen on that sheet. There is no need to clear formatting, hide rows, or change the zoom to remove a freeze.
- Choose what should remain visible. Decide how many top rows and leftmost columns you need while scrolling. If you want rows 1 through 4 and columns A through C to stay visible, the dividing point is the cell immediately below and to the right of them: D5. Excel freezes all rows above the selected cell and all columns to its left. The selected cell itself is not frozen as part of either area.
- Select the boundary cell. Click the cell that sits below the rows and to the right of the columns you want to keep visible. For a header in row 1 only, select A2. To keep the first two rows visible, select A3. To keep column A visible but no rows, select B1. To freeze both row 1 and column A, select B2. Check the cell address in the Name Box, just left of the formula bar, if you are unsure what you selected.
- Apply the custom freeze. With the boundary cell selected, choose View > Freeze Panes > Freeze Panes. Excel draws a horizontal boundary below the frozen rows and a vertical boundary to the right of the frozen columns. Scroll down or sideways to check that the right areas stay in place. If the result is wrong, unfreeze and repeat with the correct cell; you can change the setting without altering worksheet data.
- Use a preset when you only need one edge. For a simple header row, choose View > Freeze Panes > Freeze Top Row. For the leftmost identifier column, choose View > Freeze Panes > Freeze First Column. These presets are convenient when the worksheet starts at row 1 or column A. If your headings are lower down, or you need multiple rows or columns, use a boundary cell and the regular Freeze Panes command instead.
- Adjust or remove the setting later. Excel does not let you grab the freeze line and drag it to a new position. To move the boundary, return to View > Freeze Panes > Unfreeze Panes, select a new boundary cell, and apply Freeze Panes. To remove the effect entirely, choose Unfreeze Panes and leave it there. Save the workbook if you want the change to be available the next time it is opened.
- Check the result in the way you normally work. Scroll down and across the sheet to confirm the headers or labels remain visible and that enough space is left for the data. If you have frozen many rows or columns, the visible scrolling area can become very small. Reduce the frozen area if it crowds the worksheet, and repeat the check at your usual window size.
In Excel for Mac, select the View tab and use the Freeze Panes controls; the cell-selection logic is the same. In Excel for the web, use View > Freeze Panes. If the exact choices differ in your web layout, look for Unfreeze Panes first, then select the desired boundary and apply the freeze command. Changes made in a shared workbook may be visible to other editors, so coordinate before adjusting a shared view.
Common Mistakes
- Selecting the cell you want to freeze instead of the boundary. Excel freezes rows above and columns to the left of the selected cell. Selecting D5 keeps rows 1–4 and columns A–C fixed; it does not freeze row 5 or column D.
- Trying to add a second freeze without removing the first. A worksheet can have one freeze boundary arrangement at a time. Use Unfreeze Panes before setting a different combination of rows and columns.
- Choosing a preset for a nonstandard layout. Freeze Top Row means worksheet row 1, not the first row containing labels. If headings begin on row 5, select A6 and use Freeze Panes to keep rows 1–5 visible, or use a different layout if keeping all those rows is not useful.
- Confusing freezing with splitting or hiding. Freeze panes keep headings fixed while the rest of the sheet scrolls. Split divides the worksheet window into independently scrolling areas, while Hide removes rows or columns from view. These commands behave differently and are not substitutes for a freeze.
- Expecting the setting to lock data or affect printing. Freeze panes are a screen-view aid. They do not prevent edits, protect a worksheet, repeat heading rows on printed pages, or change the workbook’s values.
Tips
- Freeze only what readers need for context. A column of names or product IDs and one or two heading rows are often enough. Freezing a large block can leave too little room to see the data you are trying to compare.
- Use a concrete cell address before clicking. Write down the desired boundary, such as C4 for rows 1–3 and columns A–B. This simple check makes custom freezes easier to set correctly, especially on wide worksheets.
- Test in both directions. A setting can appear correct when scrolling vertically but be wrong when moving horizontally. Try both directions whenever you freeze rows and columns together.
- Keep the top of the sheet intentional. Blank rows above a header count as rows to freeze. If you select A6, rows 1–5 all stay visible, including any blank rows. Consider removing unnecessary blank space or selecting a suitable boundary based on how the sheet is structured.
- Use a separate view when layouts serve different tasks. If one person needs a frozen header and another needs to review the sheet without it, agree on the shared workbook’s view or make a separate copy for a different arrangement. Avoid repeatedly changing a shared sheet’s display while others are working.
- Remember the Mac and web selection rule. Although the ribbon and menu presentation can vary, the key idea remains: choose the cell below and to the right of the area to keep visible. If the setting looks off, unfreeze and set it again rather than trying to move a line.
Troubleshooting
The wrong rows or columns stay on screen. Choose View > Freeze Panes > Unfreeze Panes, then confirm the boundary cell before applying the freeze again. For example, to hold rows 1–2 and columns A–B, select C3. If you selected C2, only row 1 and columns A–B are frozen.
The Freeze Panes command is unavailable or looks different. Confirm that you are in a worksheet rather than another workbook view, and try View > Normal. In Excel for the web or Mac, menu placement can differ from the Windows ribbon. Check the View tab or View menu for the Freeze Panes group, and make sure the workbook is open for editing rather than read-only.
You cannot find the freeze boundary. Look for the gray dividing line near the row numbers or column letters, then scroll to see whether the content on one side stays fixed. If it is still unclear, use Unfreeze Panes and reapply a simple test, such as selecting A2 and choosing Freeze Panes to hold the first row.
The frozen area takes up most of the window. Unfreeze, then choose a cell closer to the top-left corner. Check for blank rows or columns included in the frozen block. Zooming out may help temporarily, but reducing the number of frozen rows or columns is usually the better fix.
The change does not appear to stick. Make sure you changed the correct worksheet and save the workbook. In a shared or coauthored file, another editor may change the view, or your permissions may prevent saving. If needed, reopen the file, check the setting, and ask the file owner for edit access.
Frequently Asked Questions
Can I edit a frozen pane by dragging its border?
No. Excel does not reposition freeze boundaries by dragging. Unfreeze the current panes, select the new boundary cell, and apply Freeze Panes again.
Can I freeze more than one row and one column?
Yes. Select the cell below all rows and to the right of all columns to keep visible, then choose Freeze Panes. For example, select D5 to freeze rows 1–4 and columns A–C.
How do I freeze just the top row or first column?
Use View > Freeze Panes > Freeze Top Row or Freeze First Column. If a previous custom setting is active, unfreeze it first.
Why does Freeze Top Row keep the wrong row visible?
The preset targets row 1 of the worksheet, not the row where your table headings happen to appear. Select the cell immediately below your headings and use the regular Freeze Panes command instead.
Do frozen panes appear on printed pages?
No. Freeze panes affect on-screen scrolling only. To repeat headings when printing, use the separate print title settings under Page Layout > Print Titles in Excel for Windows.
Will freezing panes stop other people from editing cells?
No. It changes the worksheet’s viewing behavior, not its permissions. Use worksheet protection or file-sharing permissions when you need to control editing.
Related
- How to Delete Multiple Cells at Once in Excel
- How to Delete Leading Zeros in Excel Without Losing Data
- Delete Information in Excel Cells: Safe, Clear Steps
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets Link: Open, Share, and Manage AccessThe official Google Sheets link is sheets.google.com; open it in a web browser to find your spreadsheets or…
- Excel Very Slow Saving Files? Causes and FixesIf Excel is very slow saving files, first save a copy to a local folder and compare the…
- How to See Protected Ranges in Google Sheets OnlineTo see protected ranges in Google Sheets, open the spreadsheet in a web browser and choose Data >…
- Google Sheets Daily Schedule Template: Build Your OwnA Google Sheets daily schedule template is a reusable spreadsheet for organizing the day by time, activity, priority,…
- Laptop Excel Shortcut Keys: Essential Windows GuideThe most useful laptop Excel shortcut keys on Windows include Ctrl+C to copy, Ctrl+V to paste, Ctrl+Z to…
- Excel Goal Seek Tutorial: Steps, Examples, and TipsTo use Goal Seek in Excel for Microsoft 365 on Windows, select Data > What-If Analysis > Goal…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.