How to Freeze a Row in Excel: All Methods and Shortcuts

Freezing a row in Excel keeps the header row visible at the top of the sheet while you scroll through hundreds or thousands of rows below. It is one of the most-used productivity features in the application, available since the earliest versions of Excel and refined over the years into three distinct commands: Freeze Top Row, Freeze First Column and Freeze Panes. Each command does something slightly different, and choosing the right one for the job is what separates fluent Excel users from people who scroll back to row one every thirty seconds.

The fastest method is the simplest. Click the View tab on the ribbon, click Freeze Panes in the Window group, and choose Freeze Top Row. The header row is now locked at the top of the visible area; scroll the rest of the sheet and the header stays put. Excel adds a thin gray line just below row one to indicate the freeze. To freeze a different row, the procedure is slightly different and uses the Freeze Panes command instead of Freeze Top Row.

This guide covers every freezing method you might need: freezing the top row, the first column, multiple rows or columns at the same time, and how to unfreeze when you are done. We cover the keyboard shortcuts (Alt+W+F+R for Top Row, Alt+W+F+C for First Column, Alt+W+F+F for Freeze Panes), the differences on Mac and in Excel for the web, the common mistakes that prevent freezing from working, and the related Split command that gives you four independently scrollable views of the same sheet.

The principles do not change between Excel versions. Excel 2016, 2019, 2021, Microsoft 365 and Excel for the web all use the same freeze panes engine, with minor differences in where the buttons live on the ribbon. Excel for Mac differs cosmetically — the menu path is Window > Freeze Panes — but follows the same logic. Wherever you see a screenshot in this guide, the equivalent button exists on every modern Excel build, including the free web version at office.com.

The Freeze Top Row command is the simplest and most common version. With your spreadsheet open, click any cell on the sheet (selection does not matter for this command), then go to View > Freeze Panes > Freeze Top Row. Excel locks row 1 at the top of the visible area and adds a thin gray line below it. Scroll down and the header row remains visible. The behavior is automatic and works on every sheet in the workbook independently — freezing the top row of Sheet1 does not affect Sheet2.

Freezing the first column works the same way for vertical scrolling. View > Freeze Panes > Freeze First Column locks column A in place while you scroll right through the rest of the columns. This is helpful when you have a wide spreadsheet with row labels in column A — for example, a budget with month headers across the top and account categories down the left. Freeze Top Row and Freeze First Column can both be active at the same time, automatically locking row 1 and column A.

The Freeze Panes command is the powerful version that lets you freeze multiple rows, multiple columns or both. Click the cell below and to the right of the area you want to freeze. For example, to freeze the top three rows and the first column, click cell B4 (the cell at the intersection of row 4 and column B). Then go to View > Freeze Panes > Freeze Panes. Excel locks everything above row 4 and everything to the left of column B simultaneously. Scrolling now keeps both the top three rows and column A visible.

This selection logic catches out new users. Excel uses the active cell's position to determine where the freeze lines fall. The cell you click is the first one that will scroll; everything above it and to the left of it stays frozen. To freeze just rows without freezing any columns, click cell A4 (in column A, the leftmost column). To freeze just columns without freezing any rows, click cell B1 (in row 1, the top row). The pattern becomes intuitive after one or two attempts.

The keyboard shortcuts make this whole feature dramatically faster once memorized. Alt+W+F+R freezes the top row directly. Alt+W+F+C freezes the first column. Alt+W+F+F is the Freeze Panes command — used either to freeze panes from a selected cell or to unfreeze when a freeze is already active. The shortcuts work in Excel 2010 and later on Windows. On Mac, the menu-driven approach is the standard; keyboard shortcuts for the freeze commands are not consistent across Mac versions.

To unfreeze, the procedure is the same regardless of which freeze command you used originally. View > Freeze Panes shows Unfreeze Panes when a freeze is active; click it to remove all frozen rows and columns at once. The keyboard shortcut is Alt+W+F+F (the same as Freeze Panes — Excel toggles between freeze and unfreeze depending on the current state of the worksheet). There is no separate command for unfreezing only the top row or only the first column; unfreezing always clears everything.

Excel for the web supports Freeze Top Row and Freeze First Column on most browsers. The Freeze Panes command for multi-row freezing has been added in recent updates. The buttons are in the same View > Freeze Panes location as the desktop version, with the menu paths slightly simplified. The web version does not yet support Split panes (the related multi-view feature). For most users, the freeze-related work that matters can be done in the browser; for advanced multi-pane workflows, the desktop version is still required.

Excel for Mac uses Window > Freeze Panes rather than View > Freeze Panes. The functionality is identical but the menu location differs because Mac applications group window-related commands under the Window menu by convention. The Mac version supports all three commands — Freeze Top Row, Freeze First Column and Freeze Panes — and unfreezes through the same menu. Mac keyboard shortcuts for freeze are inconsistent; menu navigation is the typical approach.

The most common cause of "freeze panes is not working" is being in the wrong view mode. Page Layout view (View > Page Layout) and Page Break Preview both disable freeze panes; the option appears grayed out on the ribbon. Switch back to Normal view (View > Normal) and the freeze options become available again. This catches out users who turned on Page Layout to set up printing and forgot to switch back.

The second most common cause of confusion is the active cell selection when using Freeze Panes. The freeze lines fall above and to the left of whichever cell is selected. If you select cell A1 and click Freeze Panes, Excel freezes... nothing visible, because there is nothing above or to the left of A1. Click a cell further into the sheet — typically the first cell of the data area below your headers — before invoking Freeze Panes for any multi-row or multi-column freeze.

Another quirk: shared workbooks (the older sharing feature) and protected sheets sometimes restrict freeze pane changes. If you receive a workbook with a freeze you cannot remove, check whether the sheet is protected (Review > Unprotect Sheet) or whether the workbook is shared (Review > Share Workbook in older versions). Modern co-authoring through OneDrive and SharePoint does not restrict freeze panes; only the legacy shared workbook feature does.

Freeze panes are saved with the workbook. When you save a file with frozen rows, the freeze persists for anyone who opens the file later. This is helpful for templates and dashboards where the header should always be visible to anyone using the file. The freeze is per-sheet and per-workbook, so you can have different freezes on different sheets in the same file, or no freeze on some sheets while others have multi-row freezes.

The Split command is the related but distinct feature that often gets confused with freeze panes. Split (View > Split) divides the active worksheet into two or four independently scrollable panes that show the same data. Where Freeze Panes locks rows or columns in place, Split allows you to view two areas of the same sheet independently — for example, scroll the top pane to row 100 while the bottom pane stays at row 5,000. The split bars can be dragged to resize the panes.

The choice between Freeze and Split depends on what you are trying to do. Freeze is for keeping a header visible while scrolling through data. Split is for comparing two areas of the same sheet that are far apart. You cannot use both Freeze and Split at the same time on the same sheet — choose one. Most users find Freeze far more useful in daily work; Split is more of a power-user tool for occasional comparison work.

For very large datasets, hidden rows and columns interact with freeze panes in subtle ways. If you hide rows that fall within the frozen pane, the freeze updates to skip the hidden rows; the visible frozen rows are still labeled with the original row numbers but the hidden rows are skipped. The same applies to hidden columns. If you later unhide the rows, they reappear inside the frozen pane. The behavior is logical but takes a moment to understand.

Freezing also interacts with Excel Tables. A Table created with Ctrl+T has its own header row that stays visible automatically while the user scrolls through the Table's data, regardless of whether you have used Freeze Panes. The Table header behavior replaces the column letters at the top of the spreadsheet (A, B, C) with the column names from the Table. Many users find that converting their data to a Table eliminates the need to freeze panes for header visibility.

For dashboards and reports that will be shared with other users, freezing the header row is one of the smallest improvements that produces a disproportionate quality boost. Anyone opening a 5,000-row sheet with no header freeze will spend half their time scrolling back to row one to remember what column they are looking at. Freezing the top row before saving the file removes that friction entirely. The same applies to wide budget sheets — freezing column A keeps the row labels visible as users scroll through twelve months of data.

For multi-sheet workbooks, build the freeze pattern consistently across sheets so users do not have to figure out a new layout each time they switch tabs. If Sheet1 has the top row frozen, Sheet2 should also have the top row frozen even if it has different content. Consistency reduces cognitive load. The same applies to template workbooks distributed across an organization — the standard freeze pattern is part of the design and helps users move between sheets without re-orienting.

For dynamic data that grows over time, the Excel Table approach combined with Freeze Top Row produces the most maintenance-free behavior. As you add rows below the Table, the frozen header stays visible and the Table extends automatically. There is no need to revisit the freeze settings as the data set grows. This is the pattern most professional Excel users build into shared workbooks because it requires no further intervention.

Power users sometimes prefer the keyboard-only path through this feature. Alt+W is the keyboard shortcut to open the View ribbon. Alt+W+F opens the Freeze Panes menu. Then R for top Row, C for first Column or F for the Freeze Panes command. Once memorized this is the fastest possible way to freeze any layout. The four keystrokes Alt+W+F+R for top-row freezing become muscle memory after a week of regular use, dramatically faster than mousing to the ribbon.

For VBA scripting, the freeze panes feature is exposed through the ActiveWindow.FreezePanes property. Setting Range("B4").Activate followed by ActiveWindow.FreezePanes = True produces the same result as the manual Freeze Panes command with B4 as the active cell. This is useful when generating workbooks programmatically — for example, exporting reports from a database into Excel format with a frozen header row already in place. Recording a macro while you freeze panes manually shows the exact code to use.

For collaborative workbooks shared through OneDrive, SharePoint or Microsoft Teams, freeze panes work normally and persist across the co-authoring session. Multiple users editing the same workbook all see the same freeze layout. Changes to the freeze made by one user propagate to others within seconds, although in practice you would not normally change a freeze while others are working in the file because it briefly disrupts their scroll position.

For workbooks shared as email attachments or downloaded copies, each user gets a separate file with the freeze settings preserved. Each user can adjust the freeze independently in their copy. This is sometimes useful — different users may want different freeze layouts for the same data — and sometimes a source of confusion when one user's customization differs from another's. The shared OneDrive approach avoids the divergence by keeping a single canonical version of the file.

The end goal is to make freeze panes a thoughtless reflex rather than a button hunt. Once you know the keyboard shortcut Alt+W+F+R and remember that selection determines where multi-row freezes break, every spreadsheet you build becomes more readable to anyone who opens it next.