View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
M Kan M Kan is offline
external usenet poster
 
Posts: 169
Default 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?