To freeze chosen rows and columns in Excel, select the cell immediately below the rows and immediately to the right of the columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes. For just row 1 or column A, use Freeze Top Row or Freeze First Column instead. Decide what readers need to keep seeing while they scroll, then place the freeze boundary accordingly.
Freezing panes keeps selected headings or identifiers on screen as you move through a long worksheet; it does not lock cells or change the data. The steps below are for Excel for Microsoft 365 on Windows.
What You’ll Need
- An Excel workbook with the worksheet you want to work on.
- A clear idea of which headings, labels, or identifier columns should remain visible while scrolling.
- Access to the View tab. You do not need an add-in, formula, or special permission to freeze panes.
Step-by-Step
- Identify the information that should stay on screen. Look at the worksheet as a reader would use it. If each row is a sales transaction and column A contains the customer name, keeping column A visible can help identify records when scrolling right. If row 1 contains field names such as Date, Region, and Amount, keeping that row visible helps interpret values when scrolling down. A report may need both its column headings and a few label columns. Freeze only what is useful; taking up too much screen space makes the data area harder to view.
- Decide how many top rows you need. Count from the top of the worksheet, not from the top of the currently visible screen. If the headings are in row 1, one frozen row may be enough. If rows 1 and 2 contain a report title and a second line of column labels, you may want both rows frozen. Rows between row 1 and the last row you choose are frozen together; Excel does not let you freeze a lower row while leaving the rows above it unfrozen.
- Decide how many left-side columns you need. Count from column A. If column A holds names and column B holds account numbers, you might keep both visible so a wide table remains identifiable as you scroll right. Frozen columns must be consecutive starting at column A. You cannot freeze column C by itself while allowing columns A and B to scroll away.
- Choose the boundary cell for a custom freeze. Select the cell one row below the last row to freeze and one column to the right of the last column to freeze. For example, to keep rows 1 and 2 plus columns A and B visible, select C3. To keep only rows 1 through 3 visible, select A4. To keep only columns A through C visible, select D1. The selected cell marks the top-left corner of the area that will scroll; the rows above it and columns to its left stay fixed.
- Select the cell in the worksheet grid. Click the boundary cell you worked out. Use a cell, rather than a row or column heading, so the freeze boundary is unambiguous. Check the Name Box to the left of the formula bar if you are unsure of the active cell address. If the worksheet is scrolled far down or across, you can still select the correct address using the Name Box, or return to the top-left first and navigate to it.
- Apply the custom freeze. On the ribbon, choose View > Freeze Panes > Freeze Panes. Do not choose Freeze Top Row or Freeze First Column for a custom combination: those commands apply only to row 1 or column A. Excel draws a thin line at the boundary, and the area above and to the left should remain stationary when you scroll.
- Use the quick commands when they match your layout. If you want only row 1 held in place, choose View > Freeze Panes > Freeze Top Row. If you want only column A held in place, choose View > Freeze Panes > Freeze First Column. These commands do not use your current cell selection to pick a different row or column. For example, Freeze Top Row still freezes worksheet row 1 even if row 8 is currently at the top of the screen.
- Test the result in both directions. Scroll down to check that the intended rows remain visible, then scroll right to check the intended columns. If you froze both, verify each direction and look at the intersection where the frozen rows and columns meet. Make sure the remaining scrolling area is large enough to read comfortably. A freeze that is technically correct may still be inconvenient on a small display if it takes up too much room.
- Change the freeze if the boundary is wrong. Choose View > Freeze Panes > Unfreeze Panes, then select the new boundary cell and apply Freeze Panes again. Excel uses one freeze arrangement per worksheet; applying a new one replaces the old arrangement. You can repeat this adjustment until the visible labels and usable scrolling area suit the worksheet.
On Excel for Mac, use the View tab and the Freeze Panes commands; the custom boundary-cell rule is the same. In Excel for the web, open View and use Freeze Panes; available command labels can vary slightly with the current interface. If a command is missing or disabled, check that the sheet is not in a mode that prevents the change and try the desktop app.
Common Mistakes
- Selecting the row or column you want to freeze. For a custom freeze, Excel reads the active cell as a boundary. To freeze through row 3, select a cell in row 4; to freeze through column C, select a cell in column D. Selecting C3 freezes rows 1 and 2 and columns A and B, not row 3 and column C.
- Expecting Freeze Top Row to freeze the visible row. The command means worksheet row 1. If your headings are in row 5, use a custom freeze: select A6 to keep rows 1 through 5 fixed, or reconsider the sheet layout if freezing all those rows leaves too little room.
- Trying to freeze separated rows or columns. Freeze Panes creates a continuous block at the top and left. It cannot hold row 1 and row 5 while rows 2 to 4 scroll, or hold column A and column D while B and C move.
- Confusing freezing with protection or printing. Frozen panes affect on-screen scrolling only. They do not stop edits, filter data, or ensure headings repeat on printed pages. To repeat print headings, use Page Layout > Print Titles and set the rows or columns to repeat.
- Freezing too much. Several frozen rows and columns can crowd the worksheet, especially on a laptop. Keep the labels that help identify data, but avoid reserving screen space for titles or notes that readers do not need while scrolling.
Tips
- Use a consistent rule for tables: freeze the header row or rows and only the identifier columns people need to track records. For a wide inventory list, that might be the item name and SKU, rather than every descriptive column.
- Plan for the most common task. If users compare values down a long list, row headings matter most. If they compare fields across a wide report, left-side labels matter most. Freeze both only when users regularly need both types of context at once.
- Check the sheet at a typical viewing size. A setup that looks fine on a large monitor may leave little room on a smaller screen. Ask whether a reader can still see enough of the scrolling area to compare values without constant resizing.
- Keep freeze panes separate from split panes. Freeze Panes keeps an area fixed while the rest scrolls. Split creates separate worksheet panes that can scroll independently. If the sheet shows unexpected divisions, look under View for Split and turn it off if that is not the layout you want.
- Save after arranging the worksheet. The freeze setup belongs to the worksheet, so it is useful to save the workbook after confirming the result. If you share the file, tell readers which area is intentionally fixed if the choice may not be obvious.
Troubleshooting
- The wrong rows or columns stay visible. Choose View > Freeze Panes > Unfreeze Panes, click the correct boundary cell, and apply Freeze Panes again. Recheck the address: for rows 1 to 4 and columns A to C, the boundary cell is D5.
- The Freeze Panes command is unavailable. First check whether the worksheet is protected or whether the workbook is open in a restricted viewing state. If the window has been split, choose View > Split to remove the split and then try again. In Excel for the web, try opening the workbook in the desktop app if the ribbon does not offer the needed command.
- Nothing seems to freeze. Confirm that you used Freeze Panes rather than only selecting a cell. Selecting A1 and choosing the custom command leaves no rows above or columns to the left to hold, so it may appear to do nothing. Use A2 for row 1, B1 for column A, or the appropriate boundary cell for both.
- A frozen area takes up too much space. Unfreeze and set a smaller boundary. For example, if you froze four rows but only need the headings in row 1, select A2 and apply Freeze Panes, or use Freeze Top Row. Consider moving a large report title out of the rows needed for scrolling.
- The screen has lines that do not match the freeze. A split or pane divider may be active, or the freeze boundary may be somewhere other than expected. Use Unfreeze Panes, turn off Split if present, and apply the freeze again from a carefully selected cell.
Frequently Asked Questions
Can I freeze more than one row and one column?
Yes. Select the boundary cell below all the rows and to the right of all the columns to keep fixed, then choose View > Freeze Panes > Freeze Panes. Excel freezes the continuous rows above and columns to the left.
Can I freeze a row other than the first row?
Yes, but use a custom freeze. To freeze rows 1 through 5, select a cell in row 6, such as A6, and choose Freeze Panes. Excel cannot freeze row 5 alone while rows 1 through 4 scroll.
Can I freeze only column B?
No. Frozen columns start at column A and continue without gaps. To keep column B visible, you must also keep column A visible. If that is unsuitable, consider moving the identifying information into the first column.
Will frozen panes stay when I close the workbook?
They are worksheet settings and are normally retained when you save the workbook. Save the file after setting them, then reopen it to confirm the layout if it is important for other users.
Do freeze panes affect printing?
No. They change how the worksheet scrolls on screen, not how pages print. Use Page Layout > Print Titles to repeat specified heading rows or columns on printed pages.
How do I remove frozen panes?
Choose View > Freeze Panes > Unfreeze Panes. This removes the current freeze arrangement from the active worksheet; it does not delete or change worksheet data.
Related
- How to Change Tab Color in Excel: A Practical Guide
- Change Table Color in Excel: Styles and Custom Formatting
- Excel Subscript: How to Change Text to Subscript
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Tool Inventory Spreadsheet: Setup, Tracking, and TipsA tool inventory spreadsheet is a structured list of the tools an organization owns, where they are, who…
- Delete Emails From Archive in Outlook: Step-by-StepTo delete archived emails in Outlook, open the Archive folder, select the messages, and choose Delete. Outlook moves…
- Excel Transpose Shortcut: Flip Rows and Columns FastIn Excel for Microsoft 365 on Windows, copy the cells, select the top-left destination cell, press Ctrl+Alt+V, press…
- Marked Scatter Plot in Excel: Create and Format OneTo make a marked scatter plot in Excel for Microsoft 365 on Windows, select the cells containing your…
- Conditional Formatting in Excel: How It WorksConditional formatting in an Excel spreadsheet automatically changes a cell’s appearance when its value or a formula meets…
- COUNTIF in Google Sheets: Syntax, Examples, and TipsIn Google Sheets, COUNTIF counts cells that meet one condition. If A2:A6 contains Maya, Leo, Maya, Noor, and…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.