Imagine when you open a workbook, multiple windows will be opened and each window allows you to work on 1 worksheet and they get arranged nicely across a large LCD monitor. Sounds like a dream? Well this is easy to do.
- Open any workbook and click on Window->New Window.
- Do this 3 more times.
- Click Window->Arrange. Choose “Tiled” from the Arrange Window dialog box.
At this point you should see 4 windows all pointing to the same workbook. Use each window on the screen to access different worksheets, effectively you are working on 4 sheets at the same time! Any save command you perform will save all your work to the same workbook. And get this: next time you open the same file, you get this set up just where you left off!