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

Embed the same Excel multiple times 0
Word macro that can call cells out of Excel for a find and replace 0
Merging from an Excel file with graphics 1
Alt Tab and Multiple Spreadsheets 3
Access 2003 and excel 0
="'"&F1&"'," Excel errors in one spreadsheet but not other one? 1
Need to open 2 Instances of Excel 2007 5
How to open Excel 2003 in separate Windows for multiple monitors 3

Top