Excel filtering of split panes
 

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?

Excel filtering of split panes
 

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
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"sam" wrote:

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?