Deleting Multiple Rows 70 - 1037259

%3CLINGO-SUB%20id%3D%22lingo-sub-1565717%22%20slang%3D%22en-US%22%3EDeleting%20Multiple%20Rows%2070%20-%201037259%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1565717%22%20slang%3D%22en-US%22%3E%3CP%3EDoes%20anyone%20know%20a%20quick%20way%20to%20delete%20thousands%20of%20rows%20without%20holding%20down%20the%20shift%20key%20and%20using%20the%20page%20down%20key%20to%20get%20the%20last%20row%3F%26nbsp%3B%20I%20am%20starting%20at%20row%2070%20through%20row%201037259.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1565717%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1565774%22%20slang%3D%22en-US%22%3ERe%3A%20Deleting%20Multiple%20Rows%2070%20-%201037259%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1565774%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F749343%22%20target%3D%22_blank%22%3E%40Amhaack%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EType%20in%20name%20box%20(where%20A70%20now)%2070%3A1037259%2C%20Enter%20(rows%20will%20be%20selected)%2C%20Right%20click%20on%20row%2C%20Delete%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20183px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F210269iE1DBD99FEEB96B7E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1565776%22%20slang%3D%22en-US%22%3ERE%3A%20Deleting%20Multiple%20Rows%2070%20-%201037259%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1565776%22%20slang%3D%22en-US%22%3EDid%20you%20know%20that%20using%20CTRL-SHIFT-DownArrow%20will%20jump%20(%26amp%3B%20highlight)%20to%20the%20next%20change%20in%20the%20data%20(i.e.%20in%20the%20middle%20of%20a%20table%20it%20will%20go%20to%20the%20end%20of%20the%20table%2C%20if%20it%20is%20the%20end%20of%20the%20table%20it%20goes%20to%20the%20last%20row%20of%20the%20sheet).%20So%20in%20just%20a%20couple%20clicks%20you%20can%20get%20to%20the%20end.%20Alternatively%20if%20you%20have%20lots%20of%20'starts'%20and%20'stops'%20in%20a%20huge%20data%20table%20you%20can%20click%20CTRL-SHIFT-END%20(takes%20you%20to%20the%20last%20used%20cell%20in%20the%20sheet)%20and%20then%20CTRL-SHIFT-DOWN%20to%20continue%20to%20the%20bottom%20of%20the%20sheet.%20Then%20right-click%20in%20the%20area%2C%20select%20delete...%20then%20deleted%20'Entire%20row'%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1565964%22%20slang%3D%22de-DE%22%3ERE%3A%20Deleting%20Multiple%20Rows%2070%20-%201037259%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1565964%22%20slang%3D%22de-DE%22%3EIf%20I%20can%20add%20something%20in%20your%20wonderful%20detailed%20explanation%2C%20only%20as%20additional%20info.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20CTRL%20%2B%20SHIFT%20%2B%20Right%20Arrow%20for%20columns%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20best%20regards%20%3CBR%20%2F%3E%20Nikolino%20I%20know%20I%20%3CBR%20%2F%3E%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E
Occasional Visitor

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)