Basic Excel Help (Multiple Windows?)

[Nitefly]

Hi - I’m struggling with what I assume must be simple excel issues and it’s making me lose the will to live, so any help is greatly appreciated.

Can You really not have multiple windows of excel? You can do this in word, obviously, but I find it strange you can’t do this in excel. I know you can view spreadsheets ‘side by side’ within a single window but I like wording in multiple windows as I have so many emails / word documents / pdfs etc open at once and frequently overlay them - it is far more flexible. There must be an easy solution to this... Shirley?! Google says no so my googling must be poor...

Thanks in advance

 

[Nitefly]

Thanks guys - I think it just may be the version of excel we run at work

 

[Nitefly]

For Excel <= 2010 when opening Excel hold down the Alt button and it'll open up as a separate instance. It's still not a great solution though as trying to manage opening the correct file in the correction session is a pain and copying between the session is limited to plain data. Also, multiple views into the same workbook are still limited to the single window of the session it's currently open in.

I agree though, once you've experienced the wonders of multiple windows in Excel 2013+ it's hard to go back.

On the plus side, end of support for Office 2010 is October 2020 so you'll at most have to live with it for two more years by which point your IT guys should really be upgrading you.

You are a god! Thank you!!