Delete Rows in Excel Archives

How to Remove Highlighted Rows in Excel (2 Easy Ways)

Feb 8, 2023

When working with large data sets in Microsoft Excel, you may need to remove specific rows from the worksheet because of security purposes. This ...

How to Remove Highlighted Rows in Excel (2 Easy Ways)

How to Delete All Rows Not Containing Certain Text in Excel

Feb 16, 2023

Often, we need to delete all rows that don’t contain specific text in Microsoft Excel. However, it’s easier to clear the cell contents all at once ...

How to Delete All Rows Not Containing Certain Text in Excel

How to Remove Rows Containing Identical Transactions in Excel

Feb 19, 2023

In many cases, we record transactions in Excel. And in various ways, we may include the same data in multiple rows which causes problems when we work ...

How to Remove Rows Containing Identical Transactions in Excel

[Fixed!] Not Enough Memory to Delete Rows Error in Excel

Dec 15, 2022

Memory issues are fairly common while using the Microsoft Excel program. The user's productivity is hampered by one of Excel's error warnings, and ...

[Fixed!] Not Enough Memory to Delete Rows Error in Excel

Excel VBA to Delete Rows with Specific Data (9 Examples)

Mar 24, 2023 3

We can delete rows in Excel using the delete command. We need to delete rows based on our needs. But when working with a big dataset, deleting rows ...

Excel VBA to Delete Rows with Specific Data (9 Examples)

How to Delete Rows Based on Another List in Excel (5 Methods)

Feb 16, 2023

Sometimes, while updating data, we have to delete excel rows from a list based on another list. Luckily, there we can do this row deletion using ...

How to Delete Rows Based on Another List in Excel (5 Methods)

Excel VBA: Delete Row If Cell Is Blank (A Complete Guide)

Mar 24, 2023

While working with VBA in Excel, we often need to delete a row if any cell is blank. In this article, I’ll show you how you can delete a row if a ...

Excel VBA: Delete Row If Cell Is Blank (A Complete Guide)

VBA to Delete Every Other Row in Excel (6 Criteria)

Feb 27, 2023

When we have a large amount of data with lots of unnecessary rows in our Excel worksheet, it is hard to understand sometimes. If we remove the rows ...

VBA to Delete Every Other Row in Excel (6 Criteria)

How to Delete Multiple Rows in Excel Using Formula (5 Methods)

Feb 16, 2023

This article gives a brief description of how to delete multiple rows in Excel using formula. There are several different ways to eliminate rows by ...

How to Delete Multiple Rows in Excel Using Formula (5 Methods)

How to Delete Multiple Rows in Excel at Once

Feb 27, 2023

Instead of deleting rows one by one, it will be helpful if we can delete multiple rows at once. In this article, I will try to show you the process ...

How to Delete Multiple Rows in Excel at Once

How to Delete Hidden Rows in Excel VBA (A Detailed Analysis)

Feb 12, 2023

In this article, I’ll show you how you can delete hidden rows from a worksheet with VBA in Excel. You’ll learn to delete hidden rows from both a ...

How to Delete Hidden Rows in Excel VBA (A Detailed Analysis)

How to Delete Rows in Excel without Affecting Formulas (2 Quick Ways)

Feb 12, 2023

Sometimes you need to delete rows in excel but want to keep the formulas. In this article, we will discuss how to delete rows in Excel without ...

How to Delete Rows in Excel without Affecting Formulas (2 Quick Ways)

How to Delete Rows in Excel with Specific Text (3 Methods)

Feb 19, 2023

We often need to delete rows with specific text in Microsoft Excel. I have explained 3 methods on how to delete rows in Excel with specific text in ...

How to Delete Rows in Excel with Specific Text (3 Methods)

How to Delete Row Using Macro If Cell Contains 0 in Excel (4 Methods)

Feb 15, 2023

Frequently you may need to omit unnecessary cells containing specific cell values that are no more useful for you. For example, you might delete ...

How to Delete Row Using Macro If Cell Contains 0 in Excel (4 Methods)

How to Delete Unfiltered Rows in Excel Using VBA (4 ways)

Feb 16, 2023

Sometimes, when while working with a dataset we want to filter data and only want the visible cells and delete unfiltered rows in Excel. In this ...