![]() ![]() Note: You can also quickly sort data in ascending or descending order by clicking A to Z or Z to A. Text entries will be sorted in alphabetical order, numbers will be sorted from smallest to largest (or vice versa), and dates or times will be sorted from oldest to newest (or vice versa). For additional sort options, click Options. On the Data tab, click Sort, and then click the sort order that you want. In the PivotTable, click any field in the column that contains the items that you want to sort. ![]() Sort row or column label data in a PivotTable You can't sort data by a specific format, such as cell or font color, or by conditional formatting indicators, such as icon sets. Unlike sorting data in a range of cells on a worksheet or in an Excel for Mac table, you can't sort case-sensitive text entries. For optimal sort results, you should remove any spaces before you sort the data. For information about changing the locale setting, see the Mac Help system.ĭata such as text entries may have leading spaces that affect the sort results. ![]() Make sure that you have the correct locale setting in Language and Text in System Preferences on your computer. When you sort data in a PivotTable, be aware of the following: To help you locate data that you want to analyze in a PivotTable more easily, you can sort text entries (from A to Z or Z to A), numbers (from smallest to largest or largest to smallest), and dates and times (from oldest to newest or newest to oldest). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |