How to Set and Stylize a Pivot Table Slicer

Fact-checked by Layla Saman
Updated on: March 3, 2023

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.

tx6QM5E3ok9JisVQ7ack8V1OHVu5aoGlT7JSnqQhlsPNNue6fKIEIzoJna89DDtBEp9KblWn1dEOyXoczbg3EwCRt t2saSfb

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.
eePwz9K5DsyoR d935enc74igJUIOa6U 77LrZ6YPnjoglFkuQQ9acgy1vTygeepOkoZYNng BZSJ hSjSijv7Fpv9YRN9ZJ6FRqrQOzxLEFtCD8g USZwCqfVv85YWNeyO9JT54za67mpo21wpK2yNo07KCds Xcg5gitpj4G qhalkDXM8of27JqpJGg
  1. Then in the “Slicer Element” list, choose the item you want to personalize.
  2. Click on the “Format” button.
  3. 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.
n34905mcUvFyYstSxoQtn38Z4vA8Vdkp0Bu1Sqkp86gNboXw7L2N27JC4ULct ycd54ZhNIGQ 6mPlA6Pj8lW0FRSQN I
tar5zyFr6sdQw PHpXZ0Zh m2c5ZOvkXNnmbI3xwFzFbzwlz1NLx 1Wtu0eWdc8k3MrAnE6H 7S4GKPTkOQhMH8xk92CRiyYx5t38L7YgyWNUXEVsZBAg2i4oYOROHWjROJaJQAG86xTCVjWoxuZgk9AfzbR2LuK5X cQB0cagDyKeYtoVm 4g VWucBew
  1. When finished, click “OK” on the “Format Slicer Element” window.
  2. Double-check the information you set appears in the “Element Formatting” blank.
c4JMxT0M48aWBOdfpetzVZxY9lpdsuibR3AnYSrPjCG13K7I9oppxD2 XDdKQ5dNIRco4uyEQcBhhrTA JYzzKNFE5t7eCndgbOtKVm2zTSVrVidEZ6cMHlHXKx5l6

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

  1. 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.

AN1NdaXGIQTWgmIe4AKwnm6DvPMu4pYZkvIwQshh YTDlpR5IXkfXornar6nEE 67amD9cbt1vXL99Zp5nzxRlJGxiopRjifOxW6fkuU2 OOGs9r9plHt6 t2Mq1R7mkxfKS6u2dRBlZDDSqf35KntGsQwNwdCwlTtGqs2e2e2KIheS ccO7fyOcsN qNg
b8Ao5r9suCfwgAs9OzPbF80mZI0bZMLnNuxbrUO0u SCz2H6S 1goUigJgoU y6WiepD0hlpgL GwW3QyRKplsVnBRwerKkowgtMlf1Gl6veRiwFc gz6NCHFdGGQ5NLeA4qpgageqnT29VmIVI aELfEiq tUA9KM63jCURbvcaTvwV8A9mk2H0EBXzA

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.
RimvNRWZTnCO2w7txNy9MZ GNRJ678VDjUgGR7WiOf ZxgM9cMLrl15llxDUzYEgF2IRpxWxKGFAk93MbqpAb980GoKHnfq6kZ
  • The second is by going to the “Slicer” tab, looking up the “Size” group tool, and typing your desired value.
1Yvw1m fy3AR N4izzbrrM9YLQ9ILgDXXkRvF08cApr69GvcGzdNCh5J6KA0E1xheCaXZS47ik5wLhjL LP FrTyRBzWnSqXZ8Jnm 1y0xLnyDF5DVhu fi1SQPegJ xuvkqaXvmnsFEkoJ iPNP

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!

Lorena M. Rodas leverages her experience across film, writing, and production to make complex tech concepts accessible through storytelling. With a background spanning sci-fi, AI, and emerging tech, Lorena translates her depth of knowledge into engaging, educational content. She is an expert at decoding high-level topics to reach broad audiences.
Access 2,701+ video lessons. Instantly.
Start Learning Now →
crossmenu linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram