donhannam
asked on
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.
Thanks.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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?
It looks like View->New Window doesn't work for '03
Maybe you could open a second copy as Read-Only?
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
You don't need the first line...
ActiveWindow.WindowState = xlNormal
Created by
Worsheet Menu Bar, Window, New Window.
Worsheet Menu Bar, Window, Arrange, Vertical
ActiveWindow.WindowState = xlNormal
Created by
Worsheet Menu Bar, Window, New Window.
Worsheet Menu Bar, Window, Arrange, Vertical
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
Hi donhannam, I think that my contribution about saving the layout was useful, and worthy of consideration as an assist
ASKER
Looking at this for a client who only has 2003 so prefer to find a solution with this.