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.
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:
If I helped you, please consider buying me a coffee via PayPal! Thanks!!
Subscribe for more great content!