RedditPP Mascot

RedditPP

r/excel • … • u/funkyb

Is there a way to use Split and Freeze Panes from the View ribbon at the same time?

I've got a table with some slicers as pictured here.

\[slicers and table\](https://imgur.com/3fJvczk)

\[scrolling to the end of the table\](https://imgur.com/BZz0M6R)

I'd like to have the slicers living off to the side and be able to scroll the table without affecting them, so using the split fucntion does me good there. However, I'd also like to prevent the user from scrolling the left /slicer-containing pane over to the table, the right/table-containing pane over to the slicers, or the left/slicer-containing pane down so they can't see the slicers anymore, and Iw ant the table headers visible at all times in the right/table-containing pane.

Great, so freezing panes should do me here. I jsut freeze the left pane right and below the slicers and the left pane at the top coner of the table data. Except as far as I can tell I can't use Freeze Panes and Split from the View/Window ribbon tools at the same time. Am I misssing something here or is that the case? Any other suggestions on haivng a static view of the slicers and a scrollable view of the table on screen at the same time? I tried to find a way to view different sheets at the same time as a way aorudn this but only found a bunch of clumsy uses of multiple windows that won't work for my users, who are very basic excel users.

— 0