How to delete all rows below in Excel
By
SpreadCheaters
Page last updated:
03/12/2022 |
Next review date:
03/12/2024
Microsoft Excel offers a very interesting way to delete all rows below. We can cater to this problem statement by using the delete rows option. We can perform the below mentioned way to delete all rows below 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 multiple rows
– Open the desired Excel workbook containing a multiple rows which need to be deleted
Step 2 – Delete rows option
– Now select the rows which you want to delete, then go to “Delete” option in home menu, and then select the “Delete Sheet Rows” option
Step 3 – Rows deleted
– We can see that all the rows below have been deleted
