Excel Slicer: How to Hide Blank Items

How-to basics · Updated November 21, 2026

Yes, you can hide blank entries from an Excel slicer in some cases: select the slicer, open Slicer > Slicer Settings, and turn on Hide items with no data if that option is available. If the blank represents records that still exist in the source data, hiding items with no data will not remove it; filter out or correct those source blanks instead.

Why blanks appear in an Excel slicer

A slicer is a visual filter for a field in an Excel Table or PivotTable. Its buttons represent values in that field, so a blank button usually means the field contains at least one empty value in the data used by the slicer. In a PivotTable, Excel commonly displays that item as (blank). In a slicer, the blank item may appear as an empty-looking button or as a blank label, depending on the source and how Excel displays it.

Not every blank-looking value is a genuinely empty cell. A cell containing spaces, a formula that returns an empty string, or a label that appears blank because of formatting can behave differently from a truly empty cell. If you cannot explain a slicer item by looking at the visible values, inspect the source column and check for formulas, spaces, and unusual characters.

It also helps to distinguish an empty category from an item with no data in the current filter context. For example, a product category might exist in the source but have no sales in the selected month. That category has no matching records under the current filters. A blank category with actual records, by contrast, is still a real item in the data, even if you would prefer not to show it.

Hide items with no data in slicer settings

For a PivotTable slicer, first select the slicer so Excel displays its contextual Slicer tab. Choose Slicer > Slicer Settings, then look for Hide items with no data and select it. You can also right-click the slicer and choose Slicer Settings. If you do not see that option, the setting may not be available for that slicer or data source; use the source-cleanup or filtering methods below.

This setting is useful when a slicer lists categories that have no matching records after other filters are applied. For instance, choosing a particular year may leave some departments with no transactions. Hiding items with no data can make the slicer shorter and keep attention on the available results. It does not delete records, change the source, or generally mean “remove every blank value.”

Excel also offers related display choices in slicer settings, such as visually indicating items with no data or placing them last. Those choices affect how unavailable items look or where they appear; they are not the same as excluding blank source records. Check the setting’s exact wording rather than assuming that a gray or last-positioned item has been removed.

Exclude a blank category from a PivotTable

If the blank is a real item in the PivotTable field, filter that field or clean the source. To filter within the PivotTable on Windows, open the dropdown for the relevant row or column field, clear the check beside (blank), and select OK. The PivotTable then excludes records with a blank in that field from its displayed results. This is a report filter, not a repair to the underlying cells.

A slicer connected to the PivotTable can still show a blank button if blank records remain available to that slicer. If the goal is simply to keep those records out of the report, the PivotTable field filter may be enough. If the goal is to make the blank button itself disappear, remove or replace the blank values in the source, refresh the PivotTable, and check the slicer settings again. Slicer behavior can depend on the PivotTable cache, connections, and other active filters.

Be cautious when a workbook has several PivotTables connected to the same slicer. Use Slicer > Report Connections (called PivotTable Connections in some versions) to review which reports it controls. A change to a shared source or filter can affect more than one report, and a slicer can only connect to compatible PivotTables that share the relevant cache or data connection.

Remove or replace blanks in the source data

For a lasting cleanup, decide what an empty field means before changing it. If the value is genuinely unknown, a clear label such as Unknown or Not assigned may be more informative than a blank. If the record should not be included in the analysis, correct or remove it according to the workbook’s data rules. Do not fill blanks with a made-up category just to make the slicer look tidy; that can misrepresent the data.

For an Excel Table, inspect the source column and enter the chosen replacement in the appropriate empty cells, or correct the upstream data if the table is refreshed from another source. For a PivotTable, refresh after changing the source: select the PivotTable and choose PivotTable Analyze > Refresh, or use Data > Refresh All when several connections need updating. If an old item remains after the source has changed, check PivotTable options for retained items in the data source and refresh behavior; a stale cache can preserve values that are no longer present.

Keep a copy of the original data or document the cleanup when the workbook is used for reporting. Replacing an empty value with a label changes how the category appears in summaries, while deleting a row changes the records included in the analysis. Those choices are data decisions, not merely slicer formatting.

Excel Table slicers and PivotTable slicers

Excel supports slicers for both Tables and PivotTables, but their sources are different. A Table slicer filters rows in the table itself. A PivotTable slicer filters a PivotTable field and may also control other connected PivotTables. This distinction matters because a Table slicer’s blank button usually reflects a blank value in the table column, whereas a PivotTable slicer can also show items based on its cache or current report context.

For a Table slicer, select it and look for the Slicer tab and Slicer Settings. If the settings do not offer a way to hide the blank item, correct the table’s source values or use the column’s filter dropdown to exclude blanks from the displayed rows. Filtering the table does not erase those source values, so the slicer may still offer the blank category. If it remains, cleaning or replacing the underlying blanks is the more dependable way to remove that category from the slicer’s choices.

In Excel for Microsoft 365 on Windows, the contextual ribbon tab appears when the slicer is selected. On Mac, the relevant slicer commands may be arranged differently, and available settings depend on the Excel release. Excel for the web can handle many workbook interactions, but if a setting is missing, open the workbook in the desktop app and check the slicer’s settings there.

Common problems and practical checks

If a blank button persists after you edit the source, work through these checks before rebuilding the report:

  • Check the entire source column. Look beyond the visible rows and inspect formulas, spaces, and rows hidden by filters.
  • Refresh the report. Use PivotTable Analyze > Refresh or Data > Refresh All, as appropriate.
  • Look for a formula returning an empty string. A cell that looks empty may still contain a formula, and its treatment can differ from a truly empty cell.
  • Review the active filters. A slicer can show an item because it exists in the source even when another filter currently leaves it with no matching records.
  • Check connections and caches. Confirm the slicer is connected to the report you are viewing and that the PivotTable uses the expected source.
  • Decide whether to hide or correct. Hiding a no-data item changes the slicer display; correcting a source blank changes the underlying category.

Another common misunderstanding is that clicking a blank slicer button removes it. Clicking a slicer button filters the report to that item; it does not delete the button or the source records. To clear a slicer selection, use its clear-filter icon, usually shown as a filter with a red mark, or select the slicer and use the clear-filter command on the ribbon. Clearing a selection restores the unfiltered view; it does not change the list of available values.

Which approach should you choose?

Choose the method that matches the reason the item is present. If the blank is a valid record that should remain in the data but should not appear in this report, exclude it with a PivotTable field filter or an appropriate report filter. If you only want to hide categories that have no results under other selections, use Hide items with no data when the setting is available. If the blank is a data-entry error or an unhelpful category, correct it in the source and refresh.

For a quick decision, ask these questions:

  • Does the blank represent real records? Keep the records and use a report filter if they should be excluded only from this view.
  • Is the blank a mistake or missing label? Correct the source or replace it with a truthful category.
  • Does the item have no results only because of another selection? Try the slicer setting for hiding items with no data.
  • Is this an Excel Table rather than a PivotTable? Check the Table slicer options and expect to handle persistent blank values in the source column.

Frequently Asked Questions

Can I hide only the (blank) button without deleting the rows?
Sometimes. If the slicer offers Hide items with no data and the blank has no matching records in the current context, enable it. If blank records still exist and count as data, use a report filter to exclude them or change the source category; the no-data setting alone will not remove a genuine item.

Why does my slicer still show blank after I refresh?
Refresh updates the report from its source, but it cannot remove a blank that still exists in that source. Check for truly empty cells, formulas returning empty strings, spaces, and records outside the visible range. Also confirm that the PivotTable is using the source you edited.

Can I hide blanks in a slicer for an Excel Table?
Check the selected slicer’s Slicer Settings first. If there is no suitable hide option, correct the blanks in the table column or filter them out as appropriate. A table filter can hide rows without removing the underlying blank values, so it may not remove the blank choice from the slicer.

Does hiding blank items delete data?
No. Slicer display settings and PivotTable filters change what the report shows, not the original source records. Editing or deleting source values is a separate action and can change later summaries.

Why is the blank button empty instead of saying (blank)?
Excel may display an empty-looking slicer button for a blank value rather than printing the PivotTable label. Check the source field and test the filter before assuming that the button is a formatting error. A formula or whitespace can also make a value look blank while leaving content in the cell.

Can one slicer hide blanks in several PivotTables?
A slicer can control multiple compatible PivotTables when they share a suitable cache or connection. Review Slicer > Report Connections to see which reports are connected. Hiding an item in the slicer does not clean the source data for any of those reports.

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.