Excel Slicers: Keep a Slicer Visible While Scrolling

Excel has no command that pins a slicer to the screen like a floating toolbar, so a slicer normally moves out of view as you scroll its worksheet. The practical built-in workaround is to put the slicer entirely in rows or columns that you freeze; otherwise, use a separate dashboard or window to keep the control accessible.

Why a slicer scrolls with the worksheet

A slicer is a visual filter control for an Excel Table or PivotTable. It is an object placed on a worksheet, not a permanent part of Excel’s ribbon or a control attached to the computer screen. Its position belongs to the worksheet canvas, so scrolling to distant rows or columns can take it out of view along with the cells around it.

This explains a common point of confusion: the slicer’s object properties can determine how it behaves when cells are moved, resized, or hidden, but they do not make it stay fixed in the visible window while you scroll. Excel does not offer a dedicated Keep on Screen or Pin Slicer setting.

Freeze Panes offers a partial solution because it keeps selected worksheet rows or columns visible while the rest of the sheet scrolls. If the slicer is fully inside that frozen area, it can remain on screen as you scroll the unfrozen part. It is not an independent screen-level pin: the frozen area takes up worksheet space, and the slicer must fit within it.

Keep a slicer visible with Freeze Panes

For a slicer above a long report, reserve enough top rows for the control, place the slicer there, and freeze the rows beneath it. For example, if the slicer fits within rows 1 through 5, freeze those rows before scrolling through the report below.

Move the slicer so it sits entirely in the rows you want to keep visible. Make sure its bottom edge is above the first row that should scroll.
Click the first cell below the rows to freeze. For a slicer in rows 1–5, select a cell in row 6, such as A6.
On the ribbon, choose View > Freeze Panes > Freeze Panes.
Scroll down the worksheet. The frozen rows should stay at the top, with the slicer visible in that area.

To keep a slicer visible while scrolling horizontally, place it in columns that will remain fixed and freeze the columns to their right. To freeze both a top region and left-side columns, select the cell immediately below and to the right of the area to preserve, then choose View > Freeze Panes > Freeze Panes. For instance, selecting C6 freezes rows 1–5 and columns A–B.

If the worksheet already has a different freeze arrangement, choose View > Freeze Panes > Unfreeze Panes first, reposition the slicer if needed, and set the freeze point again. The first row and first column commands are shortcuts for those particular cases; they may not be enough if the slicer needs several rows or columns.

Plan the layout before freezing the sheet

Freeze Panes is most useful when the slicer and the frozen area are designed together. A slicer that is taller than the reserved rows may overlap the scrolling area, and one placed partly across the freeze boundary may not behave like a control wholly inside the fixed region. Give the frozen region enough room for the slicer’s full outline, buttons, and any nearby labels.

Think about what else users need to see while they filter. A compact top section might contain a report title, a date-range slicer, and a region slicer, with the column headings immediately below. If the slicers consume too much vertical space, consider placing them side by side, reducing the number of visible buttons, or moving some controls to a dashboard sheet.

On a wide report, freezing columns can preserve row labels while the user scrolls sideways. A slicer in those frozen columns can remain accessible in that direction, but it may use valuable space and reduce the width available for the report. Decide whether keeping the filter visible is more important than showing additional data columns at once.

What slicer object properties do—and do not do

Right-click the slicer and choose Size and Properties, then check the Properties options. Depending on the selected option, the slicer can move or resize with cells, move without resizing, or neither move nor resize when cells change. These settings help keep its layout predictable when you adjust row heights, column widths, or worksheet structure.

They do not pin the slicer to the window. In particular, choosing Don’t move or size with cells does not mean that the slicer stays in the same screen position during scrolling. It means its relationship to cell changes is different; the worksheet view can still scroll away from its location. Use frozen rows or columns when the goal is to retain visibility during scrolling.

Similarly, hiding rows or columns is not a reliable way to create a permanently visible control. Depending on the slicer’s properties, hiding cells can affect the object’s display or position, and it does not create a fixed screen area. Freeze Panes is the relevant worksheet feature for keeping a defined region in view.

Use a dashboard or another window as an alternative

If the report needs nearly the full worksheet for data, a separate dashboard can be a cleaner design. Put the slicer on a dashboard sheet and connect it to PivotTables on the report sheet when they share a compatible PivotTable cache or use the same Data Model. Select the slicer and look for Slicer > Report Connections (the command may be labeled PivotTable Connections in some Excel builds), then select the PivotTables it should control.

That connection option applies to PivotTable slicers, not a slicer created for an ordinary Excel Table. A Table slicer filters its associated table; it cannot be connected through Report Connections to unrelated PivotTables. If the command is unavailable or a PivotTable is missing from the list, check whether the slicer is a PivotTable slicer and whether the PivotTables share the required source or cache.

Another option is to open a second view of the workbook using View > New Window, then arrange the workbook windows with the View ribbon’s window-arrangement command. Keep one view positioned at the slicer and use the other to inspect the report. This uses more screen space, and each window has its own scroll position; the slicer itself still is not pinned. It can be useful when a dashboard is not practical.

Common problems and how to fix them

The slicer disappears when scrolling down: Confirm that its entire area is above the freeze line. If it is below that line, move it into the frozen rows, then freeze the rows beneath it.
The wrong rows stay visible: Unfreeze the current panes and select the cell just below the intended frozen rows before choosing Freeze Panes. Excel freezes rows above and columns to the left of the selected cell.
The slicer overlaps the report headings: Increase the reserved frozen area or move the slicer to a dashboard. Remember that frozen rows remain on screen and reduce the visible height available for scrolling data.
The slicer changes position after a layout edit: Review its Size and Properties settings and decide whether it should move or resize with worksheet cells. Then verify the freeze boundary still sits beyond the slicer.
A slicer on one sheet will not filter a PivotTable on another: Check Report Connections and the PivotTable’s cache or Data Model relationship. A regular Table slicer does not gain PivotTable connections just by being moved to another sheet.
The control is visible but filters the wrong data: Select the slicer and inspect its available connections. A slicer only controls the tables or PivotTables it is associated with; its position on the worksheet does not determine its data connections.

Excel for Mac and Excel for the web

In Excel for Microsoft 365 on Windows, the standard route is View > Freeze Panes. Excel for Mac also provides Freeze Panes from the View tab, though the ribbon layout and contextual slicer commands can differ slightly by release. The underlying approach is the same: place the slicer within the worksheet region that remains frozen.

Excel for the web can display and interact with many workbook slicers, but available editing and layout commands can vary. If you cannot find the needed Freeze Panes or slicer property controls in the browser, open the workbook in the desktop Excel app to set up the layout. Afterward, check the workbook in the version your audience will use, especially if it relies on a carefully sized frozen region.

Frequently Asked Questions

Can I lock an Excel slicer so it stays on screen while I scroll?
No. Excel does not have a dedicated command to pin a slicer to the application window. Freeze the rows or columns containing it, or place it on a dashboard or in a second workbook view.

Does Don’t move or size with cells keep a slicer visible?
No. That option controls how the object responds to cell changes such as resizing or moving cells. It does not stop the worksheet view from scrolling past the slicer.

Can I keep a slicer visible while scrolling both down and across?
Yes, if you place it wholly inside an area that includes frozen rows and frozen columns. Select the cell below and to the right of that area, then use View > Freeze Panes > Freeze Panes. Keep in mind that the frozen area reduces the space available for the report.

Can a slicer on a dashboard filter PivotTables on another sheet?
Often, yes. Use the slicer’s Report Connections or PivotTable Connections command and select compatible PivotTables. They generally need to share a PivotTable cache or use an appropriate common Data Model. A slicer for a regular Excel Table does not use this PivotTable connection feature.

Why is Freeze Panes grayed out?
Check whether the worksheet is protected, whether you are editing a cell, or whether an existing pane arrangement needs to be cleared. Try leaving cell-edit mode and using View > Freeze Panes > Unfreeze Panes before setting the layout again. If the command remains unavailable, check the workbook’s protection and the Excel version you are using.

Will the slicer stay fixed if I print the worksheet?
Freeze Panes affects the on-screen view, not the slicer’s position on printed pages. Set print areas and page layout separately, and use print preview to confirm where the slicer and report appear on paper.

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.