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

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
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
313
ajm
A
BrettOlbrys1
  • Question Question
TopN with Multiple Slicers not Working
Replies
0
Views
96
BrettOlbrys1
BrettOlbrys1
A
  • Question Question
date slicer - between
Replies
0
Views
209
ajm
A
M
  • Question Question
How to modify slicers in Excel, Power Query
Replies
4
Views
337
alansidman
A
J
  • Question Question
Using Slicer (or other Tool) to Add/Remove Fields from Rows of Pivot after Powerpivot (No-VBA)
Replies
1
Views
314
Matt Allington
M

Forum statistics

Threads
1,224,009
Messages
6,175,922
Members
452,684
Latest member
RRaively1

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