Excel table greying out and adjust slicer size

keinz

New Member
Joined
Dec 2, 2015
Messages
44
Hi everyone,

Looking to get some assistance on this problem I cannot seem to solve...

I cleaned up a data dump into a Table so that I can apply a slicer to filter the data.

I am not using the Pivot table - as it cannot be adjusted to how I want the data to be viewed.



Anyways... for this table I have 2 slicers that I want to filter two types of data

1. Date
2. Department

The sheet has around 3000 rows and the slicer is roughly about 20 row tall and 3 rows wide.
Whenever I filter the data with the slicer and there are less rows than 20, it will resize the slicer.

In the event there are only 1 row of data - the slicer will then become unusable unless I manually resize it.
Whats weird is when the filters are applied, the bottom of the sheet is all greyed out - which is what I think is causing the slicer to resize?

I did format the slicer:
1. Disable resizing and moving (checked)
2. Don't move or size with cells (checked)
3. Locked (checked)


Yet it still happens...
I also tried protecting the worksheet, no change.

So my main question would be... how do I prevent the slicer from resizing?


Thank you in advance
 
Thanks for letting me know.
Just curious, did you resize the table to include blank rows or something ? If the table didn't cover all your data rows then the actual filtering shouldn't have worked either.
 
Upvote 0

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Thanks for letting me know.
Just curious, did you resize the table to include blank rows or something ? If the table didn't cover all your data rows then the actual filtering shouldn't have worked either.
so - previously the table was supposed to be from A:G

i changed it to A1:G9999

and that did it... weird
 
Upvote 0

Forum statistics

Threads
1,213,491
Messages
6,113,963
Members
448,536
Latest member
CantExcel123

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top