Forum Discussion
jeblm
Jul 15, 2019Copper Contributor
How to open Excel Spreadsheets in SEPARATE windows
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 e...
nabilmourad
Jul 15, 2019MVP
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