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.

5 thoughts on “Multiple Windows in Excel

  1. josephlynchadmin Post author

    Yeah, I was blown away to see this. Feel like an idiot for missing it.
    Happy to share with my appraiser friends.

    Reply
  2. Ryan Lundquist

    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.

    Reply
    1. josephlynchadmin Post author

      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.

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *