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

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
    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
    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

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

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.