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
Our community of experts have been thoroughly vetted for their expertise and industry experience.