To freeze panes in Excel Online, select the cell just below the row or rows and just to the right of the column or columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes. For example, select B2 to keep the first row and first column on screen as you scroll. You can also freeze only the top row or first column using the matching commands in the same menu.
What You’ll Need
- A workbook opened in Excel for the web in a browser. You can open it from OneDrive, SharePoint, or another location that gives you access to the file.
- Permission to edit the workbook if you need to change its view settings. If it opens in read-only mode, ask for edit access or open an editable copy.
- A sense of which headings or labels should stay on screen. Freeze panes always keeps rows from the top and columns from the left; it does not pin an arbitrary row or column in the middle of a sheet.
Step-by-Step
- Open the worksheet you want to work on. Open the workbook in Excel Online and choose the specific worksheet tab at the bottom. Freeze settings apply to the active worksheet, so repeat the process on another sheet if it needs its own frozen headings. If you see a viewing-only indicator, switch to editing if that option is available and you have permission.
- Decide what should remain visible. Think of the sheet as having a stationary top section and a stationary left section. Rows above the selected cell stay visible when you scroll vertically; columns to its left stay visible when you scroll horizontally. The remaining cells form the area that scrolls. If you only need the column headings, you may want just the top row. If row labels are important, you may also want the first column.
- Select the cell at the freeze boundary. Click one cell, not an entire row or column. Its position determines what Excel freezes: select the cell immediately below the last row to keep and immediately to the right of the last column to keep. For example, select B2 to freeze row 1 and column A. Select A2 to freeze only row 1, or B1 to freeze only column A. To keep rows 1 through 3 and columns A and B visible, select C4.
- Open the Freeze Panes command. Select the View tab on the ribbon, then open Freeze Panes. Choose Freeze Panes from the menu to apply the boundary defined by your selected cell. The menu also provides dedicated commands such as Freeze Top Row and Freeze First Column. Those options are convenient when you want exactly the first row or first column, but use the general Freeze Panes command for a custom combination.
- Check the result by scrolling. Scroll down and across the worksheet. The frozen headings or labels should stay in place while the unfrozen cells move. Look for a thin boundary line below the frozen rows and to the right of frozen columns. If the wrong amount is fixed, unfreeze the panes and repeat the selection step with the correct boundary cell.
- Save or confirm the workbook is saved. Excel for the web generally saves changes to a cloud-stored workbook automatically. Check the save status near the workbook name if it is shown, and wait for any saving indicator to finish before closing the browser tab. If you are working with a downloaded or locally synced copy, confirm that you are editing the intended file so the freeze setting is not lost in another version.
Common examples: To keep a single header row visible, select A2 and choose Freeze Panes, or choose Freeze Top Row. To keep row labels in column A visible, select B1 or choose Freeze First Column. To keep both the top row and column A visible, select B2 and choose Freeze Panes. For a report with three header rows and two identifying columns, select C4. Remember that Excel freezes every row above and every column to the left of your selection, not just the most recent heading.
Common Mistakes
- Selecting the wrong cell. This is the most common cause of an unexpected result. Selecting B3 freezes the first two rows and column A, not just row 2 and column B. Use the boundary rule: click one row below the last row you want to retain and one column right of the last column you want to retain.
- Expecting a middle row to stay fixed by itself. Freeze Panes works from the top and left edges. It cannot freeze row 10 while rows 1 through 9 scroll away. If you select a cell in row 11, all rows 1 through 10 are included in the frozen area.
- Using a special command for a custom layout. Freeze Top Row freezes only the top row, and Freeze First Column freezes only column A. If you need several rows, several columns, or a combination, choose the cell that marks the boundary and use the general Freeze Panes command.
- Confusing frozen panes with Split. Splitting divides the worksheet window into separately scrollable areas. It is not the same as keeping headers fixed while the rest of the sheet scrolls. Choose Freeze Panes for persistent headings or labels; use a split only when you specifically need independently scrolling sections.
- Assuming the setting affects every worksheet. A frozen view belongs to the worksheet where you set it. Check each tab individually, especially when a workbook has several tables or reports with different header layouts.
Tips
- Freeze the smallest useful area. A large frozen block leaves less room to see the scrolling data, particularly in a small browser window. Keep only the rows and columns readers need for context, such as a compact header and an ID column.
- Use Freeze Top Row for a simple table. If your only requirement is to keep row 1 visible, this dedicated menu option is quicker and avoids having to calculate a boundary cell. Use the general command when the table has multiple heading rows.
- Scroll both ways when checking. A sheet can appear correct when you scroll down but still have the wrong column frozen. Test vertical and horizontal scrolling separately, and verify that the intended labels remain visible in each direction.
- Keep the boundary in mind when extending a table. If you later add another heading row or identifying column, unfreeze and set the panes again with a new boundary cell. The original freeze does not automatically adjust to a changed layout.
- Use the worksheet’s normal navigation tools. Frozen areas do not stop you from editing or selecting cells outside the visible region. The Name Box, scroll bars, and sheet navigation can help you reach cells farther down or across the worksheet.
Troubleshooting
The wrong rows or columns stay in place. Open View > Freeze Panes and choose Unfreeze Panes. Then click the correct boundary cell and apply Freeze Panes again. For instance, if you meant to freeze only row 1 and column A, select B2 before applying the command. If you meant to freeze the first two rows but no columns, select A3. The position of the selected cell—not the cell containing a heading—is what sets the boundary.
Nothing appears to happen. Test by scrolling the worksheet rather than relying only on the thin boundary line, which can be easy to miss. Make sure the worksheet is active and the selection is a single cell. If the workbook is in viewing mode, check whether you can switch to editing. If the ribbon is collapsed or the browser window is narrow, expand the ribbon or widen the window so the View tab and its commands are easier to find.
The Freeze Panes command is unavailable or missing. Confirm that you are in Excel for the web, rather than viewing a file preview, and that you have permission to edit. Open the workbook in the browser’s Excel interface if it launched in a preview. The ribbon can also be simplified at smaller window sizes, so look for the View tab or expand the ribbon before concluding the command is absent. If your organization restricts workbook editing, an owner or administrator may need to grant access.
The panes work on one worksheet but not another. That is expected: check the worksheet tab you are viewing and set the freeze boundary on each sheet that needs it. If the workbook is shared, make sure you are looking at the correct worksheet and that your changes have finished saving. When another person opens the workbook, their interface or view may not look identical in every collaboration context, so describe the intended rows and columns if you are coordinating a shared report.
You cannot see enough of the worksheet after freezing. Unfreeze the panes, then freeze fewer rows or columns. Also try zooming out or maximizing the browser window. Freezing five rows and four columns can be useful for a complex report, but it can leave only a small scrolling area on a laptop screen. The goal is to retain useful context without hiding most of the data.
Frequently Asked Questions
Can I freeze both rows and columns in Excel Online?
Yes. Select the cell below the last row and to the right of the last column you want to keep visible, then choose View > Freeze Panes > Freeze Panes. For example, B2 freezes row 1 and column A.
How do I freeze more than one row?
Select a cell in the row immediately beneath the last row to keep. To freeze the first three rows, select a cell in row 4, such as A4, and use Freeze Panes. All rows above the selected cell remain visible.
Can I freeze a column other than column A?
You can freeze multiple columns starting at the left edge, but not an isolated middle column. To keep columns A through C visible, select a cell in column D and choose Freeze Panes. Columns A, B, and C remain fixed together.
How do I remove frozen panes?
Choose View > Freeze Panes > Unfreeze Panes. The worksheet returns to normal scrolling. You can then select a new boundary cell and apply a different freeze arrangement.
Does freezing panes change the worksheet data?
No. Freezing panes changes how the worksheet is displayed while scrolling; it does not edit, delete, or rearrange cell contents. You can unfreeze the view at any time without changing the data.
Is the process different in the desktop version of Excel?
The selection rule is the same in Excel for Microsoft 365 on Windows: select the boundary cell and use View > Freeze Panes. Excel for the web uses the browser ribbon, and the exact appearance can vary with window size. On a Mac, use the View tab and the Freeze Panes commands; menu layout can differ slightly from Windows.
Related
- Amortization Schedule in Excel: Build One Step by Step
- How to Filter in Google Sheets: Step-by-Step Guide
- Fill Color in Excel Using Keyboard Shortcuts on Windows
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Clear Cache in Microsoft Outlook: Windows, Mac & WebTo clear the cache in Microsoft Outlook, use the method for your version: empty the Auto-Complete list or…
- Outlook Email Scheduling: How to Send Messages LaterTo schedule an email in Outlook, write the message, open the menu beside Send, choose Schedule send, and…
- Excel Find and Replace Entire Cell ContentsTo replace a cell only when its entire contents match, press Ctrl+H in Excel for Microsoft 365 on…
- Examples of Ratings in Excel: Scores, Stars, and RulesExamples of ratings in Excel include 1-to-5 customer scores, star displays, letter-grade categories, and color-coded performance scales. For…
- Excel Import CSV and TXT Files: How It WorksTo import a CSV or TXT file in Excel for Microsoft 365 on Windows, choose Data > From…
- Power Query Circular Reference: Causes and FixesA Power Query circular reference happens when a query depends on itself, either directly or through other queries,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.