Slicer Tool

[socals]

Hello All,

I have used the slicer tool a few times with no issues but I can't figure this one out. I have a table with information and my slicer tools are on the right side of it. The filters in my slicers contain 9-15 items and I have the majority of them showing. The problem is that when I click some filters the rows come up so high that they collapse the slicer tools. I read to go into the settings and check 'don't move or size with cells' but that has not helped the issue.

Is there a way I can lock these without this happening? I would prefer to keep them on the right side as opposed to moving them on top since they do contain a lot of rows.

Thank you in advance for your time.

 

[socals]

So I figured it out....

I had the table set from the 1st row to the last. I did it because I will be adding more information later and didn't want to have to change anything later. I selected 100 rows off from the bottom and now I don't have the issue.

I hope this helps someone else.