How to Set and Stylize a Pivot Table Slicer

Numbers are not the only thing that matters when presenting an inform in Microsoft Excel, especially when working with Pivot tables and Slicers, which have to be neat and well-sorted to show those values you want to analyze. So, maybe filtering and using the slicers are the most important thing, but how you sort and order a data set and present it to a client can give you more credibility. 

Hence, in this article, you will solve some questions about the settings and style related to slicers.

Are you ready to start? Let’s begin!

How to change the Slicer color?

Once you click on a Slicer, you will see the “Slicer” tab and find the “Slicer Styles” group tools. Notice that you can pick any style according to the offered colors according to the "Light" and "Dark" variables.

t

How to personalize the Slicer Style?

Although those options are outstanding, you can also personalize your slicer by clicking on the “New Slicer Style” command at the end of the menu and doing the following:

1. You can name the style you’re about to create in the first blank of the pop-up window.

2. Then in the “Slicer Element” list, choose the item you want to personalize.
3. Click on the “Format” button.
4. In the “Format Slicer Element,” you will see 3 tabs. Each has its own settings, but don’t worry, you can set the three of them, and you will see all changes in the slicer.

5. When finished, click “OK” on the “Format Slicer Element” window.
6. Double-check the information you set appears in the “Element Formatting” blank.

Note: Every time you choose an element from the list, you can click on “Format” to personalize each item if you want to.

7. And finally, Click “OK” on the “New Slicer Style” window.

How to access the Slicer settings?

In the “slicer” tab, go to the first group tools at the very left of the pane and click on the “Slicer Setting” command. This will bring up a dialog box.

Notice then that you can rename the Slicer and sort the order of the slicer buttons. You just need to read the options, select what fits you and click “Ok” to confirm.

How to add columns to a slicer?

Scrolling down is out of the table when you have many items in your slicer. Try a column view instead by following these steps:

1. Click on the Slicer and go to the “Slicer” tab.
2. Go to the “Buttons” group tools at the pane's right.
3. Increase the number of columns as many as you rather.

How to resize a Slicer?

You can adjust the size of your Slicer in two ways: 

• The first option is clicking on the slicer and grabbing any border with your cursor on the fly.

• The second is by going to the “Slicer” tab, looking up the “Size” group tool, and typing your desired value.

As you can see, these two options can be handy, but the second one might be more accurate if you want all your Slicers to be identical between them.

How to align your slicers?

You can also align the slicers if you want to be neater in your worksheet, you can also align the slicers. To do that, you can have these 3 options:

• The manual way: 
  • Hover over the slicer until you see the four-directional arrow. 
  • Click on it and drag it to the new location.
• Moving several slicers at once: 
  • Hold the Ctrl key (the Shift key for MAC) while selecting all the slicers you want to move. 
  • Hover until seeing the four-directional arrow.
  • Drag and drop where you want.
• All slicers aligned up: 
  • Select them all by holding the Ctrl key. 
  • Once you have them go to the “Slicer” tab.
  • Look up the “Arrange group tool.

• Choose the “Align” button.
• Pick the option you consider best for you.

Alright, at this point, you’ve acquired a significant acknowledgment related to Slicer's styles and settings so far. So remember to put them into practice and personalize your worksheet to impress your client and give a more professional look to your Pivot Tables. 

Finally, don’t let anything stop you, not even some questions or concerns about slicers or other topics. 

Do you want to learn more? Then, check out our Excel course in Skillademia! Good luck!