Sort Data in Excel

Edited by Djinu, VisiHow, Eng

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

If you have problems with any of the steps in this article, please ask a question for more help, or post in the comments section below.

Comments

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

Article Info

Categories : Microsoft Suites

Recent edits by: 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