• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Sorting a Data List

While Excel makes it easy to enter your business data and to manage it after you’ve saved it in a worksheet, it’s rare that your data will answer every question you want to ask it. For example, you might want to discover which of your products has the highest total sales, which product has the next highest, and so on. You can find out that information by sorting your data.


When you sort data in a worksheet, you rearrange the worksheet rows based on the contents of cells in a particular column. Sorting a worksheet to find your highest-selling products in terms of units sold, for instance, might show the results displayed in the following graphic.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint