PT Slicers: How to order items manually?

L

lalbatros

Well-known Member
Joined
Sep 5, 2007
Messages
659
Hello,

In a PivotTable, in "classic" format, row or column header items can be ordered manually.
Can Slicers items also be ordered manually?
Or can Slicers items be ordered according to the related field?

Thanks
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
You must log in or register to reply here.

Similar threads

ajjava
  • Question
VBA to output MANUALLY slicer-selected items ONLY, in a specified cell?
2
Replies
15
Views
358
Jeffrey Mahoney
Jeffrey Mahoney
T
  • Question
Slicer disconnects from pivottable when programatically filtering items in pivot fields
Replies
1
Views
291
MarkKBrennan
M
D
  • Question
Inconsistent pivot table format at sorting behavior.
Replies
1
Views
689
denzo36
D
G
  • Solved
Pivot Slicer Rename?
Replies
1
Views
524
Greenbehindthecells
G
E
  • Solved
How to flag non-filtered rows from slicers?
Replies
4
Views
248
espinozr
E

Forum statistics

Threads
1,206,921
Messages
6,075,584
Members
446,147
Latest member
homedecortips

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top