Did you know that you can view two tabs at once in Excel, side by side for a single Excel workbook/file? This is especially helpful if you are working with a formula that affects another tab, whether checking for accuracy or troubleshooting. It’s also great if you are running what-if scenarios such as in a sensitivity analysis and you would like to keep an eye on the values in two tabs.
Adding a second window in Excel to see two tabs at once:
- On the menu bar, click View.
- Click New Window.
- Position the two windows however you’d like.
- Note that it is still one file, so both windows will update when you make a change. You can save from either window.
Alternatively, if you love keyboard shortcuts like I do, simply use this combination: ALT + W, then N.
Here is an example of how it looks for this sample loan calculator file:
Simple solutions are the best! I truly hope this helped you out! Please consider bookmarking this site and subscribing. I add new content often! Thanks!
Also, check out Dose for Excel (click the image below)! It adds over 100 functions to Excel to increase your productivity and more! Disclosure: this is an affiliate link, so I may earn a small commission if you decide to purchase the add-in. Thanks for supporting my blog!
If I helped you today, please consider leaving a tip via PayPal to help cover blog costs! Thanks!!
Subscribe for more great content!