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. Display the Open dialog box. (In Excel 2007, click the Office button and then click Open. In older versions of Excel click on Open or choose Open from the File menu.)
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.