SOLVED
Home

How can you select 43 001 lines in one swift movement?

%3CLINGO-SUB%20id%3D%22lingo-sub-957734%22%20slang%3D%22en-US%22%3EHow%20can%20you%20select%2043%20001%20lines%20in%20one%20swift%20movement%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-957734%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20how%20do%20you%20select%2043%20001%20lines%20in%20Excel%20(yes%2C%20I%20mean%20%22lines%22%2C%20not%20%22cells%22)%20using%20a%20very%20fast%20method%20%3F%3C%2FP%3E%3CP%3EI%20use%20Office%20365%20Excel%20on%20my%20HP%20Spectre%20i7%2C%20fiberglass%20to%20internet%20link%2C%20etc.%3C%2FP%3E%3CP%3EIn%20advance%20thanx%20from%20Paris%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-957734%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-957819%22%20slang%3D%22en-US%22%3ERE%3A%20How%20can%20you%20select%2043%20001%20lines%20in%20one%20swift%20movement%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-957819%22%20slang%3D%22en-US%22%3EOne%20option%20might%20be%20to%20convert%20the%20range%20to%20a%20table%20and%20then%20select%20the%20entire%20table%20from%20the%20top-left%20of%20the%20headers.%20If%20you%20are%20a%20fan%20of%20magic%20key%20combinations%20Ctrl%2BShift%2BEnd%20might%20do%20what%20you%20require.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-957988%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20you%20select%2043%20001%20lines%20in%20one%20swift%20movement%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-957988%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F434302%22%20target%3D%22_blank%22%3E%40YvesD%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EJust%20type%20in%20reference%20box%20(top%20left%20from%20A1)%201%3A43001%20or%20so.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-962991%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20you%20select%2043%20001%20lines%20in%20one%20swift%20movement%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-962991%22%20slang%3D%22en-US%22%3E%3CP%3EThanx.%20Not%20working.%20I%20need%20to%20select%20and%20delete%20LINES%2C%20not%20cells.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-963026%22%20slang%3D%22en-US%22%3ERE%3A%20How%20can%20you%20select%2043%20001%20lines%20in%20one%20swift%20movement%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-963026%22%20slang%3D%22en-US%22%3E%3CP%3EHi.%20Thanx.%20To%20be%20more%20precise%20%3A%3C%2FP%3E%3CP%3EIn%20my%20Excel%20sheet%20%3A%3C%2FP%3E%3CP%3E-%20my%20first%20line%20is%20n%C2%B01%3C%2FP%3E%3CP%3E-%20I%20want%20to%20select%20all%20the%20lines%20until%20the%20n%C2%B043%20001%3C%2FP%3E%3CP%3E-%20the%20last%20line%20is%20n%C2%B084%20703%3C%2FP%3E%3CP%3EI%20don't%20want%20to%20select%20the%20lines%20n%C2%B043%20002%20to%2084%20703%3C%2FP%3E%3CP%3ESo%20is%20there%20a%20key%20combination%20resembling%20%22%26nbsp%3B%3CSPAN%3ECtrl%2BShift%2BEnd%20%22%20that%20could%20work%3F%20...%20that%20wouldn't%20select%20until%20(the)%20END%20(of%20the%20sheet)%2C%20is%20what%20I%20mean.%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F214174%22%20target%3D%22_blank%22%3E%40Peter%20Bartholomew%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-963121%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20you%20select%2043%20001%20lines%20in%20one%20swift%20movement%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-963121%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F434302%22%20target%3D%22_blank%22%3E%40YvesD%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EUnder%20Lines%20you%20mean%20rows%20like%20this%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20712px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F151764i9DFD99E474F67A59%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eor%20something%20different%3F%20Above%20is%20selected%20by%203%3A8%20in%20the%20box.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-965579%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20you%20select%2043%20001%20lines%20in%20one%20swift%20movement%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-965579%22%20slang%3D%22en-US%22%3E%3CP%3EYes%20I%20mean%20%22%20rows%20%22%20(which%20in%20French%20is%20%22lignes%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-975215%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20you%20select%2043%20001%20lines%20in%20one%20swift%20movement%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-975215%22%20slang%3D%22en-US%22%3E%3CP%3EThanx%2C%20it%20works%2C%20have%20a%20great%20day%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-977659%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20you%20select%2043%20001%20lines%20in%20one%20swift%20movement%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-977659%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F434302%22%20target%3D%22_blank%22%3E%40YvesD%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
YvesD
Occasional Contributor

Hi, how do you select 43 001 lines in Excel (yes, I mean "lines", not "cells") using a very fast method ?

I use Office 365 Excel on my HP Spectre i7, fiberglass to internet link, etc.

In advance thanx from Paris

8 Replies
One option might be to convert the range to a table and then select the entire table from the top-left of the headers. If you are a fan of magic key combinations Ctrl+Shift+End might do what you require.
Solution

@YvesD 

Just type in reference box (top left from A1) 1:43001 or so.

Thanx. Not working. I need to select and delete LINES, not cells. 

@Sergei Baklan 

Hi. Thanx. To be more precise :

In my Excel sheet :

- my first line is n°1

- I want to select all the lines until the n°43 001

- the last line is n°84 703

I don't want to select the lines n°43 002 to 84 703

So is there a key combination resembling " Ctrl+Shift+End " that could work? ... that wouldn't select until (the) END (of the sheet), is what I mean. 

@Peter Bartholomew 

@YvesD 

Under Lines you mean rows like this

image.png

or something different? Above is selected by 3:8 in the box.

Yes I mean " rows " (which in French is "lignes")

 

@Sergei Baklan 

Thanx, it works, have a great day

@Sergei Baklan 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies