How to Sort Alphabetically in Excel

[@trishreece]

Thank you for streaming Reverend John Downey III's inaugural sermon! What a gift!

[@kvijay7564]

Excellent video

[@accounts-mahdialrouilitran4231]

thank you so much for your help...greetings from saudi arabia

[@nirupamachathurika7478]

Thank you sir it's video very usefully

[@Μυρτωτ-ζ6ψ]

Hello, thanks for the video, it was very helpful. I would like to ask how can we sort our data by label, you mentioned it a little bit by formatting the cell with the header so that excel automatically distinguished it from the data we want to sort, but unfortunately this tip didn't work on my excel. I'm sure this must have something to do with the settings but i can't find it. Do you have any idea on this matter;

[@Thekcsoc]

Thanks, God Bless You !!!

[@CynthiaNduu]

This was so so helpful!!! Thank you!

[@justinchan6754]

Thank you so much for the video tutorial. Appreciate it! :)

[@grubershmuel]

Great video the floating arrow is great and probably a lot of work to synchronize it with the flow of the contents of the video. Great job

[@prakashchandrabarik4651]

Thanks 😊

[@CriticKai]

and how do u sort it together with its sales. pls answer

[@raden1998]

Block together all of them with cursor

[@alliealba8806]

Great vid! BUT my header is being sorted alphabetically as well. Does anybody know what I did wrong?

[@chetanchaturvedi5214]

Hi Allie Alba I want to talk to you please get in touch if you see this comment😣😣

[@Alexandra-rd6sx]

You have to make it distinct for the program to understand it's a header. Once you do, everything below the header should be alphabetized. Have you tried changing the color of the header?

[@aliheydari1997]

Thanks for sharing

[@uptownphotography]

We are trying to sort rows in numerical order (we have about 70 rows with these type numbers). We know that's doable in numerical order, however, the numbers are unusual and we have a special requirement. Her is an example of a column and each number is in a row: 2-6-0 2-10-2 2-6-2 4-8-2 4-4-2 2-8-2 2-8-4 2-6-4 2-8-0 0-6-0 2-10-0 The problem: The focus is on getting the middle number(s) all grouped together and then sorted in order with the first digit (and last digit) then being numerically sorted. We are trying to sort them like this in the column as an example: 4-4-2 0-6-0 2-6-0 2-6-2 2-6-4 2-8-0 2-8-2 2-8-4 4-8-2 2-10-0 2-10-2 Normal numerical sorting would not group these correctly like shown because it would use the first number as the sorting point.These numbers by the way are railroad steam engine designations for their wheel arrangements, for which I have about 70 vintage brass models of these in HO scale and I need to sort them correctly to find them easily on a spread sheet. There are 12 columns in our spread sheet (one column with the numbers above) and the other columns with other data like: manufacturer, whether factory painted, condition, w/original box, etc). Thanks and hoping there is a way to sort them. Thanks. Philip

[@lizetamado3201]

Try formating them as dates and then sort them like that.. just a thought

[@donkadabhargavi9796]

Thank you so much sir ❤️

[@ryanpoopypie2498]

I freaking love your videos...old school, very helpful!!!

[@yasinshaikh8029]

Can we use it in smart phone as well?

[@DemiizeLol]

Bro made a 3 minute video out of a 15 second tutorial

[@yvetteboheme2789]

Thank you so much!!!!!!

[@cohall46]

Very helpful. Thanks for sharing.

[@telosfd]

I have to say thank you.

[@xrmaxrma1787]

Thank you useful 📸

[@franciscopires8469]

Thank you, now i can finiish my work

[@KwtKwt-ud5km]

Its so good

[@sweetykumari-mr5th]

Tnqqq v much ❤️

[@תמירגובני]

thanks for the video it was extremely helpful

[@priyanshuranjan1401]

GOOD VIDEO

[@robw1950]

Very helpfull thank you

[@dylanhughes5387]

Hello, I'm making a list with vocabulary words for my students and some of the words are verbs (and therefore starting with "To"). The problem is that Excel then sorts them under words starting with the letter "T". How can I make Excel sort alphabetically whilst at the same time ignoring the word "To"? Thank you.

[@aarongreen1085]

Thankyou Thankyou

[@allkiller_arnav1317]

thank you very much

[@kidscorner9261]

Can we sequence data if we have name and no,s in the same column please

[@ewanders]

Thank You !

[@Jun-wv4oz]

Go to 2:30 thank me later

[@Rassy_]

Saved my life - so much unnecessary talking

[@0truckmafk]

Thank you.

[@troymiller5739]

Thank he is just going on and on

[@toniiblack7014]

Thank you lol

[@raychelleinjete4024]

Good presentation. I have subscribed...

[@sonusanthoshms5689]

Thanks

[@shahfaisal1382]

I am encountering an issue in this. I have a long list of employees and their data. My data data is getting sorted alphabetically in two parts. From different serials .

[@Justuskhan]

How did the sales stay with the correct name when he sorted?

[@caitanbraganca1943]

Thank you. Very useful video.

[@justjyotish]

EXCELLENT

[@marcielleb]

I like how to keep it all very simple. Thank you.

[@MR.AHADZAMAN]

Thanks man

[@AliAbbas-uh4oy]

Thanks, sir.

[@mnruxpin]

thank you

[@Psylinguist]

in excel i have several columns with words and headers. the columns have different number of words. some of the cells are empty. How to sort all the sheet alphabetically with all the columns in one click?

[@high5pirit]

the heading kept being included with the sorting. I don't know where I did wrong. Anyone help, please!

[@Mason_000]

*To do this, all merged cells need to be the same size.* What to do?

[@AndaIDA01]

Why some eaws cannot be sorted Alphabetically. Can you help me with it?

[@milkies4822]

Thank you

[@fraidadacalos9221]

How about using Iphone on Excel, How to sort A-Z..Can anyone Help thank you advance

[@ameeryt1233]

Thank you sir

[@dilbarofficial4915]

thanks alotte

[@hi.241]

Thank u

[@aphrodite3100]

AWESOME

[@francisflores944]

ready staaart>\\

[@upuludaya6842]

Thx

[@norf_4012]

How to distinguish the head because mine move with the data 🥺😭 HELPPPP

[@muslimvideo2433]

APPLE- I want this in separate cell Example- A1 B1 C1 D1 E1 A P P L E

[@SM-eq6uk]

Whenever the click sort, and box pops up.

[@lifeinsaltlakecity4001]

Thank you for this! Also, "Frank" backwards is "Knarf", and that's hilarious. (I'm truly sorry. Be glad you don't have my name)

[@travelwithme2544]

my frist row doesnt change, i try everything as u said. NOthing

[@smithgregg8357]

Plese i want it learn how to write on a single line...arrsnged not one going to the left and the other the right

[@damerboy]

so you dont need to select all the data to sort you'll just click the header.

[@eggshellresponsibilities5558]

wow Grace needs to pull herself up by her bootstraps if she thinks 19 sales is acceptable

[@eggshellresponsibilities5558]

George you're on thin ice too

[@dbrear1954]

I don't understand. First, he warns us NOT to include the header - then he tells us to start by clicking on the header.

[@nicholasryan559]

Coulda been a 30 second vid but whatever

[@ansarshaikh2718]

Long video waste time

[@gracemascioli68]

Thank you!

[@enkieta8787]

Thank you

[@FAIROOZBANNAPK]

Thanks

[@hunzaglory8313]

Thank u

[@lunyteve]

Thanks

[@muhammadfaris.k9858]

Thank u