When you have data with a header one of the most important tasks that you can do is to learn how to freeze a row in Excel. For example, if you have a header row in your data and you need to be able to scroll down but keep the header visible, so you know what you are looking at. In this tutorial I will show you how to freeze the top row and any other row that you may need to freeze.

How to Freeze the Top Row in Excel

First, we will start out with our dataset:

As you can see, we have a list of names, addresses, cities, and phone numbers. As this grows, we will need to keep that header information as we scroll.

Step 1: In the ribbon click on View then click Freeze Panes:

Step 2: From the drop-down menu that appears once you click on Freeze Panes click on the option to Freeze Top Row:

You will now be able to scroll through your spreadsheet and the top row will always be visible:

Freeze A Row Other than the Top Row

Here we will cover how to freeze a row in Excel when it is not the top row. We will use the same dataset from the previous example however this time there will be a title called Neighborhood Neighbors:

Freezing the top row in this scenario will not work since the header will scroll.

Step 1: Select the row below the line that you want to freeze. For example, in the dataset above I want to freeze under the name, address, city, and phone number header so therefore I will highlight row 3.

Step 2: In the ribbon click on View then click Freeze Panes:

Step 3: Then in the menu click on Freeze Panes:

Now the title row and header row will be displayed when you scroll as seen below:

Why is freezing rows in Excel beneficial?

Freezing rows in Excel is beneficial because it is a common and essential skill to learn and commit to memory for efficient spreadsheet management. This practice helps in keeping header information visible while scrolling through large datasets, improving data readability and user experience. Stay tuned for tomorrow’s tutorial on how to lock cells in Excel. Until next time…