Hi,

Slightly different shortcut keys but...

1. Choose View, New Window
2. Choose View, Arrange All
3. In one window activeate the Chart tab in the other the Worksheet tab

To switch between these windows you can use Alt+Tab, but you can also use
Ctrl+Tab, Ctrl+F6, or to move backwards Shift+Ctrl+Tab or Shift+Ctrl+F6

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Tim S" wrote:

How can I have an Excel 2007 file with 2 sheets, Data and Chart, so that each
sheet opens in a separate window? It USED to work like that, with the older
version I had. I want to be able to switch between the windows with alt-tab.

Any ideas?

Thanks,

Tim