• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1203
  • Last Modified:

Split view in Excel 2003 vertical - scroll either side independently

I have a spreadsheet with a vertical split screen in the middle - I have lists on either side I wish to compare with a different number of items - I would like to scroll down either side independently leaving the other side fixed - at present when I scroll down one side the other side moves down to. I am sure I have done this is the past but carn't work out how.

Thanks.
0
donhannam
Asked:
donhannam
  • 2
  • 2
  • 2
  • +3
3 Solutions
 
bromy2004Commented:
I'm not sure where i would be, But Excel '07 and '10 have View-->New Window.
This is like having 2 spreadsheets open, but they refer to the same File
0
 
donhannamAuthor Commented:
OK thanks - yes this works for 2007 - sort of works with 2003 but 2007 has feature to turn off syncronous scrolling  which 2003 does not have.

Looking at this for a client who only has 2003 so prefer to find a solution with this.
0
 
bromy2004Commented:
I'm not referring to "View Side by Side"
It looks like View->New Window doesn't work for '03

Maybe you could open a second copy as Read-Only?
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
TomSchreinerCommented:
It works in 2003 if I am understanding you correctly.
 

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 1/7/2010 by TJS
'

'
    ActiveWindow.WindowState = xlNormal
    ActiveWindow.NewWindow
    ActiveWorkbook.Windows.Arrange ArrangeStyle:=xlVertical
End Sub

Open in new window

0
 
TomSchreinerCommented:
You don't need the first line...
ActiveWindow.WindowState = xlNormal

Created by
Worsheet Menu Bar, Window, New Window.
Worsheet Menu Bar, Window,  Arrange, Vertical
0
 
AnilKumarSharmaCommented:
Yes you can do the same in office 2003.
Open your Spreadsheet say xyz.
Go to Window->New Window. Check out that taskbar will show two excel windows.
Two windows are there with name xyz:1 and xyz:2. Click on restore icon for both the excel window and resize them to half-half (or whatever your preference is) side by side manually. (Because compare side by side resize them horizontally instead of vertically).
Select Window->Compare side by side with xyz:n(your first file window name). The value of n is either 1 or 2 depending upon which window your current selection is. If it is on second then n will be 1 and if you are in xyz:1 then n will be 2.
In left window,say xyz:1 (the window which you like to freeze and compare) select the column next to which you like to freez and select Window->Freez Panes.
For synchronous scrolling dont forget to click it in compare side by side toolbar .
Hope it helps.



0
 
EirmanChief Operations ManagerCommented:
Having setup that solution as described by AnilKumarSha... you can save the layout ....

Go to "custom views" in the view menu ... select "new" and give the view a meaningful name like SplitView1 and select ok to save it.
When you next open the file just go to custom views and select SplitView1
0
 
byundtCommented:
Hello donhannam,
In case you missed AnilKumarSharma's point, in Excel 2003 synchronized scrolling is enabled by default--but you can disable it by clicking the Synchronize Scrolling icon. This icon may be found at the left of the Compare Side by Side toolbar that pops up when you choose Window...Compare Side by Side, and looks like one page on top of another with an up/down arrow to its right.

Regards,

Brad
0
 
donhannamAuthor Commented:
Thanks for the help - this works fine and yes byundt i wouldn't have found the little icon to disable scrolling without you pointing it out.
0
 
EirmanChief Operations ManagerCommented:
Hi donhannam, I think that my contribution about saving the layout was useful, and worthy of consideration as an assist
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
  • 2
  • 2
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now