How to Fix a Row in Excel: Freeze & Split Guide

Freezing a row in Excel keeps it visible while you scroll through the rest of your sheet. This is essential when you have a header row or a label column that you want to see at all times. This guide shows you how to freeze the top row, freeze multiple rows, and freeze columns, plus how to unfreeze them when you’re done.

What You’ll Need

• A computer with Microsoft Excel (2010 or newer, including Microsoft 365).
• An Excel workbook (.xlsx or .xls) with the data you want to work with.
• Basic familiarity with Excel’s ribbon interface (the tabs at the top like Home, Insert, Page Layout, etc.).

Step-by-Step

Freeze the Top Row (The Most Common Case)

1. Open your Excel workbook and navigate to the worksheet that contains the row you want to keep visible.
2. Click on the View tab in the ribbon at the top of the window.
3. In the Window group, you’ll see a button labeled Freeze Panes. Click it.
4. From the dropdown menu, select Freeze Top Row. A thin black line will appear below row 1, indicating that it is frozen.
5. Now scroll down your sheet. Row 1 will stay at the top, while the rest of the rows move.

Freeze the First Column (For Label Columns)

1. Go to the View tab again.
2. Click Freeze Panes.
3. Choose Freeze First Column. A vertical line will appear to the right of column A.
4. Scroll horizontally, and column A will remain in place.

Freeze Multiple Rows (e.g., Top Two Rows)

1. Decide how many rows you want to freeze. For example, to freeze rows 1 and 2, you need to select row 3.
2. Click on the row number 3 on the left side of the sheet to highlight the entire row.
3. Go to the View tab, click Freeze Panes, and select Freeze Panes (the first option in the dropdown).
4. Excel will freeze everything above the selected row. You’ll see a line below row 2.

Freeze Both Rows and Columns (e.g., Top Row and First Column)

1. Click on the cell that is just below the rows you want to freeze and just to the right of the columns you want to freeze. For example, to freeze row 1 and column A, click on cell B2.
2. Go to the View tab, click Freeze Panes, and select Freeze Panes.
3. You’ll see a horizontal line below row 1 and a vertical line to the right of column A. Both will stay in view when you scroll.

Unfreeze Panes

1. Go to the View tab.
2. Click Freeze Panes.
3. Select Unfreeze Panes. All frozen rows and columns will be released.

Common Mistakes

• Freezing the wrong row: If you select a row and choose “Freeze Panes,” Excel freezes everything above that row, not the row itself. To freeze rows 1-3, you must select row 4.
• Using “Freeze Panes” when you meant “Freeze Top Row”: The “Freeze Top Row” option always freezes row 1. If you want rows 1 and 2, you must use the general “Freeze Panes” command.
• Forgetting to unfreeze before printing: Frozen panes can affect how your sheet prints. If you don’t want the frozen header on every printed page, unfreeze first.
• Clicking on a cell instead of a row number: When freezing multiple rows, you must select the entire row (by clicking the row number) or a cell in that row. If you just click a cell, Excel may freeze the rows above that cell, which might not be what you expect.

Tips

• Use keyboard shortcuts: Press Alt + W + F + F to freeze panes (after selecting the right cell), and Alt + W + F + R to freeze the top row.
• Freeze for easier data entry: If you’re entering data into a large table, freezing the header row and the first column (ID or name) helps you keep track of which column you’re in.
• Use Split instead for temporary views: If you only need to compare distant parts of the sheet temporarily, use the “Split” command (also under View > Window). It creates separate scrollable panes without permanently freezing anything.
• Check the freeze line: After freezing, a dark grey line appears. If you don’t see it, you may have accidentally unfrozen or selected the wrong option.

Troubleshooting

• The Freeze Panes option is greyed out: This usually happens when you’re in cell edit mode or when the sheet is protected. Press Esc to exit edit mode, or go to Review > Unprotect Sheet if it’s protected.
• Freezing doesn’t work on multiple sheets: Freeze panes applies only to the active sheet. You need to set it separately for each sheet where you want it.
• Rows scroll even after freezing: Double-check that you selected the correct option. If you used “Freeze Top Row” but you wanted rows 1-2, it won’t work. Use “Freeze Panes” with the selection on row 3.
• Frozen rows disappear when I scroll: This can happen if you have “Hide” applied to the row, or if you’re in Page Layout view. Switch back to Normal view (View > Normal) and check that the row isn’t hidden.

Frequently Asked Questions

How do I freeze the top row and the first column at the same time?

Click on cell B2 (the first cell that is not in row 1 or column A), then go to View > Freeze Panes > Freeze Panes. This freezes both row 1 and column A.

Can I freeze rows in Excel Online (the web version)?

Yes. In Excel Online, go to the View tab, and you’ll see the same Freeze Panes options. The steps are identical to the desktop version.

Why does my freeze panes option show “Unfreeze Panes” instead of “Freeze Panes”?

That means you already have frozen panes somewhere in the sheet. Click “Unfreeze Panes” first, then set up the freeze you want.

Does freezing a row affect printing?

No, freezing panes does not affect printing. To repeat a header row on every printed page, use Page Layout > Print Titles > Rows to repeat at top.

Can I freeze a row that is not at the top of the sheet?

Yes. Select the row below the one you want to freeze, then use “Freeze Panes.” For example, to freeze row 5, select row 6 and freeze panes.

How do I freeze a row in a specific area of a large sheet?

Click on the cell below the row and to the right of the column you want to freeze, then use “Freeze Panes.” This freezes everything above and to the left of that cell.

Related

• How to Use ChatGPT Safely on a Mac
• Recover Deleted Pictures on Samsung Galaxy J7
• GitHub Copilot CLI on Linux: Install and Use Safely