How to delete excess rows in Excel
By
SpreadCheaters
Page last updated:
17/11/2022 |
Next review date:
17/11/2024
You can watch a video tutorial here.
Step 1 – Select the first row
– Select the row after which you want all the following rows to be deleted
Step 2 – Select the rest of the rows containing data
– Hold down the Ctrl+Shift keys and press the down-arrow once
– The rows up to the end of the data are selected
Step 3 – Select the rest of the rows
– Press the down-arrow again to select the rows till the end of the sheet
Step 4 – Delete the rows
– Right-click and select Delete from the context menu
Step 5 – Check the result
– All the rows after and including the selected row are deleted
