xlSlicerSort

Specifies whether items displayed in the slicer are sorted.

xlSlicerSortAscendingSlicer items are sorted in ascending order by item captions (2)
xlSlicerSortDataSourceOrderSlicer items are displayed in the order provided by the data source (1)
xlSlicerSortDescendingSlicer items are sorted in descending order by item captions (3)

xlSlicerSortAscending
Slicer items are sorted in ascending order by item captions (2)
xlSlicerSortDataSourceOrder
Slicer items are displayed in the order provided by the data source (1)
xlSlicerSortDescending
Slicer items are sorted in descending order by item captions (3)

REMARKS
* Added in 2010.

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top