Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Excel 2010 Slicer Issue

Posted on 2016-08-04
3
Medium Priority
?
73 Views
Last Modified: 2016-08-04
I have the attached workbook and have no data associated with one of the slicer options, however, it is still showing as a choice.

How can I make the "North" option go away? I do not want users to click on it.

Thank you-
example_2.xlsx
0
Comment
Question by:kwarden13
3 Comments
 
LVL 27

Accepted Solution

by:
Glenn Ray earned 2000 total points
ID: 41742992
You can't remove items from the slicer.  By default Excel slightly shades out items with no data (see the Slicer Settings), but you can't remove them entirely.

-Glenn
0
 
LVL 7

Expert Comment

by:tomfarrar
ID: 41743080
Go to Slicer Settings in Menu and see attached.
Slicer.jpg
0
 

Author Comment

by:kwarden13
ID: 41743114
Thanks tomfarrar, but unfortunately I only have Excel 2010.

Glenn Ray - I did what you recommended in the slicer settings and it worked.

Thank you both!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
In this post, I will showcase the steps for how to create groups in Office 365. Office 365 groups allow for ease of flexibility and collaboration between staff members.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question