How to Resize a Slicer in Excel (With Quick Steps)

Get FREE Advanced Excel Exercises with Solutions!

Slicer imparts buttons that you can press to filter Excel tables or pivot tables. If you don’t like the visual properties of the slicer, you can change the size, style, and position of the buttons. Though Excel slicers are great, the contextual tool for resizing a slicer in Excel is a bit limited. In this article, you will learn an effective way to resize a slicer in Excel.


How to Insert a Slicer in Excel

Before proceeding to our main discussion, we need to know what is literally a slicer. A slicer is an interactive control tool. It can make your work easy by filtering data in a table or pivot table. The slicer feature was first incorporated in Excel 2010. At that time they are only used for filtering pivot tables. From Excel 2013, now it is also available for filtering Excel tables.

The slicer contains a particular field. The following figure shows a table with a slicer with the heading Month. If we click on January, it will filter only sales data for January.

How to Insert a Slicer in Excel

To add one or more slicers in your Excel spreadsheet,

  • select any cell of your table or pivot table and then go to Insert >> Filter >> Slicer.

How to Insert a Slicer in Excel

The Insert Slicers dialog box will pop up including a list of all fields in your pivot table. Put a checkmark next to one or more fields, and finally click OK.

How to Insert a Slicer in Excel

Read More: How to Insert Slicer in Excel


Steps to Resize a Slicer in Excel

To create your own custom Slicer style, just follow the steps below.

📌 Step 1: Reveal the Slicer Tab

Select the slicer to reveal the Slicer tool in the ribbon.

Steps to Resize a Slicer in Excel


📌 Step 2: Choose a Suitable Style

Now go to Slicer >> Quick Styles. Then choose a style to save your time rather than doing it manually. Right-click on the style you like, and click on Duplicate

Steps to Resize a Slicer in Excel

Read More: How to Change Slicer Color in Excel


📌 Step 3: Give a Name to Style

It will open a Modify Slicer Style dialog box. Give a name of your style (in this example, it is named ‘Handy’). After that, select Whole Slicer of the Slicer Element list, and finally, click on Format.

Steps to Resize a Slicer in Excel


📌 Step 4: Modify Font Section to Resize Slicer

A Format Slicer Element window will pop up. Now, under the Font section, select the font size you like, and also other things you wish to modify. In this tutorial, I used font size 10 which will allow me to keep the slicer button smaller.

Steps to Resize a Slicer in Excel


📌 Step 5: Modify Format Section

Now, go to the Border tab and put the Presets to ‘None’. This can allow you to overlap the slicers slightly as there is no constriction of the borders. Finally, click on OK.

Modifying Format Section

Read More: How to Format Slicer in Excel


📌 Step 6: Final Step to Resize a Slicer

The Modify Slicer Style dialog box is back. You can also select the other slicer element and modify them as you need to do. Finally, make sure a tick mark on Set as default slicer style for this document box, and click on OK.

Final Step

Finally, here is the result.


Download Practice Workbook

You can download the practice workbook that we have used to prepare this article.


Conclusion

In this article, we have learned an effective way to resize a slicer in Excel. I hope this discussion has been useful for you. If you have any questions or any kind of feedback, please don’t hesitate to let us know in the comment box.

Happy reading!


Related Articles


What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Hafizul Islam
Hafizul Islam

Hafizul Islam is an excellent marine engineer who loves working with Excel and diving into VBA programming. For him, programming is like a superhero tool that saves time when dealing with data, files, and the internet. His skills go beyond the basics, including Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning. He got his B.Sc in Naval Architecture & Marine Engineering from BUET, and now he's switched gears, working as a content developer. In this role,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo