want to be able to toggle

windows 7 desktop
excel 10

toggle between open workbook windows
when only one appears at a time
LVL 1
rgb192Asked:
Who is Participating?
 
Subodh Tiwari (Neeraj)Connect With a Mentor Excel & VBA ExpertCommented:
Alt+Tab allows you to toggle between all the open applications which are visible on the taskbar.
Where as Ctrl+Tab allows you to toggle between excel files only.
If opened excel files are grouped on the taskbar, you may right click the taskbar --> Properties --> Choose Never combine for taskbar button option.
And if this doesn't ungroup the similar applications, you may download a third party application known as 7tt_setup_beta (free) to ungroup the same application on the taskbar.
0
 
JohnBusiness Consultant (Owner)Commented:
Open Excel twice each with one workbook and you can very easily toggle between open workbooks with Alt Tab. I do this all the time and it works very well.
0
 
rgb192Author Commented:
this works in windows 10 but not windows 7
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
JohnBusiness Consultant (Owner)Commented:
You can open Excel twice in Windows 7 - I have done this many times in Windows 7.

Restart your Windows 7 computer.

Open Excel and a workbook. Leave it open.

Now start Excel again. What happens?
0
 
JohnConnect With a Mentor Business Consultant (Owner)Commented:
I just fired up my Windows 7 machine in the basement which has Office 2010 and I have 2 Excel instances running, each with their own workbook and I can Alt Tab (toggle) between them.

Please check again. Thanks.
0
 
Glenn RayConnect With a Mentor Excel VBA DeveloperCommented:
[Ctrl]+[F6] will also toggle between all open Excel workbooks.

I do not recommend opening multiple instances/sessions of Excel 2010.  It is not stable and will not provide full functionality (ex., cutting and pasting).  Excel 2013 and newer can emulate multiple windows/instances, however.
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Chosen answers resolved the original question.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.