Freezing Rows And Columns In Excel

5.6 min read|Last Updated: May 8th, 2024|Categories: excel|
table of content

While working with large data sets in Excel, you’re usually forced to scroll down a lot, which will take the title of the columns and rows out of your sight. 

In situations like this, you can use the Excel Freeze Panes feature for keeping certain rows or columns in the view. By doing this, you will always have the selected rows and columns in view regardless of how far down you scroll. 

Accessing the Options for Excel Freeze Panes

Follow these steps:

  • Click on the View tab
  • Click on the Freeze Panes menu
  • You will see three options:
    • Freeze Panes: This allows you to freeze select rows or columns
    • Freeze top row: This just freezes the first top row of the excel sheet.
    • Freeze the first column: By choosing this option, the first left column will be frozen.
How to use freeze panes option in order to freeze rows and columns in Excel

You can use these options for freezing rows or columns (or both) in Excel panels.

Let’s see how we can use these tools for freezing rows or columns in Excel while working with large data sets. 

Freezing Rows in Excel

If you’re working with a large dataset and your columns have headers, as soon as you start scrolling down, the titles of the columns will move out of your sight. Like the example below:

In cases like these, it’s good practice to freeze the title rows, so they’re always visible.

In this part we’re going to learn:

  • How to freeze the top row
  • How to freeze more than one row
  • How to unfreeze rows

Freezing the Top Row in Excel

We’re going to the first row in your dataset:

  • Click on the View tab
  • Click on the Freeze Panes menu
  • Click on the Freeze Top Rows option
  • This action will freeze the first row. Now you can see a visible grey line under the frozen row.

Now, if you scroll down, the frozen line will not move and will always stay in view. This is what you will see:

https://www.youtube.com/watch?v=aqpLYYsE5MI

Freezing/Locking More than One Row in Excel

In some cases, you might need to freeze a few rows. Let’s see how to do that:

  • Select the furthest cell on the left side which is below the title row
  • Click on the View tab
  • Click on the Freeze Panes menu
  • Select the Freeze Panes option