Opening Multiple Workbooks at Once

Excel provides a complete file management system. One of the features of this system is that you can quickly load multiple workbooks in one easy step. To do this, follow these steps:

1. Click on the Open tool on the toolbar, or choose Open from the File menu. This displays the Open dialog box.
2. Instead of double-clicking on a file name, start to create a "selection set." If you are selecting sequential files, click on the first file in the sequence, then hold the Shift key as you click on the last. You can add additional files to those selected by holding down the Ctrl key while clicking with the mouse.
3. To remove files from the selection set, hold down the Ctrl key while clicking on a file name you previously added to the set.
4. When you are satisfied with the list, click on Open.