Log in
x
or
x
x
Register
x

or
0
0
0
s2sdefault

Quickly print multiple workbooks or worksheets from directories in Excel

Normally, if you need to print multiple workbooks, you may need to separately open each workbook to print and then closing all workbooks. But with Kutools for Excel’s Print Multiple Workbooks Wizard utility, you can quickly:

Print multiple workbooks from a directory

Print multiple workbooks from different directory

Print certain or specific worksheets from a workbook or multiple workbooks

Print only chart sheet from a workbooks or multiple workbooks

Print multiple CSV or text files from a directory


Click Enterprise > Printing> Print Multiple Workbooks Wizard. See screenshots:

shot print multiple workbooks 1kutools-arrow-rightshot print multiple workbooks 02

Print multiple workbooks from a directory

If you want to print multiple or specific workbooks from a directory in Excel, please open the Excel and then applying this utility by clicking Enterprise > Printing > Print Multiple Workbooks Wizard. In the Print Multiple Workbooks Wizard dialog box, please choose All of the files to be printed are in the same directory option. See screenshot:

shot-print-multiple-workbook2

Then click Next button to go to step 2, please specify a folder which contains the workbooks that you want to print by clicking Browse button. Please configure the settings according to below screenshot. See screenshot:

A: Please click Browse button to select a folder which contains the worbooks or CSV, text files you want to print.

B: You can quickly specify the file types. For Example, to print only workbooks or worksheets, please only checked
the Excel workbboks option, if you want to print CSV, text files from the same folder, please also checked the Text files option.

C: You can also specify the file type by entering the file extension, such as *.xls.

D: It will indicate how many workbooks or files will be printed.

Please click Next button to go to step 3. If you want to print entire workbook, please choose Entire workbook, and please checked the workbook that you want to print. See screenshot:

shot-print-multiple-workbook4

Please click Next button to go to step 4, and specify the printing settings. See screenshot:

shot-print-multiple-workbook5

A: Quiet Mode: It will not open the files that is going to be printed.

Generate a summary report: It will generate a report which includes the information of the files to be printed
and also lists the errors that occurred.

Disable Auto macros: The auto macros will not be executed in the open workbooks.

B: Prompt for passwords: It will prompt a dialog box for you to enter the password for printing the files that
reuqires a password to open.

Use this password: Please enter the password to print the files that requires a password to open.

C: Links & remote references: It will update the links and remote references when each file is opened.

In the step 4, please click Finish button to start printing. Tip: If you checked Generate a summary report option, it will generate a summary report in a workbook of Excel when the printing is over.


Print multiple workbooks from different directory

If you want to print multiple workbooks from different directory in Excel, please open Excel and then applying this utility by clicking Enterprise > Printing > Print Multiple Workbooks Wizard. In the Print Multiple Workbooks Wizard dailog box, please choose The files to be printed are in multiple directories. See screenshot:

shot-print-multiple-workbook6

Then click Next button to go to step 2, click Add Files button to add the workbooks that you want to print. See screenshot:

shot-print-multiple-workbook7

Please click Next button to go to step 3. If you want to print entire workbook, please choose Entire workbook, and please checked the workbook that you want to print. See screenshot:

shot-print-multiple-workbook8

Please click Next button to go to step 4, and specify the printing settings. See screenshot:

shot-print-multiple-workbook5

A: Quiet Mode: It will not open the files that is going to be printed.

Generate a summary report: It will generate a report which includes the information of the files to be printed
and also lists the errors that occurred.

Disable Auto macros: The auto macros will not be executed in the open workbooks.

B: Prompt for passwords: It will prompt a dialog box for you to enter the password for printing the files that
reuqires a password to open.

Use this password: Please enter the password to print the files that requires a password to open.

C: Links & remote references: It will update the links and remote references when each file is opened.

In the step 4, please click Finish button to start printing. Tip: If you checked Generate a summary report option, it will generate a summary report in a workbook of Excel when the printing is over.


Print certain or specific worksheets from a workbook or multiple workbooks

If you want to print certain or specific worksheets from a workbook or multiple workbooks, please open Excel and then applying this utility by clicking Enterprise > Printing > Print Multiple Workbooks Wizard. In the Print Multiple Workbooks Wizard dailog box, please choose All files to be printed are in the same directory. See screenshot:

shot-print-multiple-workbook2

Then click Next button to go to step 2, please specify a folder which contains the workbooks that you want to print by clicking Browse button. Please configure the settings according to below screenshot. See screenshot:

 

A: Please click Browse button to select a folder which contains the worbooks or CSV, text files you want to print.

B: You can quickly specify the file types. For Example, to print only workbooks or worksheets, please only checked
the Excel workbboks option, if you want to print CSV, text files from the same folder, please also checked the Text files option.

C: You can also specify the file type by entering the file extension, such as *.xls.

D: It will indicate how many workbooks or files will be printed.

Please click Next button to go to step 3. If you want to print certain or specific worksheets from a workbook or multiple workbooks, please choose Specify sheets, and please checked the workbook and the worksheets that you want to print. See screenshot:

shot-print-multiple-workbook4

Please click Next button to go to step 4, and specify the printing settings. See screenshot:

shot-print-multiple-workbook5

A: Quiet Mode: It will not open the files that is going to be printed.

Generate a summary report: It will generate a report which includes the information of the files to be printed
and also lists the errors that occurred.

Disable Auto macros: The auto macros will not be executed in the open workbooks.

B: Prompt for passwords: It will prompt a dialog box for you to enter the password for printing the files that
reuqires a password to open.

Use this password: Please enter the password to print the files that requires a password to open.

C: Links & remote references: It will update the links and remote references when each file is opened.

In the step 4, please click Finish button to start printing. Tip: If you checked Generate a summary report option, it will generate a summary report in a workbook of Excel when the printing is over.


Print only chart sheet from a workbooks or multiple workbooks

If you want to only print chart sheets (worksheets) from a workbook or multiple workbooks which are locating at the same folder, please open Excel and then applying this utility by clicking Enterprise > Printing > Print Multiple Workbooks Wizard. In the Print Multiple Workbooks Wizard dailog box, please choose All files to be printed are in the same directory. Tip: chart sheet - A sheet in a workbook that contains only a chart. A chart sheet is beneficial when you want to view a chart or a PivotChart report separately from worksheet data or a PivotTable report. See screenshot:

shot-print-multiple-workbook2

Then click Next button to go to step 2, please specify a folder which contains the workbooks that you want to print only the chart sheets by clicking Browse button. Please configure the settings according to below screenshot. See screenshot:

 

A: Please click Browse button to select a folder which contains the worbooks or CSV, text files you want to print.

B: You can quickly specify the file types. For Example, to print only workbooks or worksheets, please only checked
the Excel workbboks option, if you want to print CSV, text files from the same folder, please also checked the Text files option.

C: You can also specify the file type by entering the file extension, such as *.xls.

D: It will indicate how many workbooks or files will be printed.

Please click Next button to go to step 3. If you want to only print chart sheets or worksheets from a workbook or multiple workbooks, please choose Chart sheets only, then only the chart sheets will be checked in the list. See screenshot:

shot-print-multiple-workbook4

Please click Next button to go to step 4, and specify the printing settings. See screenshot:

shot-print-multiple-workbook5

A: Quiet Mode: It will not open the files that is going to be printed.

Generate a summary report: It will generate a report which includes the information of the files to be printed
and also lists the errors that occurred.

Disable Auto macros: The auto macros will not be executed in the open workbooks.

B: Prompt for passwords: It will prompt a dialog box for you to enter the password for printing the files that
reuqires a password to open.

Use this password: Please enter the password to print the files that requires a password to open.

C: Links & remote references: It will update the links and remote references when each file is opened.

In the step 4, please click Finish button to start printing. Tip: If you checked Generate a summary report option, it will generate a summary report in a workbook of Excel when the printing is over.


Print multiple CSV or text files from a directory

If you want to only print multiple CSV files and text files fromo a directory in Excel, please open Excel and then applying this utility by clicking Enterprise > Printing > Print Multiple Workbooks Wizard. In the Print Multiple Workbooks Wizard dailog box, please choose All files to be printed are in the same directory. See screenshot:

shot-print-multiple-workbook2

Then click Next button to go to step 2, please specify a folder which contains the CSV files and text files that you want to print by clicking Browse button. Please configure the settings according to below screenshot. Note: please only checked Text files in step 2. See screenshot:

A: Please click Browse button to select a folder which contains the worbooks or CSV, text files you want to print.

Please click Next button to go to step 3. If you want to only print CSV files and text files, please choose Entire workbook, then all the CSV files and text files will be checked in the list. See screenshot:

shot-print-multiple-workbook4

Please click Next button to go to step 4, and specify the printing settings. See screenshot:

shot-print-multiple-workbook5

A: Quiet Mode: It will not open the files that is going to be printed.

Generate a summary report: It will generate a report which includes the information of the files to be printed
and also lists the errors that occurred.

Disable Auto macros: The auto macros will not be executed in the open workbooks.

B: Prompt for passwords: It will prompt a dialog box for you to enter the password for printing the files that
reuqires a password to open.

Use this password: Please enter the password to print the files that requires a password to open.

C: Links & remote references: It will update the links and remote references when each file is opened.

In the step 4, please click Finish button to start printing. Tip: If you checked Generate a summary report option, it will generate a summary report in a workbook of Excel when the printing is over.


Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 200 Advanced Functions for Excel 2016, 2013, 2010, 2007 and Office 365.
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013, 2016 and 365, as if it were Office 2000 and 2003.

Kutools for Excel

The functionality described above is just one of 200 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.

Screen shot of Kutools for Excel

btn read more     btn download     btn purchase

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.