Home

How to open Excel Spreadsheets in SEPARATE windows

%3CLINGO-SUB%20id%3D%22lingo-sub-754753%22%20slang%3D%22en-US%22%3EHow%20to%20open%20Excel%20Spreadsheets%20in%20SEPARATE%20windows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754753%22%20slang%3D%22en-US%22%3E%3CP%3EPlease%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20excel%20to%20open%20multiple%20spreadsheets%20in%20completely%20separate%20windows.%20I%20don't%20want%20to%20view%20side%20by%20side%20or%20anything%26nbsp%3BI%20just%20want%20them%20to%20be%20on%20completely%20different%20windows.%20For%20example%2C%20when%20I%20hover%20over%20excel%20in%20my%20desktop%20taskbar%2C%20I%20want%20all%20of%20my%20spreadsheets%20to%20show.%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-754753%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-754799%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20open%20Excel%20Spreadsheets%20in%20SEPARATE%20windows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754799%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F376459%22%20target%3D%22_blank%22%3E%40jeblm%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20Virtual%20Desktops%2C%20might%20help.%20Not%20sure%20if%20i%20understood%20your%20question%20correctly.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOr%20use%20the%20windows%20feature%20to%20snap%20into%20place%2C%20please%20see%20link%20below%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fmicrosoft-365%2Fblog%2F2013%2F02%2F07%2Fopen-excel-workbooks-in-separate-windows-and-view-them-side-by-side%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fmicrosoft-365%2Fblog%2F2013%2F02%2F07%2Fopen-excel-workbooks-in-separate-windows-and-view-them-side-by-side%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-754813%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20open%20Excel%20Spreadsheets%20in%20SEPARATE%20windows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754813%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F376459%22%20target%3D%22_blank%22%3E%40jeblm%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3EOn%20the%20View%20Tab%20%26gt%3B%26gt%3B%20Click%20on%20New%20Window%20%26gt%3B%26gt%3B%20You%20get%20another%20window%20of%20the%20same%20workbook.%3C%2FP%3E%3CP%3EOn%20each%20version%20you%20can%20be%20activating%20a%20different%20Sheet.%3C%2FP%3E%3CP%3EYou%20can%20switch%20between%20the%202%20windows%20(displaying%20different%20sheets)%20by%20using%20the%20shortcut%20CTRL%20%2B%20F6%3C%2FP%3E%3CP%3EYou%20can%20make%20changes%20in%20one%20window%20and%26nbsp%3B%20Close%20it.%20Since%20it's%20just%20another%20view%20of%20the%20same%20file%2C%20no%20one%20will%20ask%20you%20to%20save%20(you%20have%20another%20window%20still%20open).%20Changes%20done%20in%20ne%20window%20will%20be%20automatically%20reflected%20on%20the%20other%20window.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20That%20helps%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-754984%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20open%20Excel%20Spreadsheets%20in%20SEPARATE%20windows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754984%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F376459%22%20target%3D%22_blank%22%3E%40jeblm%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELike%20Theo_Bear%20and%20and%20Nabil%2C%20your%20question%20is%20not%20totally%20clear%20to%20me%20either.%20If%20by%20%22multiple%20spreadsheets%22%20you%20actually%20mean%20%22multiple%20workbooks%22%2C%20it%20sounds%20as%20if%20you%20want%20to%20know%20how%20to%20open%20each%20Excel%20workbook%20in%20its%20own%20dedicated%20instance%2C%20so%20they%20show%20up%20as%20such%20on%20your%20task%20bar%20as%20you%20mentioned.%20If%20that%20is%20what%20you%20want%2C%20this%20picture%20shows%202%20methods%20for%20achieving%20that%20objective.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F123299i1B827E271D4410EC%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Slide100.png%22%20title%3D%22Slide100.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
jeblm
Occasional Visitor

Please help.

 

I want excel to open multiple spreadsheets in completely separate windows. I don't want to view side by side or anything I just want them to be on completely different windows. For example, when I hover over excel in my desktop taskbar, I want all of my spreadsheets to show. Thank you!

3 Replies

@jeblm 

Hi 

Try Virtual Desktops, might help. Not sure if i understood your question correctly. 

 

Or use the windows feature to snap into place, please see link below: 

https://www.microsoft.com/en-us/microsoft-365/blog/2013/02/07/open-excel-workbooks-in-separate-windo...

@jeblm 

Hi 

On the View Tab >> Click on New Window >> You get another window of the same workbook.

On each version you can be activating a different Sheet.

You can switch between the 2 windows (displaying different sheets) by using the shortcut CTRL + F6

You can make changes in one window and  Close it. Since it's just another view of the same file, no one will ask you to save (you have another window still open). Changes done in ne window will be automatically reflected on the other window.

 

Hope That helps

Nabil Mourad

@jeblm 

Like Theo_Bear and and Nabil, your question is not totally clear to me either. If by "multiple spreadsheets" you actually mean "multiple workbooks", it sounds as if you want to know how to open each Excel workbook in its own dedicated instance, so they show up as such on your task bar as you mentioned. If that is what you want, this picture shows 2 methods for achieving that objective.

Slide100.png

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
11 Replies