Excel filtering of split panes

  • Thread starter Thread starter sam
  • Start date Start date
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?
 
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
 
Back
Top