To freeze specific rows and columns in Excel for Microsoft 365 on Windows, select the cell immediately below the rows and immediately to the right of the columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes. For example, select C4 to keep rows 1–3 and columns A–B on screen while you scroll through the rest of the worksheet.
How to Freeze Specific Panes in Excel
Excel freezes everything above and to the left of the active cell. The selected cell itself does not become part of the frozen area; it marks the upper-left corner of the portion that can scroll. Use these steps in the Windows desktop version:
- Open the worksheet and select the cell that defines the freeze boundary. Choose a cell in row 1 if you want to freeze columns only, or in column A if you want to freeze rows only.
- On the ribbon, select View > Freeze Panes > Freeze Panes.
- Scroll down or across to confirm that the intended rows and columns remain visible.
Suppose row 1 contains report headings, rows 2 and 3 contain a title and notes, and columns A and B identify each item. Selecting C4 freezes all three top rows and the first two columns. Selecting B2 instead freezes only row 1 and column A. The boundary is based on the selected cell’s position, not on which headings look important.
To remove the freeze, select View > Freeze Panes > Unfreeze Panes. Excel removes the frozen rows and columns for that worksheet. Then select a different boundary cell and freeze again if you want a revised arrangement.
Choosing the Right Cell for Rows, Columns, or Both
The position of the selected cell determines what stays in place. A quick way to plan is to identify the last row and last column that should remain visible, then select the cell one row below and one column to the right.
- Freeze the top row: Select View > Freeze Panes > Freeze Top Row. This is useful when row 1 has field names and you need to scroll down through records.
- Freeze the first column: Select View > Freeze Panes > Freeze First Column. Use it when column A contains names, product IDs, or other labels you need to see while scrolling sideways.
- Freeze several rows: Select a cell in the row immediately below the final row to keep visible, then choose Freeze Panes. To keep rows 1 through 5, select a cell in row 6.
- Freeze several columns: Select a cell in the column immediately after the final column to keep visible. To keep columns A through C, select a cell in column D.
- Freeze rows and columns together: Select a cell below and to the right of both desired frozen areas. For rows 1–2 and columns A–C, select D3.
These commands freeze from the top and left edges of the worksheet. They do not let you freeze an isolated row in the middle, such as row 8 while rows 1–7 scroll away, or freeze column D while columns A–C move. The frozen area must be a continuous block beginning at the top, left, or both.
Examples for Common Worksheet Layouts
A long contact list might have headings in row 1 and a name in column A. If you want both the headings and names to remain visible, select B2 and use Freeze Panes. When you move down the list, the headings stay at the top; when you move right to see additional contact details, the names remain at the left.
For a monthly sales report, imagine that the first two rows contain a report title and column headings, while columns A and B show region and salesperson. To keep those labels visible, select C3 and freeze panes. The report title and headings remain visible vertically, and the two identifying columns remain visible horizontally.
For a wide budget tracker, you may need only the first two columns, which contain department and account, while the header row is already repeated elsewhere or is not essential. Select C1 and choose Freeze Panes to freeze columns A and B without freezing any rows. For a simple data list with headings in row 1, Freeze Top Row is faster than choosing a cell manually.
Before freezing a large area, consider how much space remains for the data that scrolls. Keeping ten rows and six columns fixed can be helpful in a complex form, but it can also leave a small scrolling area on a laptop display. Freeze only the labels needed to interpret the records.
How Frozen Panes Behave While You Work
Frozen rows stay at the top of the worksheet window, and frozen columns stay on its left. The rest of the sheet scrolls independently within the remaining area. A thin boundary line marks the edge of the frozen section. This is a viewing aid: it does not move, copy, protect, or lock the cells, and it does not change their values.
Freeze panes applies to the active worksheet, not automatically to every sheet in the workbook. If several worksheets need the same arrangement, set the freeze on each one. You can switch worksheets and use the same selection logic, but check each sheet’s layout because its headings may be in different rows or columns.
Freezing is also different from protecting a worksheet. It does not stop someone from editing cells, deleting rows, or changing data. Use the worksheet protection features separately if you need to restrict editing. Likewise, freezing panes does not repeat headings on printed pages; it affects the on-screen worksheet view, not the print layout.
If you need to change the frozen boundary, first unfreeze the current panes. Excel does not provide a drag handle for moving the freeze line to a new cell. After unfreezing, select the new boundary cell and apply Freeze Panes again.
Freeze Panes Compared With Split
Freeze Panes and Split both divide the worksheet window, but they solve different problems. Freeze Panes keeps designated top rows and left columns stationary while the rest of the sheet scrolls. The frozen sections remain anchored to the top and left edges.
Split creates separate worksheet areas that can be scrolled independently. It is useful when you want to compare distant parts of the same worksheet, such as the first few rows with a section much farther down. Unlike freezing, a split is not limited to anchoring rows at the top and columns at the left. To use it, choose a cell where you want the division and select View > Split. Use the same command again to remove the split.
Choose Freeze Panes when your goal is keeping labels visible as you browse a table. Choose Split when you want to inspect two different parts of a sheet at once. If you see multiple dividing bars or unexpected scrolling behavior, check whether Split is active and turn it off before setting up frozen panes.
Common Problems and How to Fix Them
- The wrong rows or columns stay visible: The selected cell was not at the intended boundary. Unfreeze, select the cell one row below and one column to the right of the area you want fixed, and apply Freeze Panes again.
- Only the top row or first column freezes: You may have chosen the dedicated Freeze Top Row or Freeze First Column command. Use the main Freeze Panes command after selecting a boundary cell to freeze a custom number of rows or columns.
- The freeze command is unavailable or behaves unexpectedly: Check that you are working in the worksheet view rather than a special viewing mode, and look for an active split. Return to View > Normal if necessary, remove a split, and try again.
- There is no visible freeze line: The boundary can be subtle, especially at high zoom or with certain display settings. Scroll the sheet to confirm what stays in place, and look for the line separating the fixed area from the scrollable area.
- The frozen section takes up too much room: Unfreeze and choose a boundary closer to the top-left corner. Remember that everything above and left of the chosen cell becomes fixed.
Also check whether the active worksheet is the one you intend to change. Freeze settings are easy to overlook when a workbook has many tabs, and applying a new setting on one sheet does not correct another sheet’s view.
Excel on Mac and Excel for the Web
In current Excel for Mac, the same selection principle applies: choose the boundary cell, then use View > Freeze Panes. The menu labels and ribbon layout can vary slightly by Excel version, but the Freeze Panes, Freeze Top Row, Freeze First Column, and Unfreeze Panes options provide the corresponding actions. If you do not see the command, check the View tab and the window’s current view.
Excel for the web also offers freeze-pane controls from the View tab. Select the boundary cell before choosing Freeze Panes for a custom arrangement; the top-row and first-column options are intended for those specific cases. Some controls and interface details can differ from desktop Excel, so verify the result by scrolling. Changes made in the browser are saved with the workbook when it is stored in a supported online location.
There is no need to use a formula or alter the worksheet data to freeze panes. This is a view setting, so the same workbook can be opened with its data intact even if a viewer chooses to unfreeze the panes.
Frequently Asked Questions
Can I freeze more than one row and one column in Excel?
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. Excel freezes the continuous rows above and columns to the left.
How do I freeze the first two columns?
Select a cell in column C, such as C1 if you do not want to freeze any rows, and choose View > Freeze Panes > Freeze Panes. Columns A and B remain visible as you scroll horizontally.
Can I freeze a row that is not at the top?
Not as an isolated row with Freeze Panes. Excel freezes a continuous block beginning at row 1, so freezing through row 8 also keeps rows 1 through 7 in place. Use Split if your goal is to view separate areas independently.
Does Freeze Panes keep headings visible when I print?
No. Freeze Panes affects the on-screen view only. For printed worksheets, use the print-title settings to repeat rows or columns on each page instead.
Why can I not freeze panes while another pane is split?
A split and frozen panes are different worksheet window arrangements and can conflict in how the sheet is displayed. Remove the split, select the intended boundary cell, and then apply Freeze Panes.