Deleting Multiple Rows 70 - 1037259

Copper Contributor

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. 

 

3 Replies

@Amhaack 

Type in name box (where A70 now) 70:1037259, Enter (rows will be selected), Right click on row, Delete

image.png

 

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'
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)