Excel Slicer Range: What It Filters and How to Change It

How-to basics · Updated November 21, 2026

An Excel slicer does not have a separate worksheet-cell range that you can assign to it: it filters a field in an Excel table or PivotTable. If you mean the data range the slicer can filter, change or expand the table or PivotTable source; if you mean the slicer’s on-screen size, resize the slicer object itself.

What an Excel slicer filters

A slicer is a visual set of buttons for filtering data. Each button represents an item in one field, such as a department, product, or month. Clicking an item filters the associated table or PivotTable to show matching records. For example, a slicer for a Department field might have buttons for Sales, Support, and Operations.

The slicer works with the data object behind it, not with an arbitrary selection of cells. A worksheet range such as A1:D100 is not itself a slicer target until you format it as an Excel table or use it as the source for a PivotTable. Nor does a slicer filter unrelated cells just because they are nearby on the worksheet. It changes which rows or PivotTable results are displayed in the connected object.

This distinction matters because people use “slicer range” to mean several different things: the data records the slicer can reach, the values shown as slicer buttons, or the physical width and height of the slicer. Each is controlled differently.

Choose between a table slicer and a PivotTable slicer

Use a table slicer when you want to filter a normal, row-based list directly. Select a cell in the table, then choose Table Design > Insert Slicer and select one or more column names. The slicer filters the table rows; it does not create a summary or change the table’s underlying values.

Use a PivotTable slicer when you want to filter a summarized report. Select a cell in the PivotTable and choose PivotTable Analyze > Insert Slicer. The available fields come from the PivotTable’s source data or data model. A PivotTable can summarize the records while the slicer lets a reader interactively select which categories to include.

For example, a sales table might contain Date, Region, Product, and Revenue columns. A table slicer for Region filters the visible sales rows. A PivotTable built from the same records could summarize Revenue by Product, and a Region slicer could filter those summary results. The same field name does not automatically mean that two separate objects share a slicer; connections depend on the underlying PivotTable setup.

Create a slicer from an ordinary data range

If your records are currently just cells, turn them into a table before creating a table slicer. Include one header row with a distinct name for each column, and avoid merged cells or blank header names. Then:

  1. Select a cell inside the data and press Ctrl+T on Windows. Confirm the proposed range and check My table has headers if the first row contains field names.
  2. With a cell in the new table selected, open Table Design > Insert Slicer.
  3. Select the field or fields you want to filter by, then choose OK.
  4. Move the slicer as needed and click a button to filter the table. Use the clear-filter icon on the slicer to remove its selection.

On Mac, Excel also supports tables and slicers in current Microsoft 365 desktop versions, although ribbon placement and shortcut behavior can differ. In Excel for the web, available slicer creation and editing controls can depend on the feature set currently available to your account; use desktop Excel if a needed command is missing.

Expand the data range behind a table slicer

For a table slicer, the table’s boundaries determine which records are included. Adding rows to the table adds records the slicer can filter. Typing in the row directly beneath a table commonly expands it, but a paste or import placed outside the table may leave the table unchanged. Check the table boundary rather than assuming that every nearby row has been included.

To check or adjust the boundary, select a table cell and choose Table Design > Resize Table. In the dialog, enter or select the full range, including the header row, and confirm. For example, if the table should cover columns A through D and rows 1 through 250, the range must include A1:D250. The slicer’s field values will reflect the records in the table after the change.

If you add a new column and want a slicer for it, make sure the column is part of the table and has a header. Then select the table and use Table Design > Insert Slicer to add a slicer for that field. A slicer cannot filter a field that is not part of its connected table.

When a slicer does not show a newly added category, first confirm that the row is actually inside the table and that the category is spelled consistently. For a table, the slicer uses the field’s available values; it does not repair inconsistent entries such as North, NORTH, and North with a trailing space.

Change the source range for a PivotTable slicer

A PivotTable slicer filters its connected PivotTable, so expanding the PivotTable’s source is a separate task from editing the slicer. If the PivotTable uses a fixed worksheet range, select a cell in it and choose PivotTable Analyze > Change Data Source. Set the new source to include the added records, confirm, and refresh the PivotTable. The slicer can then filter values available in the refreshed source.

For a PivotTable based on an Excel table, new rows added inside the table are generally included when you refresh the PivotTable. This is one reason tables are often more convenient than fixed cell ranges for growing data. Refresh using PivotTable Analyze > Refresh, or refresh the workbook’s connections as appropriate for the data source.

Changing the PivotTable source can affect its layout and available fields, so check the report after making the change. A PivotTable connected to an external source, the Data Model, or a query may use a different source-management process; the worksheet-range command may not be the right way to extend it. In those cases, update the underlying query or model and refresh.

Connect one slicer to more than one report

A slicer can control multiple PivotTables when those reports are compatible, commonly because they share the same PivotTable cache or data model. Select the slicer and open the Slicer tab, then choose Report Connections (the command may be labeled PivotTable Connections in some Excel interfaces). Select the PivotTables the slicer should control.

If a report is not listed, it may not share a compatible source or cache with the slicer’s PivotTable. Having identical-looking source columns is not always enough. Rebuilding PivotTables from the same table or arranging the reports around a shared data model may be needed; do not assume that copying a PivotTable will make every independently created report connect automatically.

Table slicers and PivotTable slicers are not interchangeable connection controls. A slicer attached to a normal Excel table filters that table. It does not automatically filter separate PivotTables or other tables on the sheet. Plan the data and report structure around the objects you want one control to affect.

Change the slicer’s size and button layout

The slicer’s visual dimensions are independent of the source data range. Select the slicer and drag its sizing handles to change its width or height, or use the size controls on the Slicer tab. To show buttons in multiple columns, adjust the slicer’s Columns setting on that tab. This changes the arrangement of the buttons, not which records the slicer can filter.

To select several items, use the slicer’s multi-select control if it is displayed, or hold Ctrl while clicking items on Windows. On Mac, the corresponding modifier is generally Command, though the exact interaction can vary by Excel version. The clear-filter icon removes the current filter selection. Selecting multiple categories means the connected object shows records matching any of the selected items within that field.

For a long list of categories, a taller slicer, multiple button columns, or a more selective field may be easier to use. A slicer with hundreds of distinct values can become cumbersome; filtering on a broader field or using a PivotTable filter may be more practical.

Common range and slicer problems

  • New rows do not appear in the results: Check whether the rows are inside the Excel table or PivotTable source. Resize the table or change the PivotTable source, then refresh when required.
  • A new category is missing: Check the source field for spelling differences, blanks, or inconsistent values. Refresh a PivotTable after changing its source data.
  • The slicer filters one report but not another: Check Report Connections and whether the PivotTables use a compatible cache or data model.
  • Old items remain available: For a PivotTable, review its field retention settings and refresh behavior; stored old items can sometimes remain in the PivotTable cache. This is different from expanding the source range.
  • The slicer seems to show too few choices: Another active filter may limit what appears, or the source may not contain the expected values. Clear filters and inspect the source data before changing the slicer’s size.

One common misconception is that making a slicer wider or adding more button columns expands the data it controls. It does not. Visual formatting affects usability; the source table or PivotTable determines the records and fields available to filter.

Frequently Asked Questions

Can I set a slicer to a specific cell range?
No. A slicer attaches to a table or PivotTable and filters one of its fields. To change the records it can affect, resize the table or change the PivotTable’s source range.

How do I add more data to an Excel slicer?
Add the records inside the source table, or expand a fixed PivotTable source with PivotTable Analyze > Change Data Source. Refresh a PivotTable so it incorporates the updated source.

Can one slicer control two PivotTables?
Often, yes, if the PivotTables share a compatible cache or data model. Select the slicer, open Slicer > Report Connections, and select the reports listed. If a PivotTable is absent, its source setup may not be compatible.

Why can’t I insert a slicer?
For a table slicer, select a cell inside an actual Excel table, not an ordinary range. For a PivotTable slicer, select a PivotTable and use PivotTable Analyze > Insert Slicer. A missing command can also indicate a version or interface limitation.

Does clearing a slicer delete data?
No. Clearing a slicer removes its filter selection and displays the records again; it does not delete or edit the source data. Other filters on the table or PivotTable may still limit what is visible.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.