Office 2021 for Seniors for Dummies (9781119844594) by Wempen Faithe

Author:Wempen, Faithe [Wempen, Faithe]
Language: eng
Format: epub
ISBN: 9781119844594
Publisher: John Wiley & Sons Inc
Published: 2021-12-15T00:00:00+00:00

Sort a Table

Sorting rearranges the order of the records to meet criteria you specify. For example, you might sort an address list on the person’s last name or city.

If you convert the range to a table, as in the previous section, each column heading has a drop-down arrow button on it. Click that arrow to open a menu. From that menu, you can choose to Sort A to Z or Sort Z to A on that column. See Figure 10-3. When you sort on a column, the arrow changes to display a tiny symbol indicating that you have sorted on that column.

If you don’t want to use the drop-down menu on the column, you can instead click anywhere in the column and use buttons on the Ribbon:

Home  ⇒    Editing  ⇒    Sort & Filter  ⇒    A to Z

Home  ⇒    Editing  ⇒    Sort & Filter  ⇒    Z to A

Data  ⇒    Sort & Filter  ⇒    Sort A to Z

Data  ⇒    Sort & Filter  ⇒    Sort Z to A

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.