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!
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.
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.