how do i work on both workbook when using split windows

N

Natanya Steyn

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

Stephen

Natanya Steyn said:
i would like to be able to work in both workbooks while using the split
windows funtion
Click to expand...

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
 
M

Martin Fishlock

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.
 
G

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
 
Top