To freeze panes in Excel on Windows 11, 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. Excel keeps those rows and columns on screen as you scroll through the rest of the worksheet. For a simpler setup, use the Freeze Top Row or Freeze First Column option.
These steps are for Microsoft Excel for Microsoft 365 on Windows; Windows 11 does not change the Excel commands. Save your workbook before making changes if you want a convenient backup. Freeze Panes changes how a worksheet appears on screen, not the worksheet’s data or print layout.
What You’ll Need
- Excel for Microsoft 365 on a Windows 11 PC, with a workbook and worksheet open.
- A clear idea of which heading rows or identifier columns should remain visible while scrolling.
- Permission to change the workbook view. No formula, add-in, or special Windows setting is required.
Step-by-Step
- Open the worksheet you want to work on. Click its sheet tab at the bottom of the Excel window. Freeze Panes applies to the active worksheet, so check that you are on the intended tab. If the workbook has several sheets, you will need to set the view on each sheet separately.
- Decide which rows and columns should stay in place. Excel freezes the rows above the selected cell and the columns to its left. For example, if row 1 contains headings and column A contains names, you will select cell B2 to keep both the heading row and the name column visible. The selected cell itself is not frozen; it marks the boundary.
- Select the boundary cell. Click the cell just below the last row you want to freeze and just to the right of the last column you want to freeze. To keep rows 1 through 3 visible, select a cell in row 4. To keep columns A and B visible, select a cell in column C. To freeze both those rows and columns, select C4. Use the Name Box, to the left of the formula bar, if navigating to a particular cell is easier than scrolling.
- Open the View tab. On the Excel ribbon, click View. Find the Freeze Panes control, usually in the Window group, and click its drop-down arrow. If you cannot see the control, maximize the Excel window or expand the ribbon; a narrow window can collapse ribbon groups.
- Choose the appropriate command. Select Freeze Panes in the drop-down to apply the boundary cell you selected. For the common case of keeping only the first row visible, choose Freeze Top Row. To keep only column A visible, choose Freeze First Column. These two preset commands do not combine; use the general Freeze Panes command with a boundary cell when you need both a row and a column held in place.
- Check the result by scrolling. Scroll down to confirm that the chosen top rows remain visible, then scroll right to confirm that the chosen left columns stay in view. A thin line marks the edge of the frozen area. If the visible boundary is not where you intended, unfreeze the panes and repeat the selection with the correct cell.
- Change or remove the frozen area when needed. To replace the current setup, first choose View > Freeze Panes > Unfreeze Panes, then select a new boundary cell and apply Freeze Panes again. Excel uses one frozen-pane arrangement at a time on a sheet. Unfreezing changes the view; it does not delete or alter any worksheet content.
Example: Suppose a sales list has headings in row 1, salesperson names in column A, and many months of data extending across the sheet. Select B2, then choose View > Freeze Panes > Freeze Panes. Row 1 stays at the top when you scroll down, while column A stays at the left when you scroll sideways. Select A2 instead if you want only the heading row to remain fixed.
Common Mistakes
- Selecting the heading cell instead of the boundary. To freeze row 1 and column A, selecting A1 will not do the job. Select B2: Excel freezes what is above and to the left of the selected cell.
- Choosing a preset when you need a custom combination. Freeze Top Row holds the top row, and Freeze First Column holds column A. Using one preset after the other is not a reliable way to create a combined arrangement. Unfreeze first, then use a boundary cell with the general Freeze Panes command.
- Expecting the frozen area to follow the data. Freeze Panes holds worksheet rows and columns in place; it does not identify a heading by its text or keep a particular record visible. If rows are inserted or data is reorganized, check the boundary again.
- Confusing Freeze Panes with Split. Split divides the worksheet window into independently scrollable sections. It is a different view feature and can make the sheet look as if freezing did not work. If you see separate scroll areas, turn off Split on the View tab, then set the frozen panes you want.
- Assuming the setting applies to the whole workbook. The setting is for the active sheet and window, not every worksheet. Check each relevant sheet rather than expecting a change on one tab to carry over to all the others.
Tips
- Keep the frozen area small. Freezing several rows or columns can leave little room to view the scrolling data, especially on a laptop display. Freeze only what people need to identify the information below or beside it.
- Use a test scroll before sharing. Try both vertical and horizontal scrolling. A worksheet may need only a top row, only a left column, or a custom combination, and testing reveals whether the choice is useful.
- Remember the boundary rule. If you want to freeze the first two rows and the first column, select B3. If you want to freeze the first two columns and the first row, select C2. In each case, the selected cell sits just outside the frozen area.
- Save after arranging the view. Save the workbook normally so your changes are retained with it. When reopening, check the sheet if its viewing arrangement matters to other people or if they use a different Excel app.
- Use the right feature for printing. Freeze Panes helps while viewing and scrolling on screen. To repeat headings on printed pages, use Page Layout > Print Titles instead; that is a separate print setting.
Troubleshooting
The wrong rows or columns stay visible. Choose View > Freeze Panes > Unfreeze Panes. Click the correct boundary cell, then choose Freeze Panes again. Remember that Excel freezes all rows above and columns to the left of that cell, not the cell itself. For example, if three top rows and column A should stay visible, use B4.
Nothing seems to happen. Scroll the worksheet to test the result; freezing at the current top row or left edge may be hard to notice until you move away from it. Also make sure you did not select A1, which has no rows above or columns to its left. Look for the thin divider marking the frozen boundary.
The Freeze Panes command is unavailable. If you are editing a cell, press Enter to finish the edit or Esc to cancel it, then try again. Check that the View tab is open and that you are in the normal worksheet view. If the ribbon is collapsed or simplified, expand it or maximize the window so the Window group is accessible. If another view arrangement is active, turn off Split and retry.
The setting is missing on another sheet or after reopening. Select the sheet you intend to use and inspect its view; the setting is not automatically applied across all tabs. Save the workbook after setting the panes. If someone opens the file in a different program or an older app, its view behavior may differ.
You are using Excel for the web or a Mac. In Excel for the web, look for View > Freeze Panes; the available commands can vary with the web interface. In Excel for Mac, use the View > Freeze Panes menu, with the same boundary-cell principle. Ribbon layout and keyboard behavior differ across platforms, so follow the menu labels shown in your version rather than Windows KeyTips.
Frequently Asked Questions
Can I freeze the top row and first column at the same time?
Yes. Select B2, then choose View > Freeze Panes > Freeze Panes. The top row and column A remain visible. The separate Freeze Top Row and Freeze First Column presets are not a combined command.
How do I freeze more than one row?
Select a cell in the row immediately below the rows you want to hold, then use Freeze Panes. To keep rows 1 through 4 visible, select a cell in row 5. Excel freezes the rows above the active cell.
Can I freeze a column other than column A?
Yes. Select a cell immediately to the right of the last column to keep visible, and use the general Freeze Panes command. For example, select C1 to hold columns A and B while scrolling horizontally.
Can I freeze panes in more than one worksheet?
Yes, but set the arrangement on each sheet individually. Select the sheet, choose its boundary cell, and apply Freeze Panes. Avoid grouping sheets unless you intend other edits to affect all selected sheets too.
Does Freeze Panes affect printing or change my data?
No. It changes the on-screen scrolling view and does not change cell values or formatting. For repeated print headings, use Page Layout > Print Titles; for changing worksheet content, edit the cells themselves.
Is there a keyboard shortcut in Excel for Windows?
There is no single universal shortcut that directly applies a chosen frozen-pane boundary. Use the View tab and its Freeze Panes menu, or use the ribbon KeyTips displayed by your Excel installation. Mac and web keyboard behavior may differ.
Related
- Find the Financial Year From a Date in Excel Easily
- How to Find Errors in Excel: A Practical Workbook Guide
- How to Find Exact Duplicate Names 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
- How to Add Roman Numeral Page Numbers in Word: StepsTo add Roman numeral page numbers in Word, choose Insert > Page Number > Format Page Numbers, select…
- Merge Cells in Excel: How to Add, Use, and Unmerge ThemTo merge cells in Excel, select the adjacent cells, then choose Home > Merge & Center. Use the…
- How to Make Two Columns in WordTo make two columns in Microsoft Word for Microsoft 365 on Windows, open the Layout tab, select Columns,…
- Create a DAX Measure in Excel: Step-by-StepTo create a DAX measure in Excel for Microsoft 365 on Windows, add your data to the workbook’s…
- Add a Confidential Watermark in Microsoft WordTo add a confidential watermark in Microsoft Word for Microsoft 365 on Windows, open the document and select…
- Switch Excel Cell References: F4 and Reference TypesTo switch a formula reference between relative, absolute, and mixed types in Excel for Microsoft 365 on Windows,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.