To freeze selected rows or columns in Excel without using the “Freeze First Column” command, select the cell just below the rows and to the right of the columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes. Excel freezes everything above and to the left of that cell. This gives you more control than the preset commands, but it cannot lock a middle column by itself while leaving columns before it unfrozen.
Freeze panes is useful when a worksheet is wider or taller than the screen. You can keep headings, labels, or identifying information visible as you scroll through the rest of the data. The key is to select the right cell before applying the command; Excel uses that cell’s position to decide which rows and columns stay put.
What You’ll Need
- A workbook open in Microsoft Excel for Microsoft 365 on Windows. The same basic process is available in current Excel for Mac and Excel for the web, though ribbon layout and keyboard access can differ slightly.
- A clear idea of which rows and columns should stay visible. Freeze panes always keeps a continuous block attached to the top and left edges of the worksheet.
- If you want to change an existing freeze, you will need to unfreeze the panes first.
Step-by-Step
- Decide what should remain visible. Count the rows you want fixed at the top and the columns you want fixed on the left. For example, you might want to keep rows 1 and 2 for a title and headings, and columns A and B for a product name and ID. Excel does not have a command that freezes just a chosen column while allowing the columns before it to scroll; the frozen area must start at the top-left edge.
- Find the cell at the boundary of the area to freeze. Select the cell immediately below the last row you want to keep and immediately to the right of the last column you want to keep. To keep rows 1 and 2 and columns A and B, select C3. To keep only rows 1 through 3, select A4. To keep only columns A through C, select D1. The selected cell itself and the cells below and to its right remain scrollable.
- Open the View tab. On the Excel ribbon, select View. Find the Freeze Panes control, usually in the Window group. If the ribbon is collapsed or the Excel window is narrow, expand the ribbon or maximize the window so the control is easier to locate.
- Choose the custom Freeze Panes command. Open the Freeze Panes menu and select the first command, also named Freeze Panes. Do not choose Freeze Top Row or Freeze First Column unless one of those presets matches your goal. The custom command applies the boundary created by your selected cell.
- Check the result by scrolling. Scroll down and right. The chosen top rows should remain above the horizontal divider, and the chosen left columns should remain before the vertical divider. Look for thin lines marking the frozen boundaries. If the wrong area is fixed, continue to the troubleshooting section, unfreeze, and repeat with a corrected cell selection.
- Save the workbook. Freeze settings are stored with the workbook, so save after confirming the view. These settings affect how the sheet is displayed; they do not change, move, or delete the worksheet data.
Example: Keep headings but not the first column
Suppose the sheet has headings in row 1, while column A contains long notes that you do not want fixed on screen. If you want only the top row to stay visible, select A2 and choose View > Freeze Panes > Freeze Panes. The top row will remain visible, and no columns will be frozen. This is different from selecting Freeze First Column, which fixes column A.
If instead you want columns B and C to stay visible while scrolling, Excel’s standard freeze command cannot freeze only B and C while leaving A scrollable. It freezes from the left edge, so selecting D1 freezes A through C. If column A is not needed, you can hide it first, then freeze at D1; B and C will remain visible, while A stays hidden. If you later unhide A, it will also be part of the frozen block. Consider whether hiding a column is appropriate before using this workaround, especially if other people use the workbook.
Common Mistakes
- Selecting the cell inside the area you want frozen. Excel freezes rows above and columns to the left of the selected cell, not the selected cell’s row or column. If you want rows 1–2 and columns A–B fixed, C3 is the boundary cell, not B2.
- Choosing a preset by habit. Freeze Top Row and Freeze First Column are fixed presets. They do not use your selected cell to create a custom boundary. For several rows, several columns, or both, choose the custom Freeze Panes command in the menu.
- Expecting to freeze a middle column on its own. Freeze Panes always locks a continuous block from column A. It cannot keep column C fixed while A and B scroll normally. Use a carefully considered hide-column workaround, rearrange the worksheet, or use another viewing method if that exact behavior is essential.
- Forgetting an old freeze is active. Excel generally allows one frozen-pane arrangement per worksheet. If an earlier freeze is active, selecting a different cell and clicking Freeze Panes may not replace it as expected. Choose View > Freeze Panes > Unfreeze Panes first.
- Confusing freeze panes with split panes. Split creates separate areas that can be scrolled independently; it is not the same as keeping a heading or label fixed while the main sheet moves. If you want a fixed header, use Freeze Panes.
- Assuming the worksheet has changed. Freezing affects the view, not the cell contents or printed pages. It does not lock cells against editing, protect data, or make rows repeat when printing. Use sheet protection or print settings for those separate tasks.
Tips
- Use a boundary cell rather than guessing. Write down the last row and column that should stay visible, then move one row down and one column right. That intersection is the cell to select. If you are freezing rows only, stay in column A; if freezing columns only, stay in row 1.
- Keep the frozen area compact. Freezing many rows or columns leaves less room for the scrollable part of the sheet. On a small laptop screen, even a few extra frozen columns can make the data difficult to inspect.
- Use clear headings before freezing. A descriptive header row and concise identifying columns make it easier to compare records while scrolling. If headings occupy multiple rows, include all of them in the frozen block.
- Try the view at your normal zoom level. Zooming in can make frozen rows and columns take up a large share of the window. Adjust the zoom or window size if the remaining scrollable area is too narrow.
- Check each worksheet separately. Freeze settings apply to the active sheet, not automatically to every sheet in the workbook. Repeat the selection and command on each worksheet where you need a different frozen view.
- Know the platform difference. Excel for Mac has the Freeze Panes controls on the View tab as well, although the ribbon can look different. Excel for the web offers freeze controls on its View tab; if the command or layout differs in your browser, look for the Freeze Panes menu there. The principle remains the same: select the boundary cell first.
Troubleshooting
The wrong row or column stayed fixed. Select View > Freeze Panes > Unfreeze Panes, then identify the exact boundary again. If rows 1–4 should stay visible but no columns should, select A5 before applying Freeze Panes. If columns A–D should stay visible but no rows should, select E1.
The menu shows Unfreeze Panes instead of the custom command. A freeze is already active on that worksheet. Choose Unfreeze Panes, select the correct boundary cell, and apply Freeze Panes again. If the menu appears unavailable, make sure you are viewing a worksheet rather than a chart sheet and that the workbook is not in a restricted editing state.
Scrolling does not seem to move the sheet. Check whether the selected cell is below or to the right of a large frozen area; the remaining scrollable area may be small. Look for the divider lines and try dragging the vertical or horizontal scroll bar. Also check whether Split is active; if so, turn it off from View > Split before setting the freeze again.
A column you expected to scroll is fixed too. Excel may have frozen every column to the left of your selected cell. Unfreeze and select a boundary farther left. Remember that freezing at D1 locks A, B, and C together, not just column C.
You are using Mac or the web and cannot find the same control. Confirm that the worksheet is active and inspect the View tab for Freeze Panes. On Mac, ribbon placement can vary with window size. In Excel for the web, expand the ribbon if needed. If you are working in a browser and the workbook is opened in a limited or read-only mode, open it in the desktop app or request editing access.
Frequently Asked Questions
Can I freeze rows without freezing the first column?
Yes. To freeze rows 1 through 3 only, select A4, then choose View > Freeze Panes > Freeze Panes. Because the selected cell is in column A, no columns to its left are frozen.
Can I freeze column B but leave column A scrolling?
Not with the standard Freeze Panes command. Excel freezes a continuous block of columns starting at A. You can hide A before freezing at C1 to keep B visible, but if you unhide A it will be frozen too.
What is the difference between Freeze Panes and Freeze First Column?
Freeze First Column is a preset that keeps column A visible. Freeze Panes uses the selected cell as a boundary and can keep multiple top rows, multiple left columns, or both fixed.
Will the freeze apply to every sheet in my workbook?
No. The setting is specific to the active worksheet. Set it separately on each sheet where you want rows or columns to remain visible.
Does freezing panes protect cells from edits?
No. It only changes what stays visible while scrolling. To prevent changes, use Review > Protect Sheet and configure the protection options you need.
How do I remove frozen panes?
Go to View > Freeze Panes > Unfreeze Panes. This restores normal scrolling without changing the worksheet’s data.
Related
- How to Find Duplicate Data in Excel: Step-by-Step Guide
- How to Find Duplicate Entries in Excel
- Excel Date Difference: Calculate Days, Months, or Years
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Consolidate Excel Workbooks Into One: Best MethodsTo consolidate multiple Excel workbooks into one, choose whether you want to combine their rows into a single…
- Consolidate CSV Files in One Excel WorkbookYes. In Excel for Microsoft 365 on Windows, use Power Query to combine multiple CSV files into one…
- Schedule a Zoom Meeting in Outlook Email: Full GuideTo schedule a Zoom meeting and send it through Outlook, create a calendar event, add the Zoom for…
- Remove a Data Model from Excel: Steps and EffectsYes. In Excel for Microsoft 365 on Windows, remove tables from the Data Model in Power Pivot: choose…
- How to Double Space in a Word Document in Microsoft WordTo double-space text in Microsoft Word, select the text, then choose Home > Line and Paragraph Spacing >…
- Resize Cells in Excel: Keyboard Shortcuts That WorkTo resize cells in Excel quickly, resize their columns or rows: 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.