Open mutiple spreadsheets in one session of Excel and use 'ALT' +

P

ppatel

I upgraded my Excel 2003 to Excel 2007. When I open muliple spreadsheets
within one session of Excel the only way I can move between the two
spreadsheets is to use the 'View' tab and then 'Switch Windows' drop down to
select the other worksheet.

Is there a setting that I can set to enable me to use the 'ALT' + 'TAB' keys
to flick between the two Excel spreadsheets within one session of Excel?

A work around of opening two Excel sessions with one file open in each Excel
session is not a solution for me as I want to Copy cell values from one file
and use 'Paste Values' into another file. Therefore both spreadsheets need to
be open within one Excel session for my to use the 'Paste Values' feature.
 

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

Excel Excel spreadsheets opening at top instead of bottom. 4
How to open Excel 2003 in separate Windows for multiple monitors 3
Need to open 2 Instances of Excel 2007 5
Excel starts very slowly 4
open spreadsheets into separate excel instance 1
how do I alt-tab between windows in Excel with 07? 2
mult. w/sheets need identical view when opening (range, mag, cell) 2
Run program between 2 separate excel sessions 3

Top