Quick way to insert a slicer in Excel

Discover a simple method to add slicers in Excel to your tables. Watch our short video or read our tutorial to save time and increase your spreadsheets knowledge.

Tired of using the good old filters in pivot tables? Do you want to filter out your tables quickly? Try slicers!

Slicers are great to filter data in tables like pivot tables or regular ones. They decrease risks of making mistakes when ticking filter options and save you time. Learn how to add slicers in Excel by checking our tutorial below!

Adding slicers in Excel will become a new habit to finish projects earlier. Also, your colleagues or customers will be happy to select the data they need directly without the need of using regular filters. Ready to learn?

On Excel, click anywhere in your pivot table then go to Insert>Slicer.

Now that the Insert Slicers window is visible, select the filter category you want to use (you will be able to rename it later) and click OK. If you tick several filters, you will have several slicers in your worksheet.

Insert Slicers window from MS Excel.

You just added a slicer to your pivot table!

Click on any option to filter your pivot table easily and quickly. If you want to select multiple options, click first on the Multi-Select icon (in red). And if you don’t want to apply filters anymore on your Excel pivot table, click Clear Filter (in blue).

Slicer with Mutli-Select and Clear Filter icons. Excel.

Creating a slicer for a table in Excel is easy. Click on your table then go to Insert>Slicer.

Select the field you want to use as filter and click OK.

You just added a slicer to your Excel table! Now click one of the filter options, you are ready to work quicker.

Do you want to change the Excel slicer design to match your brand colours or tables? Check how to do it below.

You can find Slicer Settings or change slicers design in the Slicer tab. You can also change the slicer caption by a more appealing name if you wish (top left corner of the Slicer tab).

Change the design of your slicer by selecting a light or dark design; just click the one you want to use. You can also change columns number on the right of the tab, which can offer a better design for your Excel spreadsheet.

If you want to learn more Microsoft Excel tricks, check our blog or join our Certifying Course now!

Advertising
Analytics

Categories

AllAdvertisingFormatsPlatformsKPI'sAd News
What is Programmatic Advertising?

What is Programmatic Advertising?

Understand what programmatic advertising is and how it works to increase your ROI and become a programmatic specialist.

Read More
Programmatic Advertising: What is a DSP?

What are DSPs?

A DSP is a great tool to use but what does DSP stand for in marketing? What are some Demand-Side Platforms examples? Today, we answer your questions!

Read More

Best DSPs for Programmatic Advertising

Ted Jordan shares his list of best DSPs for Programmatic Advertising so you don’t have to lose time searching the internet to find the right Demand-Side Platform for your campaigns.

Read More
Programmatic Advertising: What is a SSP?

Supply-Side Platforms (SSPs) Explained

SSPs basics in advertising: learn what Supply-Side Platforms are used for and who use them. Get familiar with more programmatic advertising technical terms.

Read More

What is O&O Advertising?

Discover one more important jargon term used in Programmatic Advertising: O&O advertising. Get familiar with O&O formats and advantages.

Read More
Programmatic: Pixels in Advertising 101

Advertising pixels: types, pros and best practices

Learn the basics of Programmatic Advertising with Ted Jordan! Today, we explain what a pixel is in advertising with simple words and expertise. Ready to learn?

Read More

Categories

AllFunctionsToolsShortcut Keys

How to change shapes in Excel column charts

Learn how to easily change the columns shape in your Excel charts so your colleagues and customers will remember your impacting graphs.

Read More

How to use the LEFT, RIGHT and MID functions

Learn how to extract text in Excel with the LEFT, RIGHT and MID functions. Plenty of examples to learn from and functions are explained with simple words. If you start...

Read More

Excel IF statement: how to use it for 3 conditions

Learn how to use the Excel IF statement with multiple conditions and combine it with OR and/or AND functions!

Read More
Navigating with Tab, Enter, and Shift Key on Excel.

How to move between cells when arrow keys are not working (Excel)

Learn how to move between Excel cells without using your mouse or arrow keys. Discover more shortcuts and tricks below!

Read More

How to use the IFERROR function (Excel + Google Sheets)

Discover how to use IFERROR in Excel or in Google Sheets in 4 easy steps! No more errors on your documents or dashboards with IFERROR.

Read More
Cope Paste Options on excel with shortcut keys

Copy paste values like a pro! (Excel+Google Sheets)

Copy and paste values (not formulas) using shortcut keys in Excel or Google Sheets! Learn how spreadsheets professionals do it within seconds and become one of them. Save time now...

Read More