Any way to hide Slicer Values in Excel 2010

excel slice excel-2010 powerpivot
DavidStein picture DavidStein · Oct 21, 2010 · Viewed 54.6k times · Source

I know that Excel 2010 Slicers will visually indicate when there is no data associated with a particular slicer selection. For example, they are faded in color for 2010 if you have no values in 2010.

Is there some setting where I can hide them altogether?

If I have sales in 2007, 2009, and 2010; but not 2008 can the slicer list omit 2008 entirely or must it always be shown as greyed out.

I'm not asking for a SQL selection solution, but rather an Excel setting.

Answer

Ginger picture Ginger · Dec 20, 2013

Actually, yes you can! If the item on the slicer is grayed out because there is no data, you can do the following:

Right click anywhere on the slicer and select "Slicer Settings" from the drop down.

On the bottom right select the box that says "Hide Items with no Data".

Click "OK"

Related questions

Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More
IF statement: how to leave cell blank if condition is false ("" does not work)

I would like to write an IF statement, where the cell is left blank if the condition is FALSE. Note that, if the following formula is entered in C1 (for which the condition is false) for example: =IF(A1=1,B1,"") …

Read More
'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

I'm trying to get data from an Excel file on a button click event. My connection string is: string connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\source\\SiteCore65\\Individual-Data.xls;Extended Properties=Excel 8.0;"; When I click on the button, …

Read More