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

Sorting

You can sort Excel data in ascending or descending order. In an ascending sort, Microsoft Excel sorts numbers first, then alphanumeric data. Ascending will sort alphabetically A through Z or numerically smallest to largest. Sorting descending will do just the opposite; it will sort alphabetically Z through A and numerically largest to smallest. Blank cells are always placed last, whether sorting in ascending or descending order.

Sorting with the Toolbar Buttons

Excel provides two buttons on the Standard toolbar to perform a simple sort, which is data sorted by a single column. If your data is in an inclusive arrangement, you can use the toolbar buttons to quickly sort by a specified column. One button, the AZ button, sorts the data in ascending order, and the other button, the ZA button, sorts in descending order.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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