Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 48
  • Last Modified:

want to be able to toggle

windows 7 desktop
excel 10

toggle between open workbook windows
when only one appears at a time
0
rgb192
Asked:
rgb192
3 Solutions
 
John HurstBusiness 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
 
John HurstBusiness 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
John HurstBusiness 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
 
Subodh Tiwari (Neeraj)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
 
Glenn RayExcel 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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now