How to delete all rows below in excel
While you scroll down the list of options, you will come across an option titled ‘ Hidden Rows and Columns’.
![how to delete all rows below in excel how to delete all rows below in excel](https://cdn.windowsreport.com/wp-content/uploads/2019/08/delete-sheet-rows-excel.png)
Then click the Run button to execute the code.R.Offset(1, 0).SpecialCells(xlCellTypeVisible).EntireRow.Delete R.AutoFilter Field:=2, Criteria1:="Sales"
How to delete all rows below in excel code#
After that enter the following code into the Module.Click Developer → Visual Basic, a new Microsoft Visual Basic for Applications window will be displayed.At first, select all the rows you need to filter ( including the column headers).Then you can also use the VBA to get the above task done more quickly. If you are familiar with VBA code or feel comfortable working with VBA.
How to delete all rows below in excel how to#
Read More: How to Filter and Delete Rows with VBA in Excel (2 Methods)
But don’t worry!! It will not affect the other rows that are currently hidden.
![how to delete all rows below in excel how to delete all rows below in excel](https://www.howtogeek.com/wp-content/uploads/2019/10/2019-10-28_15h08_40.png)
![how to delete all rows below in excel how to delete all rows below in excel](https://www.alphr.com/wp-content/uploads/2019/07/Picture1.png)