Freeze Panes Excel – Lock Row or Column Headers

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.

For 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.

Ways You Can Access the Options in Freeze Panes Excel

Here are the steps that can help you access the options in Excel Freeze Panes:

  • Click on the View tab.

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

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

  • Freeze Top Row: This will freeze all of the rows that are above the active cell.
  • Make the First Column Freeze: It is an option that freezes all of the columns on the left part of the active cell.
  • Freeze Panes: Clicking on this option will freeze both the columns and the rows.

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

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

Whenever you have a dataset with header rows that are more than one, you may want to have all of the rows frozen.

Here are the ways you can use Excel to freeze rows:

  • Right under the headers row, choose the cell in the left-most part.
  • Click on the tab ‘View.’
  • Check the category Zoom and click on the drop-down Freeze panes.

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

  • Once you do this, all of the rows above the cell that you selected will freeze. You will see a gray line right below the frozen rows.

Every header row will always be visible as you scroll down.

You can see something similar to this:

Freeze Excel’s Top Row

You can make the first row of your dataset freeze with these steps:

  • Click on the ‘View’ tab.
  • Check out the category Zoom and click on the drop-down Freeze Panes.

  • Tap on the option ‘Freeze Top Row.’

  • Once you do this, your data set’s first row will freeze. You will then notice a gray line that is right underneath the first row.

Scroll down, and you’ll see a frozen raw as something that is always visible similar to what is shown here:

Unfreeze the Rows in Excel

These are the things that you need to do to unfreeze the row(s):

  • Click on the tab ‘View.’
  • Check out the category Zoom and click on the drop-down Freeze Panes.

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

Options in Excel to Freeze Panes by Freezing Column(s)

Every time you work with a dataset with labels or headers in a column that has data spread across a lot of columns, scroll to the right, and the header will disappear like this:

For these cases, it would be best to make the column at the left-most part freeze for the headers always to be seen by the user.

Here, we will help you learn how to do the following:

  • Ways you can Unfreeze Columns.
  • How to Lock or Freeze the Left-most Column
  • Ways to Freeze or Lock More than One Column

Ways you can Unfreeze Columns

Unfreeze the column(s) by doing the following:

  • Click on the tab ‘View.’
  • Check out the Zoom category and click on the drop-down Freeze panes.

  • Once you get to the drop-down of Freeze Panes, choose the Unfreeze Panes option.

How to Lock or Freeze the Left-Most Column

These are the things you need to do if you want the left-most column to freeze:

  • Click on the tab ‘View.’
  • Check out the category Zoom and click on the drop-down Freeze panes.

  • Choose Freeze First Column that is in the drop-down Freeze Panes.

  • Doing this will make the data set’s left-most column freeze. Here, you will notice a gray line that appears at the left-most column’s right border.

As you scroll down, you will always see the left-most column similar to what is shown here:

Additional Notes:

  • You can have a column inserted to the left part of the frozen column even if the column inserted is frozen.
  • After freezing a column, you may not be able to unfreeze it with Control + Z. You need to check the drop-down Freeze Panes and use the option unfreeze.

How to Freeze or Lock More than One Column

Whenever there is more than one column with labels or headers that you want to freeze, here is the way on how you can do this:

  • Choose the column’s top-most cell that is right beside the columns with headers.
  • Click on the tab ‘View.’
  • Check out the category Zoom and click on the drop-down Freeze panes.

  • Click on Freeze First Colum in the drop-down Freeze Panes.

  • It will make all of the columns found at the left part of the chosen cell freeze. You will see a gray line that appears at the right side of the columns that got frozen.

As you scroll to the right, you will always see all of the columns that have headers just like what is seen here:

Unfreeze Excel Columns

If you want to unfreeze column(s) in Excel, do the following:

  • Click on the tab ‘View.’
  • Check out the category Zoom and click on the drop-down Freeze panes.

  • Once you get to the drop-down Freeze Panes, have the Freeze First Column selected.

  • It will make every column that is at the left of the chosen cell freeze. Here, you’ll notice a gray line that is at the right of the frozen columns.

With this, every column with a header will always be visible as you scroll to the right.

It needs to be similar to what you see here:

Unfreeze Excel Columns

Here are the ways you can unfreeze column(s):

  • Tap on the tab ‘View.’
  • Check out the category. Zoom and then click on the drop-down Freeze panes.

  • Once you get to the drop-down Freeze Panes, choose the Unfreeze Panes option.

Freeze Both Column(s) & Row(s)

Most of the time, the columns, including the rows, would have labels or headers.

Whenever this is the case, it would make sense to have both the columns and the rows frozen.

These are the ways on how you can go about this:

  • Choose a cell right next to the column and just beneath the rows that you desire to freeze.
    • For instance, whenever you want to have two columns (columns A and B) and two rows (rows 1 and 2) frozen, choose cell C3.
  • Click on the tab ‘View.’
  • Check out the category Zoom and click on the drop-down Freeze panes.

  • From the drop-down, select the option Freeze Panes.

  • Doing this will make the rows above and columns on the left of the chosen cell freeze. Here, you will see a couple of gray lines. One is right underneath the frozen rows, and the other is right next to the frozen columns.

Once you scroll to the right or down, you will always see the frozen columns and rows as what is seen here:

Whenever you want to have the frozen columns or rows unfreeze, these are the steps that you need to take:

  • Click on the tab ‘View.’
  • Check out the category Zoom and click on the drop-down Freeze panes.

  • Once you get to the drop-down Freeze Panes, choose the Unfreeze Panes option.

Notes:

  • It would be great to practice as you work with big data sets and have them converted into tables in Excel. As default, every row header in the Excel Tables will always be visible every time you scroll in the dataset.
  • Aside from working with big sets of data, it would be practical to use freeze panes in Excel whenever you make dashboards. With this, you can freeze columns and rows with the dashboard so the user won’t have to scroll away as they can always see the dashboard.

Become Knowledgeable on How to Freeze Panes and Lock Row or Column Headers in Excel with ExcelMaster

Know how to become an Excel expert with us! 

Get to know how to Freeze Panes and Lock Row or Column Headers in Excel with ExcelMaster NOW!

Leave a Comment