Printing Workbooks in a Folder

Have you collected a bunch of workbooks in a folder, and you want to print all of them at once? There are a couple of quick and easy ways you can do this. The first method involves the use of Windows, not Excel. Follow these general steps:

1. Display the folder that contains all the documents you want to print.
2. Create a selection set of the documents you want to print. (Select them all, using Ctrl and Shift to help put the selection set together.)
3. Right-click on one of the selected workbooks. Windows displays a Context menu.
4. Choose Print from the Context menu.

Excel is automatically started and each workbook is printed, in turn. You can also apply a variation on this approach:

1. In Excel, display the Open dialog box. (Click on Open or choose Open from the File menu. If you are using Excel 2007, click the Office button and then click Open.)
2. Using the controls in the dialog box, display the folder that contains the workbooks you want to print.
3. Create a selection set of the workbooks you want to print.
4. Right-click the selection set and choose Print from the resulting Context menu.