troubleshooting Question

How to simultaneously view two or more worksheets belonging to a common Excel 2013 workbook

Avatar of Steve_Brady
Steve_BradyFlag for United States of America asked on
Microsoft OfficeMicrosoft ExcelMicrosoft Applications
2 Comments1 Solution459 ViewsLast Modified:
Hello,

With the limited viewing options available in Excel 2013, is it possible to simultaneously view two or more worksheets (tabs) if they are both part of single workbook?

For example, in Excel 2010, a workbook could be maximized within an Excel window (instance) or non-maximized (restored). In the latter view, right clicking on the title bar of the restored worksheet gave you the option to open one or more new windows which could then be arranged (e.g. horizontally, vertically, tiled, etc.) within the larger Excel window (instance). Having done that, you could then simultaneously view different parts of the same worksheet or different worksheets contained in that workbook. Furthermore, this viewing option was a good way to maximize your available screen real estate because all worksheets within a single Excel instance, could share a single Ribbon and QAT.

Are those type of viewing options no longer available in Excel 2013? If not, are we therefore required to move a particular tab (worksheet) to a brand-new workbook each time we want to see it side-by-side with a fellow tab? Also, are any workarounds available (including by using VBA) to get back to the more efficient 2010 viewing options?

Thanks
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros