I might be late to the show but the latest version of Excel offers multiple windows open in the same workbook. For example, say you want to enter results from one worksheet into another. Or you’re looking at a large worksheet and want to see results in the lower corner and upper corner at the same time.
Here’s how:
Select View, New Window. You can repeat as needed from the original window.
Here’s a screenshot:
The magic trick if you have multiple monitors
Here’s the result spread over two monitors:
Two instances of your workbook
And why this is so useful:
Navigate the second screen to the data you want to copy to the first
Wish I’d known this 10 years ago. Maybe I will buy that 4th monitor after all.
Thanks for sharing! I did not know this. Very helpful.
Yeah, I was blown away to see this. Feel like an idiot for missing it.
Happy to share with my appraiser friends.
Joe, it has been driving me crazy to not have this. I literally think about this every time I use Excel because I always have a need for multiple views. Thank you.
Yeah, same here. I’m sure it’s been around forever but unless you have someone who shares the magic trick, you’re never going learn it.
Thanks!