Excel Freeze Pane Line: How to Remove It

To get rid of a freeze pane line in Excel, select the affected worksheet, then choose View > Freeze Panes > Unfreeze Panes. This removes the frozen-row and frozen-column settings, so the sheet scrolls normally again. It does not delete or change any cell data.

What You’ll Need

The Excel workbook with the line you want to remove, opened in edit mode.
Access to the worksheet where the line appears. Freeze settings apply to each worksheet separately.

The steps below are for Excel for Microsoft 365 on Windows. The same basic command is available in current Excel for Mac and Excel for the web, though the ribbon layout can look a little different.

Step-by-Step

Open the worksheet that shows the line. If the workbook has several sheets, click the sheet tab at the bottom of the Excel window where you see the horizontal or vertical line. Freeze panes are set separately on each worksheet, so changing one tab will not necessarily remove a line on another tab.

If the workbook is open in a browser, make sure you have editing access rather than viewing it in read-only mode. In the desktop app, open the workbook normally and select the relevant sheet before continuing.
Open the View tab. On Windows, click View in the ribbon at the top of Excel. Find the Freeze Panes control, usually in the Window group. If the Excel window is narrow, the group or command may be compressed; expand the ribbon or look for the Freeze Panes drop-down.

On a Mac, use the View tab or View menu and locate Freeze Panes. In Excel for the web, select the View tab in the browser ribbon. Menu placement can vary slightly with window size, but the command is still under View.
Choose Unfreeze Panes. Open the Freeze Panes drop-down and click Unfreeze Panes. This is the command that removes an existing freeze. Do not choose Freeze Top Row or Freeze First Column; those commands apply a new freeze rather than clearing the current one.

If you see Unfreeze Panes in the menu, Excel recognizes that the current sheet has frozen panes. Select it once. You do not need to click the line, select the frozen cells, or drag the line off the screen.
Check that scrolling is normal. Use the mouse wheel, scroll bar, or arrow keys to move up, down, and sideways. A frozen top row or left column stays in place while the rest of the sheet moves. After unfreezing, the formerly fixed area should scroll with the rest of the worksheet. The dividing line should also disappear.

For a quick check, scroll several rows down and several columns to the right. If the headings that used to stay visible now move out of view, the freeze has been removed. This is expected and does not mean the headings were deleted.
Repeat on any other affected sheets. If the workbook has a line on more than one tab, click each affected sheet and use View > Freeze Panes > Unfreeze Panes separately. Excel does not apply this command to every worksheet in the workbook at once.

If the same freeze setting is not needed anywhere, you can leave it removed. If you only wanted to change one sheet, make sure you do not unfreeze other sheets by mistake.
Save the workbook if you want to keep the change. Press Ctrl+S on Windows. On Mac, press Command+S. The pane setting is part of the workbook view, so saving preserves the change for the next time the file is opened. If you do not save, closing the workbook may discard the change.

Unfreeze Panes clears the current freeze arrangement as a whole. If a worksheet has both a horizontal and a vertical freeze boundary, Excel removes both. It does not provide a command to remove only one of those boundaries while leaving the other frozen. You can set up a new arrangement afterward if you still want some headings to remain visible.

Common Mistakes

Choosing Freeze Top Row instead of Unfreeze Panes. The Freeze Panes menu contains several choices, and their names are easy to confuse. Freeze Top Row and Freeze First Column create or change a freeze; they do not remove the existing freeze. Look specifically for Unfreeze Panes when a freeze is active.

Trying to erase the line like a cell border. A freeze boundary is a visual indicator of the area locked in place while scrolling. It is not a line drawn in a worksheet cell, so selecting nearby cells and using the Borders button will not remove it. Use the View tab command instead.

Assuming one command affects every tab. Freeze settings belong to individual worksheets. If you remove the line on one sheet and still see it on another, repeat the steps on that other sheet. Conversely, be cautious when selecting multiple worksheet tabs together; make sure you understand which sheets are grouped before changing view settings.

Thinking the worksheet has lost its headings. When you unfreeze panes, rows and columns that were held in view move along with the rest of the sheet. Their contents remain in their original cells. If you need them visible while scrolling, recreate a suitable freeze after clearing the old one.

Tips

Before unfreezing, notice which rows and columns stay put as you scroll. A horizontal boundary usually indicates frozen rows, while a vertical boundary usually indicates frozen columns. If the two meet at a corner, the sheet may have both. This helps you decide whether to remove the freeze entirely or rebuild a different setup.

If you want to keep headings visible, first clear the current setting, then select the cell below the rows and to the right of the columns you want fixed. Choose View > Freeze Panes > Freeze Panes. For example, to keep the first two rows and first column visible, select cell B3 before applying Freeze Panes. Excel freezes the rows above and columns to the left of the selected cell.

Use Freeze Top Row when only the first row needs to remain visible, or Freeze First Column when only column A needs to stay in place. These preset commands are often simpler than selecting a cell and using the general Freeze Panes command. If the worksheet already has a freeze, unfreeze it first before choosing a different arrangement.

Do not confuse a frozen boundary with a cell border. A freeze line is generally a thicker gray divider that separates the stationary area from the scrolling area. A cell border follows the edges of cells and remains attached to those cells as you scroll. If the visual mark does not behave like a divider between fixed and moving areas, investigate the other possibilities in Troubleshooting.

When sharing a workbook, remember that the freeze setting can affect how the next person views the sheet. Save after making the change, then reopen or revisit the worksheet to confirm the view is the one you intend. If you are unsure, save a separate copy first so you can compare the original layout with the revised one.

Troubleshooting

The line remains after choosing Unfreeze Panes. Confirm that you chose the worksheet where the line appears, then open the Freeze Panes menu again. If the menu now offers Freeze Panes, Freeze Top Row, and Freeze First Column rather than Unfreeze Panes, the freeze has already been removed; the remaining mark is likely another display feature. Also scroll in both directions, because a line can be easier to identify when you see whether it divides a stationary area from a moving one.

The line is a split bar, not a freeze boundary. Excel can split a worksheet window into panes that scroll independently. A split may look like a divider but behaves differently: you can scroll the sections separately, and the View ribbon’s Split command is active. To remove it in Excel for Microsoft 365 on Windows, choose View > Split to turn Split off. On Mac or the web, find the Split command on the View tab and toggle it off. Do not use Unfreeze Panes if the window is split but no panes are frozen.

You see dotted or page-related lines. Page-break indicators show where printed pages end; they are not freeze boundaries. On Windows desktop Excel, you can hide the worksheet’s page breaks by choosing File > Options > Advanced, scrolling to Display options for this worksheet, clearing Show page breaks, and selecting OK. Check that the correct worksheet is selected in the options area. Mac and web controls differ, so look for page-break display options in the app’s view or settings if you are using those versions.

The command is unavailable or changes do not stick. Check whether the workbook is open in Protected View, read-only, or without editing permission. Enable editing or request edit access, then try again. If the file is stored online, confirm that it has finished syncing before closing it. If you are using Excel for the web and the ribbon appears limited, open the workbook in the desktop app and use View > Freeze Panes > Unfreeze Panes.

You cannot tell what kind of line you are seeing. Look at how it behaves. A freeze boundary separates rows or columns that remain stationary from the rest of the sheet. A split lets separate sections scroll independently. A border moves with its cells, while a page break marks a print boundary and may appear dotted. Identifying the behavior first prevents you from changing a setting that is unrelated to the line.

Frequently Asked Questions

Does unfreezing panes delete rows, columns, or data?

No. Unfreeze Panes changes only the worksheet’s scrolling view. It does not remove cells, headings, formatting, formulas, or data. Rows and columns that were held in place simply scroll with the rest of the sheet afterward.

Can I remove only the horizontal or vertical freeze line?

Not directly with the Unfreeze Panes command. It clears the current freeze arrangement, including both frozen rows and columns if both are set. To retain one direction, unfreeze first and then create a new arrangement with the desired rows or columns frozen.

Why does Unfreeze Panes not appear in the menu?

Excel usually shows Unfreeze Panes only when the active worksheet has a freeze in place. If it is missing, check that you selected the right sheet. If the line is still visible, it may be a split bar, a cell border, or a page-break indicator instead.

Will the line come back when I reopen the workbook?

It should stay removed if you save the workbook after unfreezing. If you close without saving, Excel may reopen the last saved version with its previous freeze setting. Save with Ctrl+S on Windows or Command+S on Mac.

Can I remove freeze panes in Excel for the web?

Yes. Open the worksheet, select the View tab, open Freeze Panes, and choose Unfreeze Panes. If the command is unavailable in your current browser view, check that you have editing access or open the workbook in the desktop app.

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.