Microsoft Excel by default opens all spreadsheets into the same Workspace, so it can be tricky if you want to work on multiple spreadsheets at the same time.
If you’re copying information between two spreadsheets, or want to compare data from two different sources, then it can be tricky to do. You might have experienced the problem of having to flick back and forth between two spreadsheets.
One way around it is to use the View Side by Side option:
- Open the two spreadsheets you want to work upon
- Select the View tab
- Click on View Side by Side
- To switch between the spreadsheets being on top of each other or side by side, click on Arrange All and select Horizontal or Vertical
It will look something like this:
However, that’s still not much use if you have two monitors, and want to have a separate spreadsheet in each monitor, because a maximised Excel worksheet only works in one monitor.
What you need is to start up two separate instances of Excel, and then each instance can be maximised on separate monitors. The first instance of Excel loads in the normal way, and you open your first spreadsheet in that. The second instance of Excel can be started by holding down the shift key as you click on the Excel icon (either from the Start menu or Taskbar). A separate blank Excel worksheet will launch (it’s actually a second instance of the Excel program running) and you can load your second spreadsheet into that.
These separate instances run completely independently of each other, and one can be closed (or even killed in the Task Manager) without affecting the other.