Excel Lock Slicer in Place? Position and Protect It

How-to basics · Updated November 19, 2026

Yes. In Excel for Microsoft 365 on Windows, select the slicer, open Size and Properties, and under Properties choose Don’t move or size with cells. That keeps it from shifting or changing size when worksheet cells are resized; to stop people dragging it, protect the sheet as well. A slicer is still a worksheet object, though, so this setting alone does not pin it to the screen while you scroll.

What “lock a slicer in place” can mean

People usually mean one of three different things when they ask how to lock a slicer. The right fix depends on which problem they are seeing:

  • Keep its position and dimensions steady: Set the slicer not to move or resize with worksheet cells.
  • Stop users from moving or resizing it: Protect the worksheet so locked objects cannot be edited.
  • Keep it visible while scrolling: Place it in a frozen part of the worksheet, or redesign the report. A slicer does not become a screen-fixed control just because its position is locked.

These controls are separate. For example, a slicer can be set not to move with cells but remain draggable on an unprotected sheet. Conversely, protecting a sheet can restrict changes without making a slicer stay visible as you scroll through a long report.

Set the slicer not to move or resize with cells

This is the main setting for keeping the slicer in the same worksheet position when you change row heights, column widths, or the layout around it. It does not lock the slicer against deliberate movement by someone editing the sheet.

  1. Click the slicer’s outer border so the whole object is selected, rather than clicking one of its filter buttons.
  2. Right-click the border and choose Size and Properties. If that choice is not shown, use the slicer’s contextual ribbon tab to open the formatting pane, then select Size & Properties.
  3. In the pane, expand Properties.
  4. Select Don’t move or size with cells.

Excel also offers Move but don’t size with cells and Move and size with cells. The first lets the slicer follow its associated cell area when rows or columns shift, while retaining its dimensions. The second makes it move and resize with that area. Choose the behavior that suits the layout, then save the workbook and check the result by changing a nearby row height or column width.

The exact pane layout can vary slightly with ribbon and window size. On Excel for Mac, select the slicer and use its formatting controls to find the properties options; some labels or panel arrangements differ from Windows. Excel for the web has fewer object-formatting controls, so use the desktop app if you cannot find the positioning setting.

Prevent users from dragging or resizing the slicer

To restrict editing, use worksheet protection. First, select the slicer and check its object setting: open Size and Properties, expand Properties, and make sure Locked is selected. Then go to Review > Protect Sheet. Choose the actions users should be allowed to perform, and set a password if appropriate. A password can help deter changes, but it is not a substitute for keeping a separate, secure copy of important data.

Worksheet protection is not the same as encrypting a workbook, and it can affect more than the slicer. In particular, object-editing permissions and filtering permissions are not identical. If people need to click the slicer while the sheet is protected, try the precise protection settings available for that workbook and test them with a non-owner account or a saved copy. PivotTable-based slicers may require the Use PivotTable & PivotChart reports permission, when available. A slicer connected to an Excel table can behave differently under protection, so do not assume that every protected-sheet setup will preserve filtering.

A practical way to avoid a surprise is to test three actions after protecting the sheet: click a slicer button, try to drag the slicer border, and try to resize it. If filtering is blocked, revisit the protection options or consider leaving the report sheet unprotected while protecting the underlying data and workbook structure where suitable.

Keep a slicer visible while scrolling

The positioning property does not pin a slicer to the Excel window. It remains an object on the worksheet: when you scroll away from its location, it normally scrolls out of view too. This is a common misunderstanding because “Don’t move or size with cells” sounds like a screen-position lock, but it controls how the object relates to cells, not how it relates to the window.

If the slicer needs to remain on screen while users browse a report, you can arrange the sheet so the control sits in a frozen area. For example, put the slicer in the top rows and freeze those rows. Select the first cell below the rows you want to keep visible, then choose View > Freeze Panes > Freeze Panes. To freeze only the top row, use View > Freeze Panes > Freeze Top Row. If the slicer is in a left-hand column and users scroll horizontally, freeze the columns to its left as well.

Plan the layout before freezing panes: Excel freezes rows above and columns to the left of the active cell, and the frozen region takes space from the report. A slicer that is too tall or too wide can make the visible report area cramped. Try the arrangement at the screen size people will use, and choose View > Freeze Panes > Unfreeze Panes if you need to revise it. Mac users can find the equivalent Freeze Panes controls on the View tab, though ribbon details may differ.

Choose the right setting for your report

Consider how the workbook will be used before combining positioning and protection. A personal analysis sheet may need only the cell-position setting. A shared dashboard may need protection against accidental layout changes. A report intended for frequent filtering may prioritize slicer access over strict restrictions.

  • For a changing worksheet layout: Use Don’t move or size with cells if nearby row or column changes should not disturb the slicer.
  • For a structured form or report: Use sheet protection to discourage accidental object edits, then confirm users can still use the slicer.
  • For a dashboard users scroll through: Put controls in a frozen region if they must stay visible, and keep the frozen area compact.
  • For a workbook maintained by several editors: Explain which areas are intended to be changed, and keep an unprotected backup or master copy.

For instance, suppose a monthly sales report has a slicer above a PivotTable and new detail rows are sometimes inserted. The no-move/no-size option can prevent row-height or column-width adjustments from changing the slicer’s placement. If sales managers must filter the report but should not redesign it, test worksheet protection with the slicer before distributing the file. If the report extends down many screens and the slicer must stay available, placing it in frozen top rows addresses visibility more directly than object locking.

How slicers work and what the setting does not change

A slicer is a visual filter for an Excel table or PivotTable. You create one from the table or PivotTable tools, then click buttons representing field values to filter the connected data. For a table, select it and use Table Design > Insert Slicer. For a PivotTable, select it and use PivotTable Analyze > Insert Slicer. A slicer may also be connected to more than one compatible PivotTable through its report connections.

The cell-position property does not change which data the slicer filters, its selected items, or its connections. It also does not stop users from clicking filter buttons when the sheet is unprotected. It only describes the slicer object’s relationship to worksheet cells during layout changes. Sheet protection adds a separate set of restrictions, which is why a slicer can behave differently after protection is applied.

Likewise, locking a slicer does not lock the data source or prevent someone from changing the workbook in every possible way. If data integrity matters, protect the relevant sheets and workbook features appropriately, control access to the file, and retain a backup. Treat worksheet protection as a guard against ordinary editing, not as a security boundary for confidential information.

Common problems and fixes

  • The slicer still moves when I drag it. That is expected if the worksheet is unprotected. The cell-position option controls how it responds to cell layout changes; use sheet protection to restrict object editing.
  • It disappears when I scroll. The setting does not pin it to the window. Move it into rows or columns that you freeze, or use another report layout.
  • I can’t select the slicer’s border. Click a blank edge rather than a slicer button. If another object overlaps it, use the Selection Pane from the Home tab’s Find & Select controls to choose the slicer.
  • Users can’t filter after I protect the sheet. Review the protection permissions and test the slicer type. For a PivotTable, check whether Use PivotTable & PivotChart reports is available and enabled. If users still cannot interact with it, adjust the design or protection approach rather than assuming the position property is responsible.
  • The slicer shifts after rows or columns change. Reopen its properties and confirm the intended option is selected. Also check whether the worksheet was rearranged in a way that makes a fixed object overlap nearby cells.

Frequently Asked Questions

Can I lock a slicer without protecting the whole worksheet?
Not reliably against someone moving it. The Don’t move or size with cells setting controls its behavior when cells change, but it does not prevent a user from dragging it on an unprotected sheet. Worksheet protection is the usual way to restrict object editing.

Does “Don’t move or size with cells” keep a slicer on screen?
No. It prevents the slicer from moving or resizing in response to cell layout changes. The object still scrolls with the worksheet. Use Freeze Panes to keep a slicer in a frozen section visible while navigating other parts of the sheet.

Can people still use a slicer on a protected sheet?
Sometimes, depending on the slicer’s source and the protection permissions. PivotTable-based slicers may use the PivotTable reports permission. Test the actual workbook, because protection can block interaction and table slicers may not behave the same way.

Will locking a slicer stop it from filtering data?
The position setting does not change filtering. Worksheet protection may limit interaction, however, so verify that users can click slicer buttons after you protect the sheet.

Can I use this setting in Excel for the web?
Excel for the web supports many workbook editing tasks, but object-formatting options can be limited compared with desktop Excel. If the slicer’s properties are unavailable in the browser, open the workbook in Excel for Microsoft 365 on Windows or Mac and set them there.

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.