Excel in Depth 24 - Formatting Slicers

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Jul 15, 2010.
Slicers are the new visual filter in Excel 2010 pivot tables. Learn how to make them look good.
maxresdefault.jpg


Transcript of the video:
MrExcel podcast is sponsored by "Easy-XL"!
Excel (laughs) Excel In Depth chapter 24 - Formatting Slicers!
Alright, slicers, brand new in Excel 2010, great way to visually filter a Pivot table.
I have a tiny little Pivot table here, but I want to create some filters, so we can do some ad hoc reporting.
Back here under Options I'll do Insert Slicer, and choose what slicers I want, Region, Product, Customer, click OK, and BAM.
They always show up right in the middle of screen, they're always tiled, they're always one column, and they're always ugly blue, hate that!
Alright but hey, a couple clicks here, we can change this, so region, nice, short, three items, let's make it be three columns, make a little bit wider, and then certainly not as tall as it starts out being, so we make that short.
And I'm also a big fan of changing the color of each slicers, that way they look different.
So here under slicers we have the Quick Styles, just choose a different color, doesn't matter.
Product, same thing, three products, nice, short, let's make those be three columns, it actually fits right there in that current width, we need to make a little bit shorter.
And then Customer, now Customer is a big long list of items, that looks really good as a very long vertical slices, let's just change the color, so we come back to Slicer Options, Quick Styles, and choose a different color.
It's just a little bit of work on your part can make the slicers look a lot better, you can arrange them so that way they fit in a better arrangement than the tiled arrangement that we get.
It's ironic, the PowerPivot people actually make the slicers look pretty good when they add them to the Pivot table it's one of the things that PowerPivot does really well.
I wish that people on the Excel team would kind of steal that logic and add it to the regular Excel, so what we didn't have to reformat the slicers every single time.
Hey, I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
 

Forum statistics

Threads
1,213,558
Messages
6,114,296
Members
448,564
Latest member
ED38

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