G Guest Oct 17, 2007 #1 i would like to be able to work in both workbooks while using the split windows funtion
S Stephen Oct 17, 2007 #2 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
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
G Guest Oct 17, 2007 #3 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.
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 Oct 17, 2007 #4 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
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
