How to Sort data in Microsoft Excel

Excel sorts data according to specific sort order rules. We can sort the number data as per ascending order and descending order. And sort the text according to alphabets A to Z and Z to A. We can sort by font color and cell color in Microsoft Excel.

 
 
This option is available in the Data Tab under the Sort & Filter group

img1

 

How to sort data in Excel?

To learn about data sorting in Excel, let’s take an example:-

We have data in range A1:B14. Column A contains Agent’s name, and column B contains Revenue ($).

img2
 
Sort data as per number in ascending and descending order

  • Select the one cell from data.
  • In the Data tab, select Sort, and then Sort Options dialog box will appear.
  • Select Revenue ($) in Sort by Column.

img3
 

  • To sort column values, select Values.

img4
 

  • In order column, select smallest to largest for ascending order and largest to smallest for descending order.

img5
 

  • Data will get sorted as per the number.

Sort data in Ascending Order:-

img7
 

Sort data in Descending Order:-

img7
 
Sort data as per Name (text) in A to Z and Z to A

  • Select the one cell from data
  • In the Data tab, select Sort, Sort Options dialog box will appear.
  • Select Agent’s Name in Sort by Column.

img8
 

  • In Sort on column, select Values.

img9
 

  • In order column, select A to Z and Z to A.

img10
 

Sort by first name to last name:-

img11
 

Sort by last name to first name:-

img12
 
Sort data as per cell color and font color.

  • Select the one cell from data.
  • In the Data tab, select Sort, and Sort Options dialog box will appear.
  • Select Revenue ($) in Sort by Column.

img13
 

  • Select Cell color in Sort on.

img14
 

  • In order column, select cell color on top.

img15
 
img16
 

  • Select font color in Sort on.

img17
 

  • In order column, select font color on top.

img18
 

img19
 
image 48

 

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com

 
 

Users are saying about us...

  1. I want to build a custom list in Excel using years (ex: 2004,2005,2006,2007)etc. for admissions data. After building it I use the autofill feature and only 2004 comes across. I try to import it from the custom list window but nothing happens. Any thoughts?????

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube