Work with multiple Excel worksheets at the same time

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.

1. Open any workbook and click on Window->New Window.
2. Do this 3 more times.
3. 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!

Opening 4 worksheets at the same time

Related posts:

1. From the Global Financial Crisis to Microsoft Excel VBA. Thomas Friedman a New York Times columnist claimed that he has a theory of everything. In that brilliantly short article, he observed that for decades...