Lock a Slicer in Excel: Keep It in Place and Usable

How-to basics · Updated November 21, 2026

To let people use an Excel slicer on a protected worksheet, right-click the slicer, choose Size and Properties, open Properties, and clear Locked; then use Review > Protect Sheet. For a PivotTable slicer, allow Use PivotTable reports if Excel requires it. The important catch: Excel does not provide a simple, separate permission that lets someone click an unlocked slicer but guarantees they cannot move or resize it.

What “lock a slicer” can mean

People usually mean one of three things when they ask how to lock a slicer in Excel: keep its position fixed, prevent other people from changing its selections, or let people filter with it while protecting the worksheet. These are different goals, and Excel’s object protection does not treat them as independent controls.

A slicer is an interactive object connected to an Excel table or PivotTable. Its Locked property determines whether the object can be changed when the worksheet is protected. It is not the same as a setting that freezes the current filter choices. Nor is it the same as controlling whether someone can edit the data behind the report.

  • Keep the slicer in place: worksheet protection may restrict changes to objects, but an unlocked slicer that remains interactive may also be movable. Test the behavior you need.
  • Stop users changing its filter: lock the slicer and protect the sheet, accepting that users may no longer be able to operate it.
  • Allow filtering on a protected sheet: unlock the slicer before protecting the sheet, and allow the relevant PivotTable interaction when applicable.

Decide which outcome matters most before changing settings. A slicer that is both fully usable and immovable is not a guaranteed result of one checkbox.

Keep a slicer from shifting with worksheet cells

If the problem is that a slicer shifts or changes size when rows or columns are adjusted, change how it relates to worksheet cells. This property can help preserve a dashboard layout when cells are resized; it does not prevent a person from dragging the slicer to another location.

  1. Right-click the slicer and choose Size and Properties.
  2. In the Format Slicer pane, open Size & Properties, then expand Properties.
  3. Select Don’t move or size with cells.

Other options, such as moving the slicer with cells while keeping its size, control its relationship to worksheet layout changes. They do not act as user permissions. If a dashboard is frequently edited, check the result after inserting, deleting, or resizing rows and columns around the slicer.

Allow filtering on a protected worksheet

In Excel for Microsoft 365 on Windows, use these steps when the worksheet needs protection but users still need to click the slicer. Save a copy first if the workbook is important, and test the setup with the same kinds of actions your intended users will perform.

  1. Right-click the slicer and choose Size and Properties.
  2. In the Format Slicer pane, open Size & Properties > Properties and clear Locked.
  3. Select Review > Protect Sheet.
  4. Choose a password if appropriate, and select the worksheet actions you want to permit.
  5. If the slicer controls a PivotTable, allow Use PivotTable reports in the protection options if needed.
  6. Confirm protection, then test the slicer and check whether users can make unwanted layout changes.

Sheet protection is meant to prevent accidental changes, not to provide strong security for confidential information. A password-protected worksheet should not be treated as a secure barrier to the workbook’s contents. Protect the file and sensitive data using appropriate access controls, and avoid distributing data that recipients should not see.

Table slicers and PivotTable slicers

Excel can create slicers for both formatted tables and PivotTables, but their connections and protection behavior are not identical. A table slicer filters the rows of its table. A PivotTable slicer filters the PivotTable, and it may also be connected to other PivotTables that share a compatible source or PivotTable cache.

For a PivotTable, Use PivotTable reports is the relevant worksheet-protection permission to check when interaction is blocked. Allowing it can permit PivotTable actions beyond clicking a slicer, so grant it only when those actions are acceptable. The slicer’s Report Connections setting determines which compatible PivotTables it controls; it is not a protection setting.

A table slicer does not use the PivotTable report permission in the same way. If it fails on a protected sheet, first check that the slicer is unlocked and that the sheet’s protection settings permit the required interaction. Do not assume that enabling Use AutoFilter alone will make every slicer work: that option concerns worksheet filtering controls and is not a universal substitute for configuring the slicer and sheet protection.

What protection can and cannot control

Excel worksheet protection offers a set of broad permissions, not a detailed role system for every slicer action. Depending on the settings and object state, allowing interaction may also expose ways to select or alter the slicer’s layout. The exact result is worth checking in the actual workbook, especially if it contains multiple PivotTables, protected ranges, or other drawing objects.

There is also a difference between protecting the slicer and protecting the information it filters. A user who can access the workbook may be able to see data through other sheets, copied reports, PivotTable details, or a separate source file, depending on how the workbook is built. Hiding a worksheet is not a substitute for access control, and sheet protection does not encrypt the workbook’s data.

If people must filter a report but must not change its layout, consider whether a dedicated dashboard sheet, carefully limited worksheet permissions, or a published report is a better fit. For strict control over what users can do, a shared workbook alone may not provide the granular permissions required; use an access-controlled reporting solution appropriate to the data.

Common problems and fixes

  • The slicer is visible but does nothing: check that the slicer is connected to the intended table or PivotTable, clear its Locked property, and review the sheet-protection permissions. For a PivotTable, test with Use PivotTable reports allowed.
  • Users can filter but the slicer moves: that can happen when the object is unlocked so it can be used. Excel’s basic worksheet protection may not offer the exact filter-only, position-locked permission you want. Test the protected sheet rather than assuming that Locked means “filterable but not movable.”
  • The slicer filters only one report: right-click it and check Report Connections (sometimes shown as PivotTable Connections). Connect it to the compatible PivotTables that should respond.
  • Protection settings are unavailable or confusing: confirm that you are editing the workbook in desktop Excel and that the sheet is unprotected while changing slicer properties. If a workbook is shared or managed by an organization, its configuration may also limit what you can change.
  • The layout changes after resizing cells: use Don’t move or size with cells in the slicer’s Properties settings. Remember, this addresses cell-size changes, not a user deliberately dragging the slicer.

On Excel for Mac, slicer formatting and protection features are available in desktop Excel, but ribbon placement and pane labels can differ by release. Excel for the web can support interacting with slicers, but object-property and protection controls may be more limited than in desktop Excel. Use the Windows desktop steps above as the reference and verify the available controls in the version where the workbook will be maintained.

Frequently Asked Questions

Can I lock a slicer but still let people use it?
Not reliably through the slicer’s Locked checkbox alone. To allow filtering on a protected sheet, the usual setup is to clear Locked before protecting the sheet. That can leave the object open to layout changes, so test whether the resulting permissions meet your needs.

How do I stop someone changing a slicer selection?
Protect the worksheet and keep the slicer locked if preventing interaction is more important than allowing filtering. If users need to filter, Excel does not offer a simple slicer setting that freezes selected items while still letting them use other slicer controls.

Does “Don’t move or size with cells” lock the slicer?
No. It controls how the slicer responds when worksheet cells are moved or resized. It does not prevent a user from dragging or resizing the slicer.

Why can’t I click a slicer after protecting the sheet?
The slicer may still be locked, or the sheet may not permit the required PivotTable interaction. Clear the slicer’s Locked property before protection and, for PivotTable slicers, check whether Use PivotTable reports needs to be enabled.

Can I password-protect a slicer by itself?
No. Slicer protection is managed through worksheet protection and the object’s properties; there is no separate slicer password. Worksheet protection should be treated as a way to reduce accidental edits, not as security for sensitive data.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.