How to get rid of extra rows in Excel

Microsoft Excel offers a very interesting way to get rid of extra rows. We can cater to this problem statement by deleting the extra rows. We can perform the below mentioned way to get rid of extra rows in excel:

We’ll learn about this methodology step by step.

To do this yourself, please follow the steps described below;

Step 1 – Excel sheet with some values in rows

– Open the desired Excel workbook containing some values in different rows

Step 2 – Delete rows option

– Now select the rows which need to be deleted, then under the Home ribbon click on the “Delete” option and then select the “Delete Sheet rows” option

Step 3 – Rows deleted

– We can see that the extra rows have been got ridden of