Excel filtering of split panes

S

sam

I have a huge sheet containing product model information. I often want to
view the same data in a split view but want to filter the top pane on one
model, and thee bottom pane filtered on another model. How can I do this?
 
M

M Kan

I don't think you can do this, as split panes is really just looking at the
same sheet, but in two places.

An alternative however, would be to hit ALT+E,M,C (edit, move or copy, copy
sheet) and then use Windows:Arrange to view both sheets side by side or tiled
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I get the horizontal split box back? 5
Un-Synchronous Panes 3
How do I stop Excel from automatically resizing my row height? 0
Excel should allow at least 2 vertical and horizontal splits. 1
Any way to get Freeze Panes to work with Split View? 2
Freeze Panes loss 3
Freezing panes--splitting spreadsheet into quarters 4
Data entry on filtered rows. 4

Top