how do i work on both workbook when using split windows

[Guest]

i would like to be able to work in both workbooks while using the split
windows funtion

 

[Stephen]

i would like to be able to work in both workbooks while using the split
windows funtion

Only one window can be active at any moment - after all, there is only one
keyboard and mouse. However, clicking the inactive window (say, in its title
bar) will make it the active one. That way you can work on the two windows
alternately.

Stephen

 

[Guest]

Not sure which version you are using but in 2007, you need to select the view
tab and click arrange all and try vertical.

It is on the window menu bar in previous versions, if I recall properly.

 

[Gord Dibben]

You can't have two workbooks in view using split.

What you want is Window>New Window

Window>Arrange>Vertical or whatever.

Now each workbook can be in its own window.


Gord Dibben MS Excel MVP

On Wed, 17 Oct 2007 03:08:03 -0700, Natanya Steyn <Natanya