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:
- Press Ctrl+O to display the Open dialog box. (In Excel 2013 you’ll need to not only press Ctrl+O, but then click Computer and then Browse.)
- 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.
- To remove files from the selection set, hold down the Ctrl key while clicking on a file name you previously added to the set.
- When you are satisfied with the list, click on Open.