Microsoft Office Tutorials and References
In Depth Information
Sorting a Range, Region, or Table
Sorting a Range, Region, or Table
You can sort a range, region, or table by using values from one or more columns. That’s
true regardless of the data type. In a membership roster, for example, you can sort the list
in alphabetical order using the Last Name column, or by date, oldest to youngest, using the
Birthday column, or by number if you’re using the Donations column to track progress in a
fundraising drive.
To sort the current region, click a single cell in the column you want to sort by and then
click Sort & Filter in the Editing group on the Home tab. The choices at the top of the list
vary slightly depending on the data type. For text, Sort A To Z and Sort Z To A are available,
as shown here. For dates, the choice is Sort Oldest To Newest and Sort Newest To Oldest.
For numbers, the choices are Sort Smallest To Largest and Sort Largest To Smallest.
If you prefer to sort the current column with a single click, use the commands in the Sort &
Filter group on the Data tab, as shown here. This group includes a pair of buttons that allow
you to sort in ascending or descending order, just as you can with the Sort & Filter menu.
(The Sort button opens the Custom Sort dialog box, which we discuss shortly.)
If the active cell is in a table, you get yet another set of sort and filter menus to work with.
Click the arrow to the right of a column heading to see a menu like the one shown next.
The sort options are identical to those on the Sort & Filter menu; the real difference is the
greatly expanded filter options, which we’ll get to later in this section.
Search JabSto ::




Custom Search