XlSlicerSort Enumeration

Specifies whether items displayed in the slicer are sorted, and if they are sorted, whether they are sorted in ascending or descending order by item captions.

Version Added: Excel 2010

Name

Value

Description

xlSlicerSortAscending

2

Slicer items are sorted in ascending order by item captions.

xlSlicerSortDataSourceOrder

1

Slicer items are displayed in the order provided by the data source.

xlSlicerSortDescending

3

Slicer items are sorted in descending order by item captions.

Show: