Sort Data in Excel

Edited by Djinu, VisiHow, Eng, Anonymous

You're watching VisiHow. In this video, we're going to show how to sort data in Excel.

Sort Data In Excel.mp4-canvas38 067997.jpg

Ad

Steps

  1. 1
    In this video, we have domain names in column "B" and the length of the domain names in column "D".
    Sort Data In Excel.mp4-canvas11 436.jpg
    Advertisement
    Was this step helpful? Yes | No | I need help

  2. 2
    We want to find shorter domain names.
    Sorted from the shortest to the longest. To do this, we click "Data".
    Sort Data In Excel.mp4-canvas18 780174.jpg
    Advertisement
    Was this step helpful? Yes | No | I need help

  3. 3
    Then we click "Sort".
    Sort Data In Excel.mp4-canvas21 301171.jpg
    Was this step helpful? Yes | No | I need help

  4. 4
    We click "Sort by".
    Sort Data In Excel.mp4-canvas23 2974.jpg
    Was this step helpful? Yes | No | I need help

  5. 5
    We click "Length".
    Sort Data In Excel.mp4-canvas24 812008.jpg
    Was this step helpful? Yes | No | I need help

  6. 6
    We should click either "Smallest to Largest" or "Largest to Smallest".
    Let's click "Smallest to Largest".
    Sort Data In Excel.mp4-canvas27 718398.jpg
    Was this step helpful? Yes | No | I need help

  7. 7
    Then, we click on "OK".
    Excel will sort the data based on the length of the potential domain names.
    Sort Data In Excel.mp4-canvas31 519398.jpg
    Was this step helpful? Yes | No | I need help

    Advertisement

If you have any questions or comments, please leave them in the space below. Thanks for watching VisiHow!

Video: Sort Data in Excel

Comments

VisiHow welcomes all comments. If you do not want to be anonymous, register or log in. It is free.




Djinu
Featured Author
365 Articles Started
403 Article Edits
21,200 Points
Djinu is a featured author with VisiHow. Djinu has achieved the level of "Lieutenant" with 21,200 points. Djinu has started 365 articles (including this one) and has also made 403 article edits. 97,500 people have read Djinu's article contributions.
Djinu's Message Board
Djinu: Hi, my name is Djinu.
Djinu: Can I help you with your problem about "Sort Data in Excel"?
 

Article Info

Categories : Microsoft Suites

Recent edits by: Eng, VisiHow, Djinu

Share this Article:

Thanks to all authors for creating a page that has been read 157 times.

Do you have a question not answered in this article?
Click here to ask one of the writers of this article
x

Thank Our Volunteer Authors.

Would you like to give back to the community by fixing a spelling mistake? Yes | No