Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
split panes / freeze and zoom Atishoo Excel Discussion (Misc queries) 0 July 9th 08 08:03 PM
how do i split an excel spreadsheet into 6 panes? Baigi Excel Worksheet Functions 4 February 13th 08 06:54 PM
Disable Unfreeze Panes and Remove Split, how? dk_ Excel Discussion (Misc queries) 2 October 4th 06 10:57 PM
Freeze and split panes in Excel 2003 John Excel Worksheet Functions 2 January 31st 06 10:43 PM
Excel should allow independent zoom adjustment of split panes One Excel User Excel Discussion (Misc queries) 5 January 12th 05 12:14 AM


All times are GMT +1. The time now is 05:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"