Monthly Archives: April 2020

Multiple Windows in Excel

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:

image.png

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.