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.


Download Practice Book

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


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.

Manual Method to Delete Rows in Excel That Go on Forever

Steps:

➽ Select the rows that you want to delete.

➽ Then right-click your mouse.

➽ Select Delete from the context menu.

Manual Method to Delete Rows in Excel That Go on Forever

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

Delete Tab to Delete Rows in Excel That Go on Forever

Then you will notice that those rows are no more.

Delete Tab to Delete Rows in Excel That Go on Forever


 

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.

Find & Select Tool Delete Rows in Excel That Go on Forever

Step 2:

➽ Mark on Blanks option.

➽ Press OK

Find & Select Tool Delete Rows in Excel That Go on Forever

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.

Find & Select Tool Delete Rows in Excel That Go on Forever

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

Read more: How to Delete a Row If a Cell is Blank in Excel


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.

Filter Option Delete Rows in Excel That Go on Forever

Step 2:

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

➽ Then unmark everything except (Blanks).

➽ Press the OK tab then.

Filter Option Delete Rows in Excel That Go on Forever

It is showing only the blank rows now.

Filter Option Delete Rows in Excel That Go on Forever

Step 3:

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

➽ Click Delete Row from the context menu.

Filter Option Delete Rows in Excel That Go on Forever

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.


Related Articles

Mithun

Hello! I am Md. Sourov Hossain Mithun. Welcome to my profile. Excel is an amazing softwear. Here i will post excel related useful articles. I am a graduate from Bangladesh University of Engineering and Technology. I love to learn new things and work with it. Thank you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo