Excel file as two SEPARATE windows - Data and Chart?

T

Tim S

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
 
B

Bob I

Then you will need to open an instance for each. (From the Start menu,
or the Quick Launch toolbar)
 
S

Shane Devenshire

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to open two Excel files in separate windows? 4
Opening files in separate windows 6
PowerPoint Embed scroll excel chart and data in powerpoint 0
Copy-Paste Chart into Word from Excel 2007 3
Stacked Columns (two separate companies, 3 time periods) 1
Chart Macro Help Needed 1
Excel in separate windows 2
Can't drag new data to chart in 2007. 1

Top