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

Make Home Buying Less Stressful! Why make home buying harder than it needs to be? Put your mind at ease—discover all the questions you need to ask to make the best buying decision.

Check out Buying a Home Checklist today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Printing Workbooks in a Folder