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

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

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.
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,931
Messages
5,508,188
Members
408,669
Latest member
AgsikapAko

This Week's Hot Topics

Top