How to Delete Rows in Excel That Go on Forever (4 Easy Ways)

While working in Excel we may need to delete rows for many reasons. Like, there might be irrelevant data or blank cells. So it’s a pretty necessary task. This article will guide you to learn how to delete rows in excel that go on forever.

Table of Contents hide

Download Practice Book

4 Easy Methods to Delete Rows in Excel That Go on Forever

Method 1: Use Manual Method to Delete Rows in Excel That Go on Forever

Method 2: Use Delete Tab to Remove Rows in Excel That Go on Forever

Method 3: Apply Find & Select Tool Delete Rows in Excel That Go on Forever

Method 4: Insert Filter Option to Remove Rows Forever in Excel

Conclusion

Download Practice Book

You can download the free Excel template from here and practice on your own.

Delete Rows in Excel.xlsx

4 Easy Methods to Delete Rows in Excel That Go on Forever

Method 1: Use Manual Method to Delete Rows in Excel That Go on Forever

Let’s get introduced to our dataset first. For this article, I have made a dataset which represents some clothes’ names, codes and quantities. In our very first method, I’ll use the manual method to delete rows in excel.

Steps:

➽ Select the rows that you want to delete.

➽ Then right-click your mouse.

➽ Select Delete from the context menu.

You’ll notice that the selected rows are deleted now.

Read more: How to Delete Multiple Rows in Excel

Method 2: Use Delete Tab to Remove Rows in Excel That Go on Forever

In this method, we’ll delete rows in excel that go on forever using the Delete tab from the Home ribbon.

Steps:

➽ First, select the rows.

➽ Click as follows: Home > Cells > Delete > Delete Sheet Rows

Then you will notice that those rows are no more.

Method 3: Apply Find & Select Tool Delete Rows in Excel That Go on Forever

Here, we’ll use the Find & Select tool to delete blank rows in excel that go on forever. This is useful when you’re working with large spreadsheets or when you need to change certain text repeatedly. For this method, I have placed two blank rows in my dataset.

Step1:

➽ Select the data range.

➽ Click: Home > Editing > Find & Select > Go To Special

A dialog box named “Go To Special” will appear.

Step 2:

➽ Mark on Blanks option.

➽ Press OK

The blank rows are now highlighted now.

Step 3:

➽ Then right-click your mouse and select Delete from the context menu.

A new dialog box will open up.

Step 4:

➽ Mark Entire row and press OK.

Now you’ll spot that the blank rows are gone forever.

Method 4: Insert Filter Option to Remove Rows Forever in Excel

Filtering data in Excel refers to displaying only the rows that meet certain conditions. We’ll apply it here in our last method to remove blank rows in excel.

Step 1:

➽ Select the data range included title.

➽ Click serially: Data > Filter

Then you will see the filter icon in every title box of your dataset.

Step 2:

➽ Press any filter icon, the filtering options will open up.

➽ Then unmark everything except (Blanks).

➽ Press the OK tab then.

It is showing only the blank rows now.

Step 3:

➽ Select those blank rows and right-click your mouse.

➽ Click Delete Row from the context menu.

The blank rows are deleted. Now we’ll execute the following steps to get back the other rows.

Step 4:

➽ Click the filter icon again.

➽ Mark (Select All) option.

➽ Finally, press OK.

Our filled rows are back now.

Conclusion

I hope all of the methods described above will be good enough to remove rows in excel that go on forever. Feel free to ask any questions in the comment section and please give me feedback.