How to Keep Row Headings in Excel When Scrolling (3 Ways)

We must view the row headers when working with a vast dataset that has many rows in order to enter more data and to grasp the dataset better when viewing them. In this article, we will show you how to keep Row Headings in Excel when scrolling.


Download Practice workbook

You may download the following Excel workbook for better understanding and practice yourself.


3 Handy Approaches to Keep Row Headings in Excel When Scrolling

When we work with a large dataset, the row headers will be unviewed at the time of scrolling down to the data. In the following ways, we will demonstrate how to keep Row Headings in Excel when Scrolling utilizing Freeze Panes, using the Split Pane Feature, and applying VBA Code. Let’s suppose we have a large sample data set. Here, we will show you 4 columns and 15 rows of data.

Sample Data


1. Utilizing Freeze Panes Tool to Keep Row Headings in Excel When Scrolling

Firstly, you will learn how to keep row headings in Excel when scrolling by utilizing the Freeze Panes Tool.

Step 1:

  • First, select row 5.
  • Secondly, go to the View tab.
  • Thirdly, choose the Freeze Panes Tool.
  • Finally, click on the Freeze Pane option.

Sample Data

Step 2:

  • Here, in this step, you will see the row header after scrolling down the data set.

Sample Data

Read More: How to Make First Row as Header in Excel (4 Simple Methods)


2. Using Split Pane Feature to Keep Row Headings in Excel

In this method, we will demonstrate how to keep row headings when scrolling using the Split Pane Feature.

Step 1:

  • From the data set, we will select row 5 to use with the Split Pane Feature.

Handy Approaches to Keep Row Headings in Excel when Scrolling

Step 2:

  • Now navigate to the View tab, and we will click on the Split option.

Handy Approaches to Keep Row Headings in Excel when Scrolling

Step 3:

  •  Consequently, we will scroll down the data set, and you will observe that the row headings are visible.

Handy Approaches to Keep Row Headings in Excel when Scrolling

Read More: How to Create a Double Row Header in Excel (3 Easy Ways)


Similar Readings


3. Applying VBA Code to Keep Row Headings in Excel

In this last section, we will generate a VBA code utilizing the Developer tab to keep row headings in Excel when scrolling.

Step 1:

  • At the start of this section, we will use the Developer tab.
  • Then, we will select the Visual Basic command.

Handy Approaches to Keep Row Headings in Excel when Scrolling

Step 2:

  • Here, the Visual Basic window will open.
  • After that, from the insert option, we choose the new Module to write a VBA Code.

Handy Approaches to Keep Row Headings in Excel when Scrolling

Step 3: 

  • Now, paste the following VBA Code into the Module. To run the program, click the Run button or press F5.
Sub Keep_Row_Headings()

'Freeze will be removed

ActiveWindow.FreezePanes = False
    
Range("B5").EntireRow.Select
    
' New Freeze will be created
     
 ActiveWindow.FreezePanes = True
End Sub

Handy Approaches to Keep Row Headings in Excel when Scrolling

VBA Code Breakdown

  • First, we call our Sub Procedure Keep_Row_Headings_Folder.
  • Then, we refer to our current Worksheet as Active Worksheet.
  • Now, we apply Auto_Freeze for the Active Worksheet.
  • Again, we specify our Range for our desired row to keep visible in the worksheet using Range (“B5”).EntireRow.Select.
  • Finally, the Row Header will be visible on the worksheet.

Step 4:

  • , As a result, you will see the outcomes of keeping row headings visible after scrolling down the data set.

Handy Approaches to Keep Row Headings in Excel when Scrolling

Read More: How to Change Column Header Name in Excel VBA (3 Examples)


Conclusion

In this article, I’ve covered 3 handy methods to keep Row headings in Excel when Scrolling. I sincerely hope you enjoyed and learned a lot from this article. Additionally, if you want to read more articles on Excel, you may visit our website, Exceldemy. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.


Related Articles 

Bishawajit Chakraborty

Bishawajit Chakraborty

I'm Bishawajit Chakraborty. Hello. I graduated from Rajshahi University of Engineering & Technology (RUET) with a degree in Mechanical Engineering. I'm working with ExcelDemy as a Content Developer for Excel & VBA. You can visit our website, Exceldemy if you'd like to read my published articles on MS Excel and VBA.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo