Can I Freeze a Slicer

brent_milne

New Member
Joined
Jul 11, 2013
Messages
20
I have a date slicer connected to a pivot table with over 3000 rows so I was wondering if it was possible to freeze it like I can with an excel row? I have the top row of my sheet frozen so I can see the column headers while I scroll but my slicer moves out of view when I scroll. I thought it might be a setting in the Size and Properties but I was unable to find anything. Thanks for any help.
 

sadath

Board Regular
Joined
Oct 10, 2004
Messages
244
Hi
A Slicer cannot float on Excel worksheet, it moves along with the cells.

you can freeze top few rows and place the slicer in it.
 

Forum statistics

Threads
1,085,419
Messages
5,383,552
Members
401,836
Latest member
Bweston07

Some videos you may like

This Week's Hot Topics

Top