Forum Discussion
Slicers
I am new to using slicers and need heeeeelp. I have a basic table (not a pivot table). Currently have 6 column. It will be a shared file so users will be add rows and it will grow. I know I can filte...
DaleWilson what i believe is happening is that excel just doesn't have any more cell rows 'defined'. You could try to 'add' rows to excel to make sure you always have additional blank rows so the slicer is clipped (you should be able to scroll to a spot outside the table and add some spaces or something or maybe someone else will chime in with a 'better' way). OR you could just move your table down and put the slicer(s) ABOVE the table. Even 1 row and you can adjust the height of row 1 to fit the size of your slicer(s). Then if you 'freeze' the top of the table the slicer will also be 'frozen' in view.
