How to Freeze End Columns in Excel: Keep Them Visible

Excel’s Freeze Panes command cannot pin columns at the far right of a worksheet while you scroll through columns to their left. To keep end columns visible in their original position, use View > Split in Excel for Microsoft 365 on Windows: place the split just before those columns, then scroll the left pane independently. If you need a true freeze, move the columns you want to keep visible to the left side of the sheet first.

What You’ll Need

A workbook open in the Excel desktop app. The steps below are for Microsoft 365 on Windows.
The letter of the first column you want to keep visible. For example, if the final two columns are Y and Z, the split belongs between X and Y.
Enough screen space to view both panes. You can resize the split if the end columns are narrow or there are several of them.

Save the workbook before changing its layout, especially if you plan to move columns. Split changes the view, not the data, so you can remove it later without changing cell contents.

Step-by-Step

Identify the columns to keep in view. Check the column letters at the top of the worksheet and decide exactly which end columns should remain visible. If you want columns Y and Z to stay on screen, the divider should be placed immediately before Y. The pane on the right will show Y and the columns after it; the pane on the left will contain the earlier columns you want to scroll through.
Open the worksheet and remove an existing freeze if necessary. Select the sheet tab you want to work on. If Freeze Panes is already active, choose View > Freeze Panes > Unfreeze Panes before setting up the split. This gives you a clean starting point. If the workbook has multiple worksheets, remember that the view setting applies to the selected sheet, so repeat the setup on other sheets where needed.
Select the cell at the split boundary. Click the cell in row 1 of the first column you want to keep visible. For columns Y and Z, select Y1. Using row 1 places a vertical divider without asking Excel to split the sheet horizontally at a lower row. If the first row is hidden or your sheet has unusual layout, use a visible cell in that first target column and check the result; you can undo the split and try again if Excel creates an unwanted horizontal division.
Turn on the split. On the ribbon, choose View > Split. Excel divides the worksheet into panes at the selected position. You should see a vertical divider between the earlier columns and your end columns. The columns in the right-hand pane are still part of the same worksheet; Split does not create a second copy of the data.
Adjust the divider to give the end columns enough room. If the right pane is too narrow, point to the vertical divider until the resize pointer appears, then drag it left or right. Leave enough width to read the headings and values you need. Making the right pane wider reduces the space available for the scrolling pane, so choose a balance that works for your display.
Scroll the left pane, not the right one. Click a cell in the left pane to make that pane active. Use its horizontal scroll bar to move through the earlier columns. The right pane should continue to show the end columns. If the end columns appear to move, click inside the right pane and return it to the desired columns, then click back in the left pane before scrolling again. Each pane has its own scroll position, so selecting the pane first helps prevent accidental movement in the wrong area.
Check the setup at a few positions. Scroll the left pane toward the middle and farther toward the right side of the data. Confirm that the target columns remain visible and that the values in each pane belong to the same worksheet rows. If the columns do not fit, widen the right pane or reduce the number of columns you are trying to keep in view.
Remove the split when you no longer need it. Choose View > Split again to toggle the split off. If you prefer to return to a normal worksheet view, use that command rather than dragging the divider off-screen. Removing the split changes only how the sheet is displayed; it does not delete or rearrange any cells.

For example, imagine a wide sales sheet with monthly data in columns B through X and a status field and owner in Y and Z. Set the split at Y1. Scroll the left pane to compare different months, while the right pane keeps the status and owner fields in sight. This is useful when those final fields help identify the records you are reviewing.

Common Mistakes

Expecting Freeze Panes to lock columns on the right. Freeze Panes fixes rows above and columns to the left of the active cell. It is designed for headings and leading identifier columns, not for pinning the far-right edge of a sheet. For end columns in place, use Split.
Selecting the wrong cell before choosing Split. The active cell determines where Excel places the divider. Selecting a cell several rows down can create both a horizontal and vertical split. Start with a cell in row 1 of the first column you want in the right pane.
Scrolling the wrong pane. A split does not make either pane permanently stationary. If you scroll the right pane, the end columns can move out of view. Click in the pane you intend to scroll before using its scroll bar.
Making the right pane too narrow. A pane that shows only part of a heading may technically keep a column visible but will not be useful. Resize the divider and consider whether you really need every end column displayed at once.
Using Freeze Panes and Split as if they were the same feature. Freeze Panes locks the specified top rows and left columns. Split creates independently scrollable sections. Clear an existing freeze before setting up the split, and do not expect Split to lock the right pane permanently.

Tips

Keep the target group small. One or two key fields, such as status and owner, are easier to read in a narrow right pane than a block of many columns. If you need a larger group, make the window wider or hide columns that are not relevant to the task.
Use Freeze Panes for columns at the beginning of the sheet. If the columns you need to retain are actually on the left, select the first cell to the right of them and choose View > Freeze Panes > Freeze Panes. For instance, selecting C1 before freezing keeps columns A and B visible. This is different from keeping end columns visible.
Consider a deliberate worksheet layout. If users must have a true frozen group and those fields can sensibly appear first, reorganize the sheet so the important fields are on the left, then freeze panes after them. Save a copy and check formulas, charts, tables, and any linked processes after rearranging columns.
Use a second workbook window for a different view. If Split is unavailable or you need to compare distant areas in different ways, Excel’s View > New Window can open another window on the same workbook. Arrange the windows side by side and navigate them separately. This is a separate view, not a freeze, and changes to cells in one window are reflected in the other.
Remember the platform difference. Excel for Mac also has a Split command on the View tab or View menu, though ribbon layout can differ. In Excel for the web, use the desktop app if Split is not offered in your View controls; Freeze Panes in the browser still does not pin the far-right columns in place.

Troubleshooting

The divider appeared in the wrong place. Choose View > Split to turn the split off. Click the cell in row 1 of the first column that should appear in the right pane, then choose View > Split again. For example, select Y1 to divide before column Y. Check that the active cell is in the intended worksheet and column before repeating the command.
A horizontal divider appeared as well. This usually means the selected cell was below the first row. Turn Split off and select a cell in row 1 at the desired column boundary. A cell positioned down the sheet can tell Excel to split both vertically and horizontally.
The right-hand columns move when you scroll. The pane you are scrolling is likely the right one. Click a cell in the left pane, then use the horizontal scroll bar while that pane is active. If necessary, return the right pane to the target columns first. A split provides independent scrolling, not a permanent lock.
You cannot see a separate scroll bar for each pane. Click inside the pane you want to move and use the horizontal scroll bar at the bottom of the Excel window; Excel applies scrolling to the active pane. If the window is too narrow to make the panes and controls easy to use, maximize Excel or widen the window and try again.
Freeze Panes is unavailable or behaves unexpectedly. If the sheet is split, toggle Split off first. If the sheet is protected or you are using a limited browser interface, some view controls may be unavailable. Open the workbook in the desktop app, check the View tab, and remove any existing pane setup before applying a new one.
Rows do not line up visually across panes. The panes show different horizontal areas of the same rows, but vertical scrolling can also differ. Scroll each pane vertically to the same row range, or use the same row position before comparing entries. If you accidentally create a horizontal split, remove it and recreate a vertical-only split from a cell in row 1.

Frequently Asked Questions

Can Excel freeze the last column directly?
No. Freeze Panes fixes columns to the left of the selected cell, not columns at the right edge. Use View > Split to keep the end columns visible while scrolling another pane, or move the required fields to the left and freeze them there.

Does Split keep the end columns locked in place?
No. Split creates panes with separate scroll positions. The right pane can remain on the end columns while you scroll the left pane, but you can still scroll the right pane accidentally. Click in the appropriate pane before scrolling.

Can I freeze both the first columns and the end columns?
Not as two separate frozen areas with Freeze Panes. It freezes a continuous block of columns from the left edge. You can use Split to keep the end area visible while working, or redesign the sheet to put the columns you need at the left before freezing.

Will Split change my formulas or data?
No. Split changes the worksheet view, not cell contents or formulas. Moving columns to make Freeze Panes work is a separate action and can affect how a workbook is organized, so save a copy and review dependent charts, tables, and processes afterward.

Can I do this in Excel for the web?
Excel for the web has view controls such as Freeze Panes, but availability of Split can differ from the desktop app. If you do not see Split on the View tab, choose Open in Desktop App and set up the split there.

How do I return to the normal worksheet view?
Choose View > Split again to turn off the split. If you had a freeze active before starting, you may need to reapply it using View > Freeze Panes after the split is removed.

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.