Slicers are a great tool in Excel for filtering.

If you leave this checked, you won't be able to use the slicer(s).īelow is the Format Slicer task pane (note that Locked has been de-selected): In the task pane, click the arrow beside Properties to expand it.Check or select Disable resizing and moving.In the Format Slicer task pane, click the arrow beside Position and Layout to expand it.Select Size and Properties in the menu.If you are changing multiple slicers, Ctrl-click each slicer and right-click one of the selected slicers. To lock the position of one or more slicers in the Format Slicer task pane: Recommended article: 10 Excel Data Entry Tricks and Shortcuts Every User Should Knowĭo you want to learn more about Excel? Check out our virtual classroom or live classroom Excel courses > Locking the position of one or more slicers using the Format Slicer task pane You'll need to select the slicer or slicers and Disable resizing and moving in the task pane (and choose other options based on your preferences). You can lock the position of a slicer in an Excel worksheet using a options in the Format Slicer task pane. Slicers are a great tool in Excel to filter tables or pivot tables.

Lock the Position of a Slicer in an Excel Worksheet So It Can't Be Movedīy Avantix Learning Team | Updated November 4, 2022Īpplies to: Microsoft ® Excel ® 2013, 2016, 2019, 2021 and 365 (Windows)

How to use slicers in excel 2016