Excel Tip of the Day
Automatically sort PivotTable data
When you initially create a PivotTable, the data is sorted according to the data that appear as row or column headings. However, when you refresh the PivotTable any new entries that may be added are placed at the end of the column or row lists by default. To manually re-sort the items, select the appropriate column field name and then click the Sort Ascending button. If your data is highly volatile, you can ensure that items are always sorted when the data is refreshed. To do so, double-click on the appropriate field name. Then, click the Advanced button when the PivotTable field dialog box opens. Next, select the Ascending option button in the AutoSort Options section. Finally, click OK on all of the open dialog boxes.
(Content provided by Element K Journals)
(Note: Your browser is set to refuse cookies. As a result, you may frequently see previously-viewed tips)
Print
CloseCopyright © 2001 - 2025 MJ Technologies, LLC. All rights reserved.