Pivot Table Issues

How to Lock Slicer Position and Size in Excel PivotTables

Maira MehtabMaira Mehtab Nov 2, 2026 870 views

Question details

The user wants to prevent Excel slicers from being moved or resized on a worksheet to protect a PivotTable dashboard layout.

How to Lock Slicer Selections and Position in an Excel PivotTable
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.
Before you start

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.

Solution 1Recommended

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.

1
Access Size and Properties

Right-click the slicer you want to lock and select 'Size and Properties' from the context menu.

2
Locate Position Settings

In the Format Slicer pane that appears on the right side of the screen, expand the 'Position and Layout' (or 'Properties') section.

3
Disable Resizing

Check the box for 'Disable resizing and moving' to lock its physical dimensions and screen position.

4
Unlink from Cell Layout

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.

5
Apply to Other Slicers

Repeat these exact settings for each individual slicer you want to protect on your dashboard.

Prevent Moving and Resizing Using Slicer Properties
Dashboard Protection: This method ensures your dashboard layout remains intact even when underlying cell dimensions change, while users can still click the slicer buttons to filter data.
Advanced PivotTables in WPS Office

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. 1. Open Your Data: Open your Excel file (.xlsx) containing the PivotTable in WPS Spreadsheet.
  2. 2. Insert Slicer: Click anywhere inside your PivotTable, go to the 'Analyze' tab, and click 'Insert Slicer'.
  3. 3. Access Properties: Right-click the inserted Slicer and select 'Size and Properties' from the menu.
  4. 4. Lock Position: Choose 'Don't move or size with cells' and check 'Disable resizing and moving' to completely secure your dashboard layout.
Fully compatible with Microsoft Excel (.xlsx) PivotTable and slicer features.Intuitive 'Size and Properties' pane for precise object locking.Free, lightweight suite that handles large datasets and dashboards smoothly.Familiar ribbon interface requiring no learning curve.
microsoft office alternative - wps office

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.