This tip can save you a lot of time and headaches.
Let’s say you have an Excel file with 50 sheets, and you want to work on a formula in the first sheet using data from the last sheet. Navigating between sheets can be cumbersome. Creating a new instance of the same Excel file allows you to switch back and forth between sheets easily. Here’s how to do it:
- Go to View > New Window (or press Alt > W > N).
Now, it’s like you have two instances of the same Excel file open. On one instance, go to the first sheet, and on the other, go to the last sheet.
And here’s where the magic happens: you can simply press Alt + Tab to switch between sheets.
You can even open more than two windows of the same Excel file. I use this all the time.
