Empty lines can cause a lot of havoc to your worksheets on different levels and deleting them manually can be a time-consuming and error-prone process. In this article, you will learn a few simple and reliable methods to remove blank rows from your Excel worksheets. Continue reading
Comments page 2. Total comments: 26
Is this a valid method?
Filter what you wanted to delete, and select all rows.
Find & Select > Go to Special > Visible Cells Only
Right click and delete.
Hi Sahil,
I would advise to never use this method unless you want to delete all the rows that contain at least one blank cell. For the detailed explanation, please check out How NOT to delete blank rows in Excel.