T TestExcel New Member Sep 23, 2015 #1 Hello, I am creating a slicer for IECAT and test, but i see a blank option in all my slicers and i want to remove that. Can some one guide me please. Thanks Narayan
Hello, I am creating a slicer for IECAT and test, but i see a blank option in all my slicers and i want to remove that. Can some one guide me please. Thanks Narayan
N NARAYANK991 Excel Ninja Sep 23, 2015 #2 Hi , Have you tried out what is suggested here : http://stackoverflow.com/questions/3988703/any-way-to-hide-slicer-values-in-excel-2010 Narayan
Hi , Have you tried out what is suggested here : http://stackoverflow.com/questions/3988703/any-way-to-hide-slicer-values-in-excel-2010 Narayan
T TestExcel New Member Sep 23, 2015 #3 Hello, This doesn't work in 2010, but it works in 2013 and i am using 2010 !! Thanks
C candybg Member Sep 23, 2015 #4 I think that most likely you need to adjust your data range, so blank rows and columns are not part of the data.
I think that most likely you need to adjust your data range, so blank rows and columns are not part of the data.