Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split panes / freeze and zoom | Excel Discussion (Misc queries) | |||
how do i split an excel spreadsheet into 6 panes? | Excel Worksheet Functions | |||
Disable Unfreeze Panes and Remove Split, how? | Excel Discussion (Misc queries) | |||
Freeze and split panes in Excel 2003 | Excel Worksheet Functions | |||
Excel should allow independent zoom adjustment of split panes | Excel Discussion (Misc queries) |