Excel Slicer: Keep It Visible While Scrolling a Worksheet

Excel does not have a built-in pin-to-screen command for slicers. The closest worksheet-based workaround is to place the slicer entirely in rows or columns that you freeze with View > Freeze Panes; if that does not suit your layout, use a separate dashboard or window instead.

Why a slicer scrolls out of view

A slicer is a visual filter control for an Excel Table or PivotTable. It is a worksheet object positioned over cells, rather than a toolbar that stays attached to the edge of the Excel window. When you scroll down or across the sheet, the visible area moves, and a slicer positioned in the scrolling area can move out of sight with it.

This distinction matters because Excel offers object-positioning settings that sound as though they might solve the problem. Right-click a slicer and choose Size and Properties, then inspect the options under Properties. Depending on the interface, the pane may offer Move and size with cells, Move but don’t size with cells, and Don’t move or size with cells. These settings govern how the object responds when its underlying cells are resized or moved; they are not a command to keep the slicer fixed at the top of the screen during scrolling.

In other words, changing the object property alone does not create a sticky filter panel. To keep a slicer in view, you need to arrange the worksheet so that the slicer occupies a frozen part of the sheet, or choose a different way to present the controls.

Keep a slicer visible with Freeze Panes

Freeze Panes keeps selected top rows and left columns visible while the rest of the worksheet scrolls. If the slicer sits wholly inside that frozen region, it can remain available as you move through the data. This is a practical workaround, not a special slicer setting, so check the result in the workbook and layout you intend to use.

Make room for the slicer. Put it in a top area of the worksheet, or in a left-hand area if you mainly scroll horizontally. Avoid placing it across the boundary between frozen and scrolling cells.
Choose the freeze boundary. Click the cell immediately below the rows you want to keep visible and immediately to the right of any columns you want to keep visible. For example, to freeze rows 1 through 5 and no columns, select A6.
Apply the freeze. On the ribbon, choose View > Freeze Panes > Freeze Panes. To freeze only the first row or first column, use the corresponding commands in that menu instead.
Test both directions. Scroll down and, if relevant, sideways. Confirm that the entire slicer remains visible, that it is not cut off at a pane boundary, and that selecting its buttons still filters the intended report.

The cell you select determines which rows above it and columns to its left are frozen. For instance, selecting D6 before choosing Freeze Panes freezes rows 1 through 5 and columns A through C. That may be useful when a slicer sits in a left-side panel, but it can also leave a large part of the sheet permanently taking up screen space. Plan the frozen area before applying it.

To remove the arrangement, choose View > Freeze Panes > Unfreeze Panes. If the slicer does not stay in place as expected, check that it is fully inside the frozen area, adjust its size or position, and test again. A slicer that straddles the freeze line can behave awkwardly or be partly obscured.

Design the frozen area before adding controls

A useful layout gives the slicer enough room without freezing so many rows that little space remains for the report. For a sales report, for example, you could reserve rows 1 through 4 for a title, a short instruction, and a compact Region slicer, then freeze those rows. The monthly sales table can begin below the frozen area. Scrolling through the records leaves the filters and report context visible.

Consider how people will use the slicer, not just where it fits on the screen. A slicer with many items may need substantial height, while a slicer with several columns may need extra width. Use the slicer’s buttons to keep the control readable, and avoid making the frozen section so large that it dominates a laptop display. If the slicer is only needed occasionally, a separate filter sheet may be less intrusive.

Leave a clear visual distinction between controls and data. A label such as Region or Product helps explain what a slicer changes, especially when several controls are grouped together. If the worksheet contains multiple PivotTables, verify which ones respond to the slicer before sharing the file; a slicer may be connected to more than one compatible report, but it does not automatically control every table on the sheet.

What slicer position settings actually do

Excel’s object properties are still useful, just for a different purpose. If you add or resize worksheet rows and columns, the selected positioning option determines whether the slicer moves with those cells, changes size with them, or keeps its dimensions and cell-relative position. That can help preserve a carefully designed report when the grid changes.

For example, if a slicer should stay the same size when a nearby row is made taller, Don’t move or size with cells may prevent that row change from resizing or shifting it. It does not mean the slicer is permanently attached to the Excel window. Scrolling the worksheet is a separate issue. Think of Freeze Panes as controlling which part of the sheet remains in view, and the object property as controlling how the slicer relates to changes in the worksheet grid.

There is no universal best object setting. If the slicer is aligned carefully with a report grid, moving with cells may be desirable when rows or columns are inserted. If the slicer is a free-standing dashboard control, keeping its size independent of cell changes may be preferable. Choose based on how the sheet will be edited, then test after changing row heights, column widths, and the freeze boundary.

Common problems and how to fix them

The slicer still disappears. It may be outside the frozen rows or columns, or may cross the boundary. Move the whole slicer into the frozen region, adjust the selected cell and freeze panes again, then retest.
The frozen area takes too much space. Reduce the number of frozen rows or columns, shrink or reorganize the slicer, or move controls to a dedicated dashboard sheet. Freeze only what readers need to refer to while scrolling.
The slicer is visible but filters the wrong report, or none at all. Confirm that it is connected to the intended Table or PivotTable. For PivotTables, select the slicer and look for the report connections command on the slicer ribbon; available connections depend on compatible PivotTable data sources.
The slicer buttons are crowded. Select the slicer and adjust its button layout and dimensions from the slicer formatting controls. A tall single-column slicer may be easier to use than several narrow columns when item names are long.
The worksheet is hard to navigate after freezing. Use Unfreeze Panes and recreate the boundary from a better-selected cell. Freeze Panes is applied to the active worksheet view, so review each sheet that needs its own arrangement.

Also check whether the user is scrolling the worksheet or moving between workbook windows, sheets, or panes. Freeze Panes affects the visible area of a worksheet; it does not guarantee that a slicer will remain visible if the reader switches to another sheet or opens the workbook in a different layout.

Alternatives when frozen panes are not enough

A dedicated dashboard sheet is often the cleanest option when the data table is long or the frozen area would be too large. Put the slicers and summary charts on the dashboard, and keep detailed records on a separate sheet. Users can return to the dashboard to change filters. This is simple to maintain and avoids squeezing controls into a scrolling data view, though it does not leave the slicer visible while reading the detail sheet.

Another option is to open a second view of the same workbook. In Excel for Microsoft 365 on Windows, use View > New Window, then arrange the workbook windows with the controls in one view and the data in the other. These are separate views of the same workbook, not independent copies of its contents. This can work well on a large monitor, but takes extra screen space and may be less convenient on a small display. On Mac, the available window arrangement commands and labels can differ by Excel version.

You can also place the slicer near the top of the data sheet and ask readers to return to it when they need a new filter. That does not keep it visible, but it avoids complicated layouts. Table header filters are another alternative for basic column-by-column filtering, though they are not slicers: they do not provide the same button-style interface, and the table headers themselves may scroll out of view unless their rows are frozen.

Excel for Mac and Excel for the web

The steps above are written for Excel for Microsoft 365 on Windows. Excel for Mac also supports worksheet freezing and slicers, but ribbon labels or the placement of object-property controls can vary with the version. Look under the View tab for Freeze Panes, and confirm the result by scrolling in the actual workbook rather than assuming a Windows layout will behave identically.

Excel for the web has a more limited set of features and controls than the desktop application, and the available slicer editing options can depend on the workbook and current release. If you cannot find a needed object setting or cannot arrange the desired layout in the browser, open the workbook in the desktop app. A layout that depends on frozen panes should still be checked in the environment where readers will use it.

Frequently Asked Questions

Can I pin an Excel slicer to the top of the screen?
Not with a dedicated sticky or pin-to-window command. Place it in frozen rows or columns as a workaround, or use a separate dashboard or workbook window.

Does Don’t move or size with cells keep a slicer visible when I scroll?
No. That property affects how the slicer responds to changes in cell size or position. It does not pin the slicer to the Excel window while the worksheet scrolls.

Will Freeze Panes keep a slicer visible?
It can if the slicer is entirely within the frozen area. Position it before applying Freeze Panes, avoid crossing the boundary, and test vertical and horizontal scrolling in the workbook.

Can I freeze only the rows above a slicer?
Yes. Select a cell in column A immediately below the rows to keep visible, then choose View > Freeze Panes > Freeze Panes. For example, selecting A6 freezes rows 1 through 5 without freezing columns.

Why does my slicer move when I resize rows or columns?
Its Size and Properties settings determine how it relates to worksheet cells. Right-click the slicer, open Size and Properties, and choose the positioning behavior that fits how you expect the grid to change. That setting is separate from scrolling.

Can a slicer filter more than one PivotTable?
Yes, when the PivotTables are compatible with the slicer’s data source. Use the slicer report-connections controls to select the reports it should affect, then test the results.

Choosing the right approach

For a compact report where readers need to change filters while inspecting rows, first try placing the slicer completely inside a small frozen top or left area. If that compromises the data view, use a dashboard sheet or a second workbook window instead. The key point is that Excel does not provide a true screen-fixed slicer: frozen panes preserve part of the worksheet, while slicer positioning options govern its relationship to cells. Choosing the right layout—and testing it with real scrolling—keeps the control accessible without confusing those two behaviors.

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.