Working with Multiple Workbooks

When you create an Excel workbook for each subject of your business, you will sometimes need to look at data from more than one workbook to make your decisions. In cases like this, you can switch between them by choosing the workbook’s name from the list displayed when you click the Switch Windows button on the View tab, or you can choose one of several arrangements so that you can work with your workbooks effectively.

Switch between Open Workbooks

  1. Click the View tab.

  2. Click Switch Windows.

  3. Click the name of the workbook ...

Get Microsoft® Office Excel® 2007 Plain & Simple now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.