Work with multiple 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

Opening 4 worksheets at the same time

Related posts:

  1. More Dashboard examples I know the idea of creating dashboards in Excel seems...
  2. Dashboard ideas from Wall Street Journal The Wall Street Journal have a lot of good looking...
  3. What is a bullet chart? A bullet chart is a relatively new kind of chart...

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!


beautiful-dates-in-chart

Elegant Dates in Line Charts

I came across this stock chart in the Kuala Lumpur’s edition of the Business Times while I was in Malaysia. The chart has an elegant treatment of dates. I have seen this sort of designs in many magazines and wanted an afternoon challenge to do this in Excel. The exercise wasn’t very challenging after all. [...]

Continue Reading