How to freeze second row in excel

Sometimes, freezing just the top row isn't enough.

Excel freeze top 2 rows

Maybe your spreadsheet has several rows of headers or key information that you need to keep an eye on. Fortunately, Excel lets you freeze as many rows as you need. Here's how:

1. Click on the row number that is right below the rows you want to freeze.

   For example, if you want to freeze the first three rows, click on the row number 4.

2. Head over to the View tab on the Ribbon.
3. Click on Freeze Panes in the Window group.
4. Select Freeze Panes from the dropdown menu.

Now, all the rows above the one you selected will be frozen.

How to freeze columns in excel

How to freeze multiple columns in excel

How to freeze rows and columns in excel (at the same time)

How to freeze top row in excel

How to freeze rows and columns in excel

This is especially handy for larger spreadsheets with multiple tiers of data headers. It might feel a bit like you're building a data fortress, keeping all the important stuff where you can see it.

Of course, there might come a time when you need to unfreeze those rows.

Maybe you're done analyzing your data, or perhaps you need to make some changes to your headers. Whatever the reason, unfreezing rows is just as easy as freezing them. Here's how you do it:

1. Head to the View tab on the Ribbon.
2. Click
   how to freeze row in excel formula
   how to freeze row in excel spreadsheet