Forum Discussion
Deleting Multiple Rows 70 - 1037259
Does anyone know a quick way to delete thousands of rows without holding down the shift key and using the page down key to get the last row? I am starting at row 70 through row 1037259.
Thank you.
4 Replies
- Did you know that using CTRL-SHIFT-DownArrow will jump (& highlight) to the next change in the data (i.e. in the middle of a table it will go to the end of the table, if it is the end of the table it goes to the last row of the sheet). So in just a couple clicks you can get to the end. Alternatively if you have lots of 'starts' and 'stops' in a huge data table you can click CTRL-SHIFT-END (takes you to the last used cell in the sheet) and then CTRL-SHIFT-DOWN to continue to the bottom of the sheet. Then right-click in the area, select delete... then deleted 'Entire row'
Thank you, that is so simple but I've had trouble finding that answer over the years and I am soooo psyched. It was so easy!
- If I can add something in your wonderful detailed explanation, only as additional info.
CTRL + SHIFT + Right Arrow for columns
best regards
Nikolino
I know I don't know anything (Socrates)
Type in name box (where A70 now) 70:1037259, Enter (rows will be selected), Right click on row, Delete
