As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

How to Freeze Rows in Excel: Step-by-Step Guide

Working with large Excel spreadsheets often involves the need to keep specific rows, like column headers, visible while scrolling. This process, known as "freezing" rows, is straightforward in Excel. Here's a step-by-step guide.

How to Freeze Rows in Excel:

  1. Select the row below the ones you want to keep visible:
  2. For instance, if you want to freeze row 1, select row 2.
  3. On the View tab, in the Window group, click Freeze Panes:
  4. Click "Freeze Panes" from the dropdown menu.
  5. Click Freeze Panes in the submenu.

How to Unfreeze Rows in Excel:

If you want to unfreeze the rows, follow these steps:

  1. On the View tab, in the Window group, click Freeze Panes:
  2. Click "Unfreeze Panes" from the dropdown menu.

How to Freeze Multiple Rows in Excel:

You're not limited to freezing just one row. To freeze multiple rows:

  1. Select the row below the last row you want to freeze.
  2. On the View tab, in the Window group, click Freeze Panes:
  3. Click "Freeze Panes" from the dropdown menu.

How to Freeze Rows and Columns at the Same Time:

Freezing both rows and columns simultaneously is also possible:

  1. Select the cell below and to the right of the area you want to keep visible.
  2. On the View tab, in the Window group, click Freeze Panes:
  3. Click "Freeze Panes" from the dropdown menu.

Additional Tips:

Here are some additional tips to enhance your understanding of frozen rows and columns in Excel:

  • You can only have one area of a worksheet frozen or split at a time.
  • When scrolling, the frozen or split area remains visible while the rest of the worksheet scrolls.
  • If you sort data in a worksheet with frozen rows or columns, the frozen area remains static.
  • To quickly freeze or split multiple areas, select the cell below and to the right of the entire area you want to keep visible.

Example:

For instance, if you have a worksheet containing customer information and you wish to keep the first row (column headers) visible while scrolling, select cell B2. Then, on the View tab, in the Window group, click Freeze Panes and choose "Freeze Panes" from the submenu.