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

Referencing this Article

If you need to reference this article in your work, you can copy-paste the following depending on your required format:

APA (American Psychological Association)
Sort Data in Excel. (2016). In VisiHow. Retrieved Apr 26, 2017, from http://visihow.com/Sort_Data_in_Excel

MLA (Modern Language Association) "Sort Data in Excel." VisiHow, visihow.com/Sort_Data_in_Excel Accessed 26 Apr 2017.

Chicago / Turabian VisiHow.com. "Sort Data in Excel." Accessed Apr 26, 2017. http://visihow.com/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.

Ask the author

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. 125,000 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: 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