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.
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.
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.
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.
Related Articles
- How to Delete Rows in Excel: 7 Methods
- How to Use VBA to Remove Empty Rows in Excel
- Remove Multiple Rows with VBA in Excel (4 Ways)
- How to Use Macro to Delete Rows Based on Criteria in Excel (3 Ways)
- How to Remove Multiple Rows in Excel with Condition (3 Ways)
- How to Delete Every Other Row In Excel (4 Methods)