To freeze panes in Excel for Microsoft 365 on Windows, select the cell immediately below the rows and to the right of the columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes. For a quick preset, choose View > Freeze Panes > Freeze Top Row or Freeze First Column.
What Freeze Panes Does
Freeze Panes keeps selected worksheet rows or columns on screen while you scroll through the rest of the sheet. It is especially useful when a large list extends beyond the window: you can keep column labels, dates, product names, or other identifying information visible as you move down or across the data.
The feature changes the worksheet view, not the data itself. It does not lock cells against editing, protect formulas, or stop rows and columns from being moved or changed. It also does not change the printed pages. When you print a long worksheet and want its headings repeated on each page, use Page Layout > Print Titles instead.
Excel draws a boundary to show the frozen area. The cells above and to the left of that boundary stay in place; the remaining worksheet scrolls. A freeze setting applies to the active worksheet, so you can set up different panes on different sheets in the same workbook.
Freeze the Top Row or First Column
Excel provides two presets for common layouts. They do not depend on the currently selected cell:
- Keep the first row visible: choose View > Freeze Panes > Freeze Top Row. This is useful when row 1 contains field names such as Date, Customer, and Amount.
- Keep the first column visible: choose View > Freeze Panes > Freeze First Column. This can help when column A contains names or product descriptions and you need to scroll horizontally.
After applying either preset, scroll down or sideways to confirm the expected labels remain on screen. The first-row option freezes row 1, not whichever row happens to contain a heading. If your headers are lower down because the sheet has a title or notes above them, use a custom freeze point instead.
Freeze Several Rows or Columns
For a custom arrangement, Excel uses the selected cell to decide where the frozen area ends. It freezes all rows above the selected cell and all columns to its left. The selected cell itself remains in the scrolling area. This means you should click the first cell that you want to scroll, rather than the last cell you want to freeze.
- Click the worksheet cell immediately below the last row you want frozen and immediately to the right of the last column you want frozen.
- Choose View > Freeze Panes > Freeze Panes. Choose the first Freeze Panes command in the menu, not Freeze Top Row or Freeze First Column.
- Scroll down and across to check that the correct rows and columns stay visible.
For example, to keep rows 1 and 2 visible, click A3 before choosing Freeze Panes. To keep columns A and B visible, click C1. To keep both rows 1 and 2 and columns A and B visible, click C3. If you click D4, Excel freezes rows 1 through 3 and columns A through C. A frequent mistake is selecting the last header cell itself; because Excel freezes only the rows above and columns to the left of the selection, that can leave out a row or column you meant to keep.
Choose the Right Freeze Point
Start by identifying what information a reader needs in order to interpret the cells currently on screen. In a sales sheet, that might mean a heading row and a salesperson column. In a schedule, it could be several rows of dates and a column of employee names. Choose the smallest useful frozen area: freezing too many rows or columns leaves less room for the scrolling part of the sheet.
- One header row: use Freeze Top Row when the labels are in row 1; otherwise select the cell below the actual header row and use the custom command.
- Several header or context rows: select a cell in row 2 or lower, depending on how many upper rows should remain visible.
- A row and an identifying column: select a cell below the needed rows and to the right of the needed columns. For row 1 and column A, select B2.
- Only a left-hand label column: use Freeze First Column if the labels are in column A. For labels in another column, use a custom selection.
Consider the size of your Excel window as well. If the frozen section takes up most of the visible area, there may be little room left to inspect the data. You can adjust the window size or choose a smaller freeze area if scrolling feels cramped.
Unfreeze or Change the Panes
To remove the current freeze setting, choose View > Freeze Panes > Unfreeze Panes. Excel returns the worksheet to normal scrolling. To change the boundary, unfreeze first, select the new cell, and apply Freeze Panes again. Choosing one of the presets also changes the current arrangement to that preset, so it is best to unfreeze before setting up a different custom combination.
Freeze Panes is not a toggle that simply moves the boundary each time you click it. If an unexpected line remains, open the menu and check whether Unfreeze Panes is available. Unfreeze the existing setting before trying another selection. The change affects the view, so it does not erase cell contents or formulas.
Common Problems and Misunderstandings
- The wrong row or column stays visible: unfreeze and select the cell one row below and one column to the right of the area you want held in place. Remember that custom freezing works above and left of the selected cell.
- The top-row preset freezes the wrong heading: Freeze Top Row always means worksheet row 1. Use a custom freeze point if your table headings begin farther down.
- Only one of two desired areas is frozen: the Top Row and First Column presets are single-purpose settings. To freeze both, select the cell below the target rows and right of the target columns, then use the main Freeze Panes command.
- The feature appears unavailable: make sure you are not actively editing a cell. Press Enter or Esc to finish or cancel the edit, then try the View menu again. If the workbook is protected or opened in a restricted state, some commands may also be unavailable.
- The frozen lines seem missing: look for the boundary near the selected row or column, then scroll to test the behavior. A narrow window or unusual zoom level can make the frozen region less obvious.
Frozen panes can make navigation easier, but they do not create a permanent header in a printed report. They also do not prevent someone from editing the frozen cells. Use worksheet protection for editing restrictions and Print Titles for repeated printed headings; those features solve different problems.
Freeze Panes Compared with Split
Freeze Panes and Split can both divide the worksheet window, but they behave differently. Freeze Panes holds specific rows at the top and columns at the left while the rest of the sheet scrolls. Split divides the window into separate panes that can be scrolled independently. Split can be useful for comparing distant parts of one worksheet, while Freeze Panes is generally better for keeping labels visible as you inspect a long table.
For example, if you need to compare a row near the top with another far down the sheet, a split view may help because the panes can show different worksheet locations. If your main need is to keep row 1 and column A visible as you browse the data, use Freeze Panes. Avoid applying both until you understand the resulting view; if the worksheet is already split, remove or adjust that split before troubleshooting a freeze setting.
Excel on Mac and in a Browser
In Excel for Microsoft 365 on Mac, the same selection logic applies. Use the View tab or View menu and choose Freeze Panes, then select the appropriate option; menu presentation can vary slightly with the Excel interface. Mac keyboard shortcuts differ from Windows, and there is no need to use a shortcut for this task.
In Excel for the web, open the View tab and use its Freeze Panes controls. The available commands and layout may differ slightly from the Windows desktop ribbon, but the basic choices are similar. If a workbook is open in a browser and a command is missing or behaves differently, opening it in the desktop app can provide the full desktop ribbon and its options.
Frequently Asked Questions
How do I freeze the first two rows in Excel?
Select A3, then choose View > Freeze Panes > Freeze Panes. Excel keeps rows 1 and 2 visible while the lower rows scroll.
How do I freeze the top row and first column at the same time?
Select B2, then choose View > Freeze Panes > Freeze Panes. The custom command freezes the row above and the column to the left, keeping row 1 and column A in view.
Can I freeze rows that are not at the top?
Freeze Panes holds rows above the selected cell, not an isolated row in the middle of the worksheet. For example, selecting A6 freezes rows 1 through 5; it cannot freeze only row 5 while allowing rows 1 through 4 to scroll.
Does freezing panes affect printing?
No. Freeze Panes controls the on-screen worksheet view. To repeat heading rows on printed pages, go to Page Layout > Print Titles and set the rows to repeat at the top.
How do I remove frozen panes in Excel?
Choose View > Freeze Panes > Unfreeze Panes. You can then leave the sheet unfrozen or select a new cell and apply a different freeze arrangement.
Related
- Excel Shortcut Keys Practice: Drills That Build Speed
- Excel Zoom Shortcuts: How to Zoom In and Out Quickly
- Excel Shortcut Keys for Switching Between Worksheets
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Consolidate Lists With Duplicates: Keep or Remove?To combine lists and keep repeated items in Excel for Microsoft 365 on Windows, enter =VSTACK(A2:A5,B2:B4) in an…
- Excel Not Responding: Causes, Checks, and Practical FixesWhen Excel says “Not Responding,” first give it a few minutes if it may be calculating or opening…
- Remove a Section Break in Word Without Losing LayoutTo remove a section break in Word, show formatting marks, place the cursor immediately before the break, and…
- Change Hours View in Outlook Calendar: A Step-by-Step GuideTo change the hours view in Outlook Calendar, adjust the time scale to make each calendar row represent…
- How to Add a Back Cover Page in Microsoft Word DocumentsTo add a back cover page in Microsoft Word, place your cursor at the end of the document,…
- How to Create Multiple Labels in Word, Step by StepTo create multiple labels in Microsoft Word, choose a label size, then either fill a sheet with the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.