Slicers in 2013

B

BobUmlas

Well-known Member
Joined
Mar 14, 2002
Messages
1,181
In Excel 2010 the pivottable field list included "slicers vertical" and "slicers horizontal". Has that been removed in 2013?
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Sort by date Sort by votes
Microsoft did their best to make the user interface worse in 2013, and they did an excellent job of it. :(

Best is to right click the field in the pivot table field list, and select "Insert Slicer". There is also a way to insert them off some toolbar item, but it's uglier.

You will also find adding measures sucks more...
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Solved
horizontal traffic light slicer
Replies
5
Views
379
ajm
A
BrettOlbrys1
  • Question Question
TopN with Multiple Slicers not Working
Replies
0
Views
125
BrettOlbrys1
BrettOlbrys1
A
  • Question Question
date slicer - between
Replies
0
Views
251
ajm
A
M
  • Question Question
How to modify slicers in Excel, Power Query
Replies
4
Views
378
alansidman
alansidman
J
  • Question Question
Using Slicer (or other Tool) to Add/Remove Fields from Rows of Pivot after Powerpivot (No-VBA)
Replies
1
Views
436
Matt Allington
M

Forum statistics

Threads
1,226,730
Messages
6,192,711
Members
453,748
Latest member
akhtarf3

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