What a slicer does and why you might want one

A slicer is a button-based filter tool in Excel that lets you narrow down the rows in a table or pivot table without typing or using dropdown menus. Instead of clicking into a column header and unchecking items one by one, you click buttons labeled with the values you want to see. If you have a table of sales data with columns for Region, Product, and Date, a slicer gives you a separate panel with clickable buttons for each region — click "Northeast" and "West" and the table when ready shows only those regions.

Slicers work best when you are filtering by categories that repeat across many rows: regions, product types, customer names, yes-or-no fields, or date ranges. They are less useful for filtering by unique values (like individual order numbers) or for very large lists of categories (a slicer with 500 buttons is harder to use than a dropdown). If you find yourself clicking the same filter combinations over and over, a slicer saves time. If you are building a spreadsheet someone else will use, a slicer makes the tool more obvious — people see the buttons and understand what they can do without explanation.

Key Takeaways

  • Slicers work only on tables and pivot tables, not on plain cell ranges, so you must format your data as a table first.
  • You insert a slicer from the Table Design or PivotTable Analyze tab, then choose which columns to add as slicer buttons.
  • Clicking a button filters the table to show only rows matching that value; holding Ctrl and clicking multiple buttons shows all selected values at once.
  • You can resize, move, and style slicers to match your spreadsheet layout, and delete them without affecting the underlying data.

Format your data as a table before adding a slicer

Slicers only work on tables and pivot tables. If your data is in plain cells with headers in the first row, you must convert it to a table first. Click any cell in your data range, then go to the Home tab and click Format as Table. Choose a table style from the gallery. Excel will automatically detect your data range and ask whether your table has headers — make sure that box is checked if row 1 contains column names.

Once the table is formatted, you will see filter dropdown arrows appear in the header row. The table now has a name (usually "Table1", "Table2", etc.) that Excel uses to track it. You can rename it later if you want, but the default name works fine for adding a slicer.

Insert a slicer from the Table Design tab

Click any cell in your table, then go to the Table Design tab (it appears in the ribbon when a table is selected). In the Tools group, click Insert Slicer. A dialog box opens showing all the columns in your table with checkboxes next to each name. Check the boxes for the columns you want to filter by — for example, if you have Region, Product, and Date columns and you only want to filter by Region and Product, check those two boxes and leave Date unchecked.

Click OK. Excel creates a separate slicer panel for each column you selected. Each panel shows all the unique values in that column as clickable buttons. The panels appear as floating boxes on top of your spreadsheet; you can move them by dragging the title bar and resize them by dragging the edges.

Click buttons to filter your table

Click any button in a slicer panel to filter the table to show only rows where that column matches that value. The button turns blue and the table updates when ready. Click a different button to switch the filter — only that value now shows. Click the button again to turn it off and show all rows again.

To filter by multiple values in the same column, hold Ctrl and click each button you want. All clicked buttons turn blue and the table shows rows matching any of those values. For example, if you have a Region slicer with buttons for Northeast, Southeast, Midwest, and West, you can Ctrl+click Northeast and West to see only those two regions. If you have multiple slicers (one for Region and one for Product, for instance), the filters work together — the table shows only rows matching all active filters across all slicers.

Move, resize, and style your slicers

Slicers are floating objects, so you can place them anywhere on your spreadsheet. Drag the title bar to move a slicer. Drag the edges or corners to resize it — making it wider shows more buttons in a row, and making it taller shows more buttons in a column without scrolling. Arrange multiple slicers side by side or stack them vertically depending on your layout.

To change the appearance, right-click a slicer and choose Slicer Settings. You can change the caption (the text in the title bar), the number of columns the buttons display in, and whether to show a search box at the top (useful if a slicer has many buttons). You can also explore a different color scheme by right-clicking and choosing a style from the Slicer Styles gallery.

Clear filters and remove slicers

To turn off all filters in a slicer and show all rows again, click the funnel icon with an X in the top right corner of the slicer panel. To remove a slicer entirely, right-click it and choose Remove. Removing a slicer does not change your data or the table — it only deletes the filter panel. You can add it back later by going to Table Design and clicking Insert Slicer again.

If you want to clear all filters across all slicers at once, go to the Table Design tab and click Clear Filter in the Sort & Filter group. This resets every slicer to show all values.

Slicers in pivot tables

Pivot tables also support slicers, and the process is nearly identical. Click the pivot table, go to the PivotTable Analyze tab, and click Insert Slicer. Choose the fields you want to filter by — these are usually the row labels, column labels, or report filters you set up when you created the pivot table. The slicer works the same way: click buttons to filter, Ctrl+click for multiple values, and the pivot table updates when ready.

Pivot table slicers are especially useful because pivot tables can become hard to read once you add many fields. A slicer makes it obvious which values are currently filtered and lets you switch between them without hunting through nested row or column headers.

Frequently Asked Questions

Can I use a slicer on data that is not formatted as a table?

No. Slicers only work on tables and pivot tables. If your data is in plain cells, you must first format it as a table using Home > Format as Table. Once it is a table, you can add slicers.

What happens if I delete a slicer?

Deleting a slicer removes only the filter panel, not your data or table. The table remains unchanged. You can add the slicer back at any time by going to Table Design and clicking Insert Slicer again.

Can I filter by multiple values in different slicers at the same time?

Yes. If you have a Region slicer and a Product slicer, you can click buttons in both. The table shows only rows matching all active filters — for example, rows where Region is Northeast AND Product is Widget.

How do I search for a value in a slicer with many buttons?

Right-click the slicer, choose Slicer Settings, and check the box for "Display Options" > "Show search box". A search field appears at the top of the slicer where you can type to find buttons quickly.

Do slicers work in older versions of Excel?

Slicers were introduced in Excel 2010. If you use Excel 2007 or earlier, you will not have the Insert Slicer option. You can use the filter dropdown arrows in the table header instead, though they are less visual than slicers.