How to Freeze Rows and Columns in Excel: Complete Guide (with Google Sheets)

Scrolling down a large spreadsheet and losing sight of your headers is a common frustration. Excel’s Freeze Panes feature locks specific rows or columns in place so they remain visible no matter how far you scroll. This guide covers freezing the top row, first column, or any custom area — plus the equivalent steps in Google Sheets.

1. Freeze the Top Row (Header Row)

1. Open your Excel spreadsheet. No cell selection is required.
2. Click the View tab in the ribbon.
3. In the Window group, click the Freeze Panes dropdown.
4. Select Freeze Top Row.
5. A slightly thicker horizontal line appears below row 1, confirming the freeze. Scroll down and row 1 stays fixed.

2. Freeze the First Column

1. Click View → Freeze Panes.
2. Select Freeze First Column.
3. A thicker vertical line appears to the right of column A. Scroll right and column A stays visible.

3. Freeze Multiple Rows and Columns Simultaneously

To freeze the first two rows and first two columns at the same time:

1. Click the cell that is one row below and one column to the right of the area you want to freeze. For example, to freeze rows 1–2 and columns A–B, click cell C3.
2. Click View → Freeze Panes → Freeze Panes (the first option in the list).
3. Thick lines appear above row 3 and to the left of column C, confirming that both rows 1–2 and columns A–B are frozen.

4. Unfreeze Panes

1. Click View → Freeze Panes.
2. The top option now reads Unfreeze Panes. Click it to remove all freeze settings.

Note: You must unfreeze before applying a different freeze position — Excel does not allow layered freeze settings.

5. Freeze Panes vs. Split Windows

• Freeze Panes: Locks a fixed area while the rest of the sheet scrolls freely. Best for keeping headers visible.
• Split: Divides the sheet into 2 or 4 independently scrollable panels. Useful for comparing data in different parts of a large spreadsheet.

6. Freeze Rows and Columns in Google Sheets

Google Sheets uses a slightly different menu path:

1. Open Google Sheets and click View in the menu bar.
2. Hover over Freeze.
3. Choose from the submenu:
   • No rows / 1 row / 2 rows / Up to current row
   • No columns / 1 column / 2 columns / Up to current column
4. To freeze at a custom position, click a cell first, then choose “Up to current row” or “Up to current column.”
5. A thick gray line marks the frozen boundary.

To unfreeze in Google Sheets, return to View → Freeze and select No rows / No columns.

7. Troubleshooting

• Can’t find Freeze Panes: Make sure you are on the View tab, not Page Layout or Data.
• Freeze affects printing: Freeze Panes only controls on-screen display. For print headers, use Page Layout → Print Titles → Rows to repeat at top.
• Freeze not working in shared workbook: Some legacy Excel sharing modes restrict certain features. Work in your own copy or use the modern co-authoring mode.

Mastering Freeze Panes makes navigating large datasets significantly more efficient. Pair it with filtering and sorting for full control over your data. To export your spreadsheet as PDF or handle other file conversions, use the free tool below.

Do it in your browser — the file never leaves your device: PDF Tools