Can I Freeze a Slicer

brent_milne

New Member
Joined
Jul 11, 2013
Messages
22
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.
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

sadath

Board Regular
Joined
Oct 10, 2004
Messages
245
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,918
Messages
5,525,630
Members
409,657
Latest member
19JimRon72

This Week's Hot Topics

Top