How to Lock Slicer Position and Size in Excel PivotTables
Question details
The user wants to prevent Excel slicers from being moved or resized on a worksheet to protect a PivotTable dashboard layout.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Creating an interactive PivotTable dashboard and needing to secure the layout by preventing users from accidentally dragging, moving, or resizing the slicers.
- Observed behavior
- Slicers currently remain interactive but can also be clicked, dragged, or resized, which disrupts the carefully formatted worksheet design.
Ensure your worksheet is unprotected before adjusting slicer properties, as sheet protection restricts object formatting. Confirm that your PivotTable and slicers are fully set up and positioned exactly where you want them before locking.
Prevent Moving and Resizing Using Slicer Properties
The most effective way to lock a slicer in place while retaining its filtering functionality is by adjusting its layout properties.
This built-in setting restricts physical modifications to the slicer object without needing to lock down the entire worksheet.
Right-click the slicer you want to lock and select 'Size and Properties' from the context menu.
In the Format Slicer pane that appears on the right side of the screen, expand the 'Position and Layout' (or 'Properties') section.
Check the box for 'Disable resizing and moving' to lock its physical dimensions and screen position.
Select the option 'Don't move or size with cells' to ensure that adjusting row heights or column widths in the background doesn't distort the slicer.
Repeat these exact settings for each individual slicer you want to protect on your dashboard.

Protect Worksheet to Prevent All Object Modifications
If you are sharing the file and want strict controls over what users can edit, applying worksheet protection is a secure alternative.
Easily Manage PivotTable Slicers in WPS Spreadsheet
WPS Spreadsheet offers a robust, free alternative for managing complex data sets. You can easily insert, customize, and lock PivotTable slicers to create professional, interactive dashboards just like in Excel.
- 1. Open Your Data: Open your Excel file (.xlsx) containing the PivotTable in WPS Spreadsheet.
- 2. Insert Slicer: Click anywhere inside your PivotTable, go to the 'Analyze' tab, and click 'Insert Slicer'.
- 3. Access Properties: Right-click the inserted Slicer and select 'Size and Properties' from the menu.
- 4. Lock Position: Choose 'Don't move or size with cells' and check 'Disable resizing and moving' to completely secure your dashboard layout.

Frequently Asked Questions
Why does my slicer change size when I hide rows or columns?
By default, slicers are set to 'Move and size with cells'. To prevent this behavior when hiding rows or expanding columns, right-click the slicer, select 'Size and Properties', and under the Properties section, select 'Don't move or size with cells'.
Can users still click slicer buttons if the slicer object is locked?
Yes. Disabling resizing and moving only restricts changes to the slicer's physical dimensions and location on the screen. The filter buttons inside the slicer remain fully clickable and functional for filtering your PivotTable.
How do I lock multiple slicers at once?
Hold down the Ctrl key and click each slicer to select multiple. Then, right-click one of them, select 'Size and Properties', and apply the 'Disable resizing and moving' and 'Don't move or size with cells' settings. This applies the lock to all selected slicers simultaneously.
Why is the Size and Properties menu grayed out?
If the Size and Properties option is grayed out, your worksheet is likely currently protected. Go to the Review tab and click 'Unprotect Sheet' before trying to edit the slicer's layout properties.




