To freeze rows or columns in Excel for Microsoft 365 on Windows, select the cell below the rows and to the right of the columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes. For a quick option, use View > Freeze Panes > Freeze Top Row or Freeze First Column.
What freezing panes does
Freezing keeps selected rows at the top of the worksheet or selected columns at its left edge while you scroll through the rest of the sheet. The frozen area stays in view, making it easier to compare distant records with their headings or identifiers. It does not move, copy, or protect the cells; it changes how the worksheet window displays them.
For example, a sales list might have headings in row 1 and hundreds of records below. Freeze the top row, then scroll down: the headings remain visible so you can tell whether a value belongs to the Date, Customer, or Amount column. In a wide inventory sheet, freezing the first column can keep product names visible while you scroll horizontally to later details.
Frozen panes apply to the current worksheet, not automatically to every sheet in the workbook. Each sheet can have its own freeze setting. The setting is also separate from print layout: freezing a row does not make it repeat on every printed page.
Freeze the top row or first column
These built-in commands are convenient when the headings are in the first row or the identifying values are in the first column:
- Keep the first row visible: Choose View > Freeze Panes > Freeze Top Row. Scroll down to confirm that row 1 remains at the top.
- Keep the first column visible: Choose View > Freeze Panes > Freeze First Column. Scroll right to confirm that column A remains on the left.
These options target only the first row or first column. If headings occupy rows 1 through 3, for example, Freeze Top Row will preserve only row 1. Use the custom Freeze Panes command instead to retain several rows, several columns, or both. If your sheet has been scrolled away from the top or left, the built-in commands still refer to the worksheet’s first row or first column, not the currently visible row or column.
Freeze several rows and columns together
For a custom arrangement, select a cell immediately below and immediately to the right of the area to remain visible. Excel freezes the rows above the selected cell and the columns to its left. The selected cell itself is not included in the frozen area.
- Click the worksheet cell at the boundary of the area you want to keep visible.
- Choose View > Freeze Panes > Freeze Panes.
- Scroll vertically and horizontally to check that the intended rows and columns stay in place.
Examples make the boundary rule clear:
- To freeze rows 1 through 3, select A4, then choose Freeze Panes.
- To freeze columns A and B, select C1, then choose Freeze Panes.
- To freeze row 1 and columns A and B together, select C2.
If you select D5, Excel freezes rows 1 through 4 and columns A through C. That may preserve more than you intended, so check the selection before applying the command. A practical approach is to decide which exact rows and columns are essential, identify the first cell outside that region, and select that cell.
Choose the right freeze setup
Freeze only what readers need to orient themselves. A long table with one header row usually needs just the top row. A report with names in column A and months spread across many columns may benefit from freezing the first column. A table with both a multirow heading and a key identifier column may need a custom freeze.
More frozen rows and columns leave less room for scrolling through the data. On a small display, freezing a large title block can make the worksheet feel cramped. If the sheet contains blank rows or columns above or to the left of the data, remember that Excel counts from the worksheet’s actual first row and column. The freeze boundary is based on the selected cell, not on what looks like the beginning of a table.
Change or remove frozen panes
Excel does not usually let you adjust an existing freeze by selecting a new boundary over it. First choose View > Freeze Panes > Unfreeze Panes. Then select the new boundary cell and apply Freeze Panes again. Unfreezing removes the current frozen rows and columns together; it does not delete or alter worksheet content.
If the menu offers Unfreeze Panes, a freeze is active on that worksheet. After removing it, the menu returns to the freeze options. You can then use Freeze Top Row, Freeze First Column, or the custom command as appropriate. Repeat the process separately on any other worksheet where you want a different setup.
Common problems and how to fix them
- The wrong rows or columns stay visible: Unfreeze panes and repeat the operation after selecting the correct boundary cell. Excel freezes everything above and to the left of that cell, which can be more than one row or column.
- The headings disappear when scrolling: Check that the headings are in the rows you froze. If they start on row 2 or lower, use a custom freeze rather than Freeze Top Row.
- The freeze command is unavailable or behaves unexpectedly: Check whether the worksheet is in a mode or layout that changes the available view controls, such as Page Layout view. Return to Normal view and try again. Also check whether a dialog or cell-editing mode is active.
- A thick line appears in the sheet: The line marks the boundary between frozen and scrollable panes. It is a display divider, not a border added to cells or a print line.
- The setting does not appear on another sheet: Freeze panes are worksheet-specific. Apply the freeze separately on that sheet.
Freezing is also not the same as protecting a worksheet. It does not stop someone from editing cells. To restrict editing, use the sheet-protection features separately and consider the intended permissions before sharing a workbook.
Freeze panes, split panes, and print titles
Freeze Panes is for keeping a defined top area and left area visible during scrolling. Split divides the worksheet window into independently scrollable sections; it can be useful when comparing distant parts of the same sheet, but it does not serve the same purpose as a fixed header. Look under the View tab for the Split command if you want separate scrolling areas.
For printed or exported pages, use print titles rather than relying on frozen panes. In Excel for Microsoft 365 on Windows, choose Page Layout > Print Titles and set rows to repeat at the top or columns to repeat at the left in the Page Setup dialog. This controls what repeats on printed pages; it does not keep those cells on screen while scrolling. Conversely, Freeze Panes affects the worksheet view, not the printed page sequence.
Excel for Mac and Excel for the web
In Excel for Microsoft 365 on Mac, the freeze options are available from the View tab, with commands for freezing panes, the top row, or the first column. The same boundary principle applies: select the cell below and to the right of the area to retain, then choose the custom Freeze Panes command. Menu placement and labels can vary slightly between releases.
Excel for the web also provides freeze controls on the View tab. Choose the relevant freeze option there; if you need a custom arrangement, select the boundary cell first and use the Freeze Panes command. The browser interface can differ from the Windows desktop ribbon, and some advanced view or print-layout controls may be more limited. If the command is hard to locate, check the View tab and the workbook’s current view.
Frequently Asked Questions
How do I freeze the first two rows in Excel?
Select A3, then choose View > Freeze Panes > Freeze Panes. Rows 1 and 2 will remain visible as you scroll down.
Can I freeze the top row and first column at the same time?
Yes. Select B2 and choose View > Freeze Panes > Freeze Panes. Excel keeps row 1 and column A visible. If you need additional rows or columns, select the cell just below and to the right of the larger area.
Why does Freeze Top Row keep the wrong row visible?
Freeze Top Row targets worksheet row 1, not the first row of a table or the row currently at the top of your screen. For headings lower in the sheet, select the cell below them in column A and use the custom Freeze Panes command.
How do I unfreeze panes in Excel?
Choose View > Freeze Panes > Unfreeze Panes. This removes the frozen rows and columns from the current worksheet without changing the cell data.
Does freezing a row make it repeat when I print?
No. Use Page Layout > Print Titles and specify the rows to repeat at the top of printed pages. Freeze Panes is only for keeping rows or columns visible on screen.
Related
- Excel Shortcut to Select to the End of a Column Explained
- Export to CSV vs Excel: Which Format Should You Choose?
- Extract Data from Google Maps to Excel: Practical Options
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 Make Two Numbered Columns in Microsoft WordTo make two numbered columns in Word, choose Layout > Columns > Two, then start or select one…
- Can You Make a Flowchart in Word? A Practical GuideYes, you can make a flowchart in Microsoft Word by inserting shapes and connecting them with lines or…
- Data Analysis in Excel: Methods, Steps, and ExamplesYes—Excel can analyze data by cleaning and organizing it, calculating summaries with formulas, and revealing patterns with PivotTables…
- Excel Table Properties: What They Are and How to Use ThemExcel table properties are the settings that control a table’s name, size, headers, filters, style, and summary row.…
- Google Sheets Apps Script Editor: How to Open and UseTo open the Apps Script editor for a Google Sheet, open the spreadsheet in a desktop browser and…
- How to Create a Badge Template in Word for PrintingTo create a badge template in Word, set up a page for your badge inserts, place a precisely…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.