Home > Articles > Home & Office Computing > Microsoft Applications

  • Print
  • + Share This
This chapter is from the book

This chapter is from the book

Sorting Data

You will often want to change the ordering of your data. For example, you might want to sort a table of sales reps by their regions, then by YTD sales. You can meet this need by using Excel’s Sort function.

start.jpg

circle_1.jpg Click on any cell within the data table you are going to sort.

circle_2.jpg On the Data tab, click the Sort command.

circle_3.jpg The Sort Dialog box opens. Select the field you want to sort and then specify whether you want to sort Smallest to Largest or Largest to Smallest.

key.jpg

circle_4.jpg Click the Add Level button to add another level of sorting.

circle_5.jpg Select another field to sort by, then specify whether you want to sort Smallest to Largest or Largest to Smallest.

circle_6.jpg After you click the OK button, Excel immediately applies your custom sort.

end.jpg

clipboard.jpg

  • + Share This
  • 🔖 Save To Your Account