Printing Workbooks in a Folder

Summary: This tip presents two techniques you can use to print multiple workbooks all at the same time. Both techniques involve creating selection sets and then acting on those sets. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

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:

Display the folder that contains all the documents you want to print.
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.)
Right-click on one of the selected workbooks. Windows displays a Context menu.
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:

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.)
Using the controls in the dialog box, display the folder that contains the workbooks you want to print.
Create a selection set of the workbooks you want to print.
Right-click the selection set and choose Print from the resulting Context menu.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3316) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

A Picture is Worth Thousands! Your worksheets are not limited to holding numbers and text. You can also add graphics or easily create charts based on your data. Excel Graphics and Charts, available in two versions, helps you make your graphics and charts their absolute best.

Check out Excel Graphics and Charts today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Printing Workbooks in a Folder