Highlighting very large data files without scrolling

%3CLINGO-SUB%20id%3D%22lingo-sub-1954020%22%20slang%3D%22en-US%22%3EHighlighting%20very%20large%20data%20files%20without%20scrolling%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1954020%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20excel%20spreadsheets%20with%20over%2050K%20rows.%20How%20can%20I%20highlight%20all%20of%20the%20data%20for%20sorting%20without%20holding%20the%20mouse%20button%20down%20forever%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1954020%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1954078%22%20slang%3D%22de-DE%22%3ESubject%3A%20Highlighting%20very%20large%20data%20files%20without%20scrolling%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1954078%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F890319%22%20target%3D%22_blank%22%3E%40stevensmall%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDon't%20know%20exactly%20what%20you%20want.%20But%20data%20files%20without%20scrolling%20can%20be%20done%20in%20a%20variety%20of%20ways.%3C%2FP%3E%3CP%3Ewith%20a%20table%2C%20with%20filter%2C%20with%20pivot%2C%20with%20search%20%26amp%3B%20find%20function%2C%20with%20VBA.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20the%20search%20%26amp%3B%20find%20option%3C%2FP%3E%3CP%3EIn%20the%20back%20right%20area%20of%20the%20menu%20ribbon%20you%20will%20find%20the%20section%20%22Edit%22.%20There%20you%20click%20on%20%22Search%20and%20Select%22%2C%20the%20menu%20item%20is%20marked%20with%20binoculars.%20In%20the%20drop-down%20menu%20you%20then%20have%20numerous%20options%20for%20what%20Excel%20should%20search%20your%20table%20for%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EInformation%20about%20this%3A%3C%2FP%3E%3CP%3ELook%20up%20values%20in%20a%20list%20of%20data%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Flook-up-values-in-a-list-of-data-c249efc5-5847-4329-bfee-ecffead5ef88%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Flook-up-values-in-a-list-of-data-c249efc5-5847-4329-bfee-ecffead5ef88%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%3C%2FA%3E%3C%2FP%3E%3CP%3EFind%20or%20replace%20text%20and%20numbers%20on%20a%20worksheet%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Ffind-or-replace-text-and-numbers-on-a-worksheet-0e304ca5-ecef-4808-b90f-fdb42f892e90%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Ffind-or-replace-text-and-numbers-on-a-worksheet-0e304ca5-ecef-4808-b90f-fdb42f892e90%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20would%20be%20advantageous%20for%20you%20if%20you%20knew%20the%20Excel%20version%20and%20the%20operating%20system%2C%20as%20well%20as%20a%20precise%20description%20of%20what%20you%20would%20like%20to%20achieve.%20Ideally%20with%20a%20file%20(without%20sensitive%20data).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have excel spreadsheets with over 50K rows. How can I highlight all of the data for sorting without holding the mouse button down forever?

2 Replies

@stevensmall 

Don't know exactly what you want. But data files without scrolling can be done in a variety of ways.

with a table, with filter, with pivot, with search & find function, with VBA.

 

Here is the search & find option

In the back right area of the menu ribbon you will find the section "Edit". There you click on "Search and Select", the menu item is marked with binoculars. In the drop-down menu you then have numerous options for what Excel should search your table for

 

Information about this:

Look up values in a list of data

https://support.microsoft.com/en-us/office/look-up-values-in-a-list-of-data-c249efc5-5847-4329-bfee-...

Find or replace text and numbers on a worksheet

https://support.microsoft.com/en-us/office/find-or-replace-text-and-numbers-on-a-worksheet-0e304ca5-...

 

It would be advantageous for you if you knew the Excel version and the operating system, as well as a precise description of what you would like to achieve. Ideally with a file (without sensitive data).

 

Thank you for your understanding and patience

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here

@stevensmall 

On first cell Shift+Ctrl+Down. After that left/right arrow key if necessary without releasing Ctrl and Shift