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

"Natanya Steyn" <Natanya wrote in message
...
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

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.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Natanya Steyn" wrote:

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

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

What you want is WindowNew Window

WindowArrangeVertical 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
wrote:

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