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

Excel Guide

How to Freeze Rows and Columns Simultaneously in Excel

If you have a large Excel file with data, freezing rows and columns can be useful to keep headers visible while scrolling. Here's how to freeze both rows and columns simultaneously:

Freeze Rows:

  1. Open your Excel file.
  2. Select the row below the last row you want to freeze. For example, if you want to freeze rows 1 and 2, select row 3.
  3. For Windows Users:
  4. Click the View tab.
  5. In the Window group, click Freeze Panes, then select Freeze Panes.
  6. For Mac Users:
  7. Click the View tab.
  8. In the Window group, click the Freeze Panes button, then select Freeze Panes.

You will see a thick line separating the frozen rows from the rest of the sheet. The frozen rows will stay in place when you scroll down.

Freeze Columns:

  1. Open your Excel file.
  2. Select the column to the right of the last column you want to freeze. For example, if you want to freeze columns A and B, select column C.
  3. For Windows Users:
  4. Click the View tab.
  5. In the Window group, click Freeze Panes, then select Freeze Panes.
  6. For Mac Users:
  7. Click the View tab.
  8. In the Window group, click the Freeze Panes button, then select Freeze Panes.

You will see a thick line separating the frozen columns from the rest of the sheet. The frozen columns will stay in place when you scroll to the right.

Freeze Rows and Columns Simultaneously:

  1. Open your Excel file.
  2. Select the cell below the last row and to the right of the last column you want to freeze. For example, if you want to freeze rows 1 to 3 and columns A to C, select cell D4.
  3. For Windows Users:
  4. Click the View tab.
  5. In the Window group, click Freeze Panes, then select Freeze Panes.
  6. Click the View tab again.
  7. In the Window group, click Freeze Panes, then select Freeze Panes.
  8. For Mac Users:
  9. Click the View tab.
  10. In the Window group, click the Freeze Panes button, then select Freeze Panes.
  11. Click the View tab again.
  12. In the Window group, click the Freeze Panes button, then select Freeze Panes.

You will see two thick lines, one separating the frozen columns and one separating the frozen rows. The frozen rows and columns will stay in place when you scroll.

Unfreezing Rows and Columns:

To unfreeze rows and columns:

  1. For Windows Users:
  2. Click the View tab.
  3. In the Window group, click Freeze Panes, then select Unfreeze Panes.
  4. For Mac Users:
  5. Click the View tab.
  6. In the Window group, click the Freeze Panes button, then select Unfreeze Panes.

The frozen rows and columns will now scroll along with the rest of the sheet.