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 y...
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!