scorecard
  1. Home
  2. tech
  3. news
  4. How to freeze a row in Excel so it remains visible when you scroll, to better compare data on different parts of a spreadsheet

How to freeze a row in Excel so it remains visible when you scroll, to better compare data on different parts of a spreadsheet

Dave Johnson   

How to freeze a row in Excel so it remains visible when you scroll, to better compare data on different parts of a spreadsheet
Tech3 min read

Excel Spreadsheet Getty 1152104531

Matias Delacroix/Getty Images

It's possible to freeze a row in Excel using a few different methods.

  • You can freeze a row in Excel so it stays locked on the screen as you scroll, making it easy to compare data from different parts of the spreadsheet.
  • It's possible to freeze the first visible row at the top of the spreadsheet, or freeze a set of rows.
  • It's easy to unfreeze a row in Excel at any time using the same command.
  • Visit Business Insider's homepage for more stories.

Spreadsheets can get complicated, and frequently you need to be able to compare two different sets of data that are widely separated on your Mac or PC screen.

An easy way to do that is to lock a row (or column), so it stays in a fixed location while the rest of the spreadsheet scrolls up and down (or side to side).

There are two ways to do this: You can freeze the first visible row, or you can freeze a set of rows.

Check out the products mentioned in this article:

MacBook Pro (From $1,299.99 at Best Buy)

Lenovo IdeaPad 130 (From $299.99 at Best Buy)

How to freeze the top row in Excel

Keep in mind that this doesn't have to literally be the top row in your spreadsheet - this command lets you freeze the first visible row.

1. Scroll your spreadsheet until the row you want to lock in place is the first row visible under the row of letters.

2. In the menu, click "View."

3. In the ribbon, click "Freeze Panes" and then click "Freeze Top Row."

freeze 1

Dave Johnson/Business Insider

Choose Freeze Top Row to lock the top row (or the top visible row) to compare it to rows elsewhere in the spreadsheet.

Now, when you scroll through the spreadsheet, the top row that was visible will remain fixed while the rest of the spreadsheet scrolls under it.

How to freeze a set of rows in Excel

When you use this option, you're actually freezing all the rows from the top down to the row you want to freeze - you can't freeze a random row in the middle of a spreadsheet without locking everything above it at the same time.

1. Select the row below the set of rows you want to freeze.

2. In the menu, click "View."

3. In the ribbon, click "Freeze Panes" and then click "Freeze Panes."

freeze 2

Dave Johnson/Business Insider

Select the row under the one you want to freeze before selecting Freeze Panes.

How to unfreeze a row

Once you freeze a row, you can return to the Freeze Panes menu in the ribbon and choose "Unfreeze" to toggle the locked row.

freeze 3

Dave Johnson/Business Insider

You can release a row by returning to the Freeze Panes menu.

Related coverage from How To Do Everything: Tech:

READ MORE ARTICLES ON


Advertisement

Advertisement