After clicking on the Freeze Panes drop-down, choose the option Unfreeze Panes.

These are the things that you need to do to unfreeze the row(s): Scroll down, and you’ll see a frozen raw as something that is always visible similar to what is shown here:

You will then notice a gray line that is right underneath the first row.

Once you do this, your data set’s first row will freeze.

Check out the category Zoom and click on the drop-down Freeze Panes.

You can make the first row of your dataset freeze with these steps: You will see a gray line right below the frozen rows.Įvery header row will always be visible as you scroll down.

Once you do this, all of the rows above the cell that you selected will freeze.

Once you see the drop-down of Freeze Panes, choose Freeze Panes.

Check the category Zoom and click on the drop-down Freeze panes.

Right under the headers row, choose the cell in the left-most part.

Here are the ways you can use Excel to freeze rows: Whenever you have a dataset with header rows that are more than one, you may want to have all of the rows frozen. Let’s check out how you can have these options used in Excel to Freeze Panes as you work with large sets of data: Lock or Freeze More Than A Single Row in Excel

These are the options that you can use to have columns or rows (or both) locked into Excel’s panes.

Freeze Panes : Clicking on this option will freeze both the columns and the rows.

Make the First Column Freeze : It is an option that freezes all of the columns on the left part of the active cell.

Freeze Top Row : This will freeze all of the rows that are above the active cell.

There are three options that the drop-down of Freeze Panes will show:

Check out the category Zoom and then click on the drop-down Freeze panes.

Here are the steps that can help you access the options in Excel Freeze Panes: Ways You Can Access the Options in Freeze Panes Excel Whenever you work with large data sets, as you scroll to the right or down the spreadsheet, you can lose track of the column or row headings.įor these cases, we recommend that you use the feature Freeze Panes Excel as it can freeze your dataset’s columns or rows to allow the headers to always become visible as you scroll through your data.

How to freeze excel header