Keep Row Headings in Excel When Scrolling Without Freeze

When we work with a large dataset with tons of rows, we need to view the row headings to input more data and to better understand the dataset while viewing them. The common way to do this is by using the Freeze feature inside Excel. However, in this article, we will show you how to keep row headings visible in Excel when scrolling without Freeze by using the Split Pane and creating a Table.


Download Practice Workbook


2 Handy Approaches to Keep Row Headings in Excel When Scrolling Without Freeze

To demonstrate our methods, we have selected a dataset with 4 columns consisting of “Product”, “Brand”, “Model”, and “Price”. Basically, our dataset contains the data for an electronics retail store. Moreover, it has 24 rows of data. Now, we can not see the last entry of the dataset properly.

Keep Row Headings in Excel when Scrolling without Freeze 1

If we scroll down, then we will be able to see the last entry. However, the row headings are not visible anymore. We will fix this using the Split Pane and Table features of Excel.

Keep Row Headings in Excel when Scrolling without Freeze 2


1. Keeping Row Headings in Excel When Scrolling Without Freeze by Using Split Pane Feature

In this section, at first, we will select a row below the first-row heading. Then, we will use the Split command to create a new view in the dataset. Consequently, this view will keep the row headings visible when scrolling, and we are not using the Freeze feature.

Steps:

  • To begin with, select cell B5.
  • Next, from the View tab → select Split.

Keep Row Headings in Excel when Scrolling without Freeze 3

  • After that, it will bring two Gray lines to the dataset. These lines indicate the Split feature is turned on.

Keep Row Headings in Excel when Scrolling without Freeze 4

  • Therefore, we can scroll down from row 5 and the row headings will still be visible in Excel.

Keep Row Headings in Excel when Scrolling without Freeze 5

  • However, we cannot see any other Sheets inside the Workbook. To make them appear again, the Split feature needs to be turned off.
  • To do so, again from the View tab → deselect Split. After that, the Sheets will be visible once again.

Keep Row Headings in Excel when Scrolling without Freeze 6

Read More: How to Create Excel Table with Row and Column Headers


2. Creating Table to Keep Row Headings When Scrolling Without Freeze

In this last method, we will use the Excel Table to keep row headings visible when scrolling without Freeze. Firstly, we will select the whole range or a single cell inside the dataset (for this case, there should not be any adjacent data, for example, in our dataset row 3 is empty). Secondly, we will utilize the Table command to convert the dataset into a table. Then, if we scroll down, the row headings will not disappear.

Steps:

  • At first, select anywhere inside the dataset. We have selected cell C10.
  • Afterward, from the Insert tab → select Table.
  • So, this will make the Create Table dialog box pop up.
  • Then, check if the data range is correct and make sure the “My table has headers” option is selected.
  • After that, press OK.

Create Table Dialog Box

  • By doing so, it will convert the dataset into a table and we can see the filter arrows or buttons in the row headings.

Filter Button

  • Next, if we scroll down, then we will notice the row headings are not visible.

Row Headings Not Visible in Table

  • To make the row headings visible, we need to click anywhere inside the table. Moreover, notice that as we have selected cell D19, the row headings appeared.

Keep Row Headings in Excel when Scrolling without Freeze

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


Practice Section

We have added a practice dataset for each method in the Excel file. Therefore, you can follow along with our methods easily.

Practice Dataset


Conclusion

We have shown you 2 handy approaches to how to keep row headings in Excel when scrolling without Freeze. If you face any problems regarding these methods or have any feedback for me, feel free to comment below. Moreover, you can visit our site ExcelDemy for more Excel-related articles. Thanks for reading, keep excelling!


Related Articles 

Rafiul Haq

Rafiul Haq

Hello! This is Rafiul. I have an engineering degree and an MBA (finance) degree. I am passionate about all things related to data, and MS Excel is my favorite application. I want to make people's lives easier by writing easy-to-follow and in-depth Excel and finance related guides here at ExcelDemy.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo