Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 11th 08, 04:35 PM posted to microsoft.public.excel.worksheet.functions
Jon Jon is offline
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 183
Default Un-Synchronous Panes

When I have split panes within the same worksheet, I want to un-sychronize
the two panes. I can see how to do it with two different worksheets, but
can't find how to do it for two panes of the same worksheet (Excel 2007).
Any suggestions?

  #2   Report Post  
Old November 11th 08, 04:44 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 2,344
Default Un-Synchronous Panes

Hi,

If you use the command, Window, New Window and then Window, Arrange, Tile
the windows will be unsynced by default.

--
Thanks,
Shane Devenshire


"Jon" wrote:

When I have split panes within the same worksheet, I want to un-sychronize
the two panes. I can see how to do it with two different worksheets, but
can't find how to do it for two panes of the same worksheet (Excel 2007).
Any suggestions?

  #3   Report Post  
Old November 11th 08, 04:46 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
Posts: 1,358
Default Un-Synchronous Panes

Well, in xl2003, you can go to menu Window|New Window, and it will open a
second version of the same file (and they are named :1 and :2, etc.
--
** John C **

"Jon" wrote:

When I have split panes within the same worksheet, I want to un-sychronize
the two panes. I can see how to do it with two different worksheets, but
can't find how to do it for two panes of the same worksheet (Excel 2007).
Any suggestions?

  #4   Report Post  
Old November 11th 08, 05:01 PM posted to microsoft.public.excel.worksheet.functions
Jon Jon is offline
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 183
Default Un-Synchronous Panes

Thanks for the suggestion Shane. I tried it and it does work, although
somewhat cumbersome and doesn't revert back after saving (ie have to reset it
up each time). As well, I'd like to do this for only one sheet within the
worksheet and have it stay that way (until I manually change it). Anyway,
I'm a switch over from Quatrro Pro and it was a simple one step command to
"Unsych". Since its available for multiple files, one would assume that
Excel has the capability to do it for within the same worksheet... Do you
know if its possible?

"ShaneDevenshire" wrote:

Hi,

If you use the command, Window, New Window and then Window, Arrange, Tile
the windows will be unsynced by default.

--
Thanks,
Shane Devenshire


"Jon" wrote:

When I have split panes within the same worksheet, I want to un-sychronize
the two panes. I can see how to do it with two different worksheets, but
can't find how to do it for two panes of the same worksheet (Excel 2007).
Any suggestions?



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
How do I NOT get synchronous scrolling in multiple panes in Excel Darlene needs help! Excel Worksheet Functions 2 August 29th 07 09:50 PM
Freeze panes Lauren Giles Excel Discussion (Misc queries) 2 March 5th 07 04:16 PM
More Dividers for Excel Viewing Panes / multiple panes per axis. bIgJeNkS3 Excel Discussion (Misc queries) 1 August 2nd 06 11:51 PM
freeze panes? gregp22 Excel Discussion (Misc queries) 1 April 2nd 06 05:15 AM
freeze panes? gregp22 New Users to Excel 3 April 2nd 06 02:37 AM


All times are GMT +1. The time now is 07:44 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017