How to Sort Alphabetically in Excel

Поділитися
Вставка
  • Опубліковано 3 лют 2025

КОМЕНТАРІ • 84

  • @mariabencosme-jv8my
    @mariabencosme-jv8my 16 днів тому

    Excellent explanation. Now I learned. Thank you

  • @grubershmuel
    @grubershmuel 3 роки тому +2

    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

  • @kvijay7564
    @kvijay7564 Рік тому

    Excellent video

  • @trishreece
    @trishreece 11 місяців тому

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

  • @nirupamachathurika7478
    @nirupamachathurika7478 Рік тому

    Thank you sir it's video very usefully

  • @accounts-mahdialrouilitran4231
    @accounts-mahdialrouilitran4231 3 роки тому

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

  • @Thekcsoc
    @Thekcsoc Рік тому

    Thanks, God Bless You !!!

  • @CynthiaNduu
    @CynthiaNduu Рік тому

    This was so so helpful!!! Thank you!

  • @donkadabhargavi9796
    @donkadabhargavi9796 4 роки тому +4

    Thank you so much sir ❤️

  • @justinchan6754
    @justinchan6754 Рік тому

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

  • @cohall46
    @cohall46 3 роки тому

    Very helpful. Thanks for sharing.

  • @prakashchandrabarik4651
    @prakashchandrabarik4651 3 роки тому +1

    Thanks 😊

  • @yvetteboheme2789
    @yvetteboheme2789 3 роки тому +1

    Thank you so much!!!!!!

  • @aliheydari1997
    @aliheydari1997 2 роки тому

    Thanks for sharing

  • @ryanpoopypie2498
    @ryanpoopypie2498 3 роки тому +2

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

  • @תמירגובני
    @תמירגובני 3 роки тому

    thanks for the video
    it was extremely helpful

  • @ewanders
    @ewanders 3 роки тому

    Thank You !

  • @xrmaxrma1787
    @xrmaxrma1787 2 роки тому

    Thank you useful 📸

  • @robw1950
    @robw1950 2 роки тому

    Very helpfull thank you

  • @allkiller_arnav1317
    @allkiller_arnav1317 Рік тому

    thank you very much

  • @sonusanthoshms5689
    @sonusanthoshms5689 2 роки тому

    Thanks

  • @telosfd
    @telosfd Рік тому

    I have to say thank you.

  • @raychelleinjete4024
    @raychelleinjete4024 3 роки тому

    Good presentation. I have subscribed...

  • @KwtKwt-ud5km
    @KwtKwt-ud5km 9 місяців тому

    Its so good

  • @Μυρτωτ-ζ6ψ
    @Μυρτωτ-ζ6ψ 4 роки тому +7

    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;

  • @sweetykumari-mr5th
    @sweetykumari-mr5th Рік тому

    Tnqqq v much ❤️

  • @MR.AHADZAMAN
    @MR.AHADZAMAN 4 роки тому

    Thanks man

  • @priyanshuranjan1401
    @priyanshuranjan1401 3 роки тому +1

    GOOD VIDEO

  • @marcielleb
    @marcielleb 3 роки тому +3

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

  • @caitanbraganca1943
    @caitanbraganca1943 4 роки тому

    Thank you.
    Very useful video.

  • @franciscopires8469
    @franciscopires8469 3 роки тому +1

    Thank you, now i can finiish my work

  • @AliAbbas-uh4oy
    @AliAbbas-uh4oy 4 роки тому

    Thanks, sir.

  • @milkies4822
    @milkies4822 4 роки тому

    Thank you

  • @mnruxpin
    @mnruxpin 4 роки тому

    thank you

  • @Justuskhan
    @Justuskhan Рік тому

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

  • @yasinshaikh8029
    @yasinshaikh8029 2 роки тому

    Can we use it in smart phone as well?

  • @ameeryt1233
    @ameeryt1233 4 роки тому

    Thank you sir

  • @uptownphotography
    @uptownphotography 4 роки тому +3

    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
      @lizetamado3201 2 роки тому

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

  • @aarongreen1085
    @aarongreen1085 2 роки тому

    Thankyou Thankyou

  • @CriticKai
    @CriticKai 4 роки тому +4

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

    • @raden1998
      @raden1998 3 роки тому

      Block together all of them with cursor

  • @DemiizeLol
    @DemiizeLol 2 роки тому +10

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

  • @alliealba8806
    @alliealba8806 4 роки тому +13

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

    • @chetanchaturvedi5214
      @chetanchaturvedi5214 3 роки тому

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

    • @Alexandra-rd6sx
      @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?

  • @kidscorner9261
    @kidscorner9261 3 роки тому

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

  • @shahfaisal1382
    @shahfaisal1382 4 роки тому +2

    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 .

  • @Jun-wv4oz
    @Jun-wv4oz 4 роки тому +20

    Go to 2:30 thank me later

    • @Rassy_
      @Rassy_ 4 роки тому

      Saved my life - so much unnecessary talking

    • @0truckmafk
      @0truckmafk 4 роки тому

      Thank you.

    • @troymiller5739
      @troymiller5739 4 роки тому

      Thank he is just going on and on

    • @toniiblack7014
      @toniiblack7014 5 місяців тому

      Thank you lol

  • @dylanhughes5387
    @dylanhughes5387 4 роки тому +6

    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.

  • @justjyotish
    @justjyotish 3 роки тому

    EXCELLENT

  • @hi.241
    @hi.241 4 роки тому

    Thank u

  • @Psylinguist
    @Psylinguist 11 місяців тому

    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?

  • @fraidadacalos9221
    @fraidadacalos9221 2 роки тому

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

  • @Mason_000
    @Mason_000 2 роки тому

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

  • @AndaIDA01
    @AndaIDA01 2 роки тому

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

  • @dilbarofficial4915
    @dilbarofficial4915 3 роки тому

    thanks alotte

  • @upuludaya6842
    @upuludaya6842 4 роки тому

    Thx

  • @high5pirit
    @high5pirit 3 роки тому

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

  • @francisflores944
    @francisflores944 3 роки тому

    ready staaart>\\

  • @aphrodite3100
    @aphrodite3100 4 роки тому

    AWESOME

  • @muslimvideo2433
    @muslimvideo2433 3 роки тому

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

  • @lifeinsaltlakecity4001
    @lifeinsaltlakecity4001 4 роки тому +2

    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)

  • @SM-eq6uk
    @SM-eq6uk Рік тому

    Whenever the click sort, and box pops up.

  • @norf_4012
    @norf_4012 3 роки тому

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

  • @travelwithme2544
    @travelwithme2544 4 роки тому

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

  • @eggshellresponsibilities5558
    @eggshellresponsibilities5558 8 місяців тому

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

  • @smithgregg8357
    @smithgregg8357 3 роки тому

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

  • @argentto
    @argentto 3 роки тому

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

  • @dbrear1954
    @dbrear1954 10 місяців тому

    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
    @nicholasryan559 Рік тому

    Coulda been a 30 second vid but whatever

  • @ansarshaikh2718
    @ansarshaikh2718 9 місяців тому

    Long video waste time

  • @gracemascioli68
    @gracemascioli68 Рік тому

    Thank you!

  • @enkieta8787
    @enkieta8787 2 роки тому

    Thank you

  • @FAIROOZBANNAPK
    @FAIROOZBANNAPK 2 роки тому

    Thanks

  • @hunzaglory8313
    @hunzaglory8313 3 роки тому

    Thank u

  • @lunyteve
    @lunyteve 2 роки тому

    Thanks

  • @muhammadfaris.k9858
    @muhammadfaris.k9858 3 роки тому

    Thank u