![quick print excel quick print excel](https://d295c5dn8dhwru.cloudfront.net/wp-content/uploads/2019/06/23050604/Screen-Shot-2019-06-23-at-12.04.29.png)
Free to try with no limitation in 30 days. Kutools for Excel includes more than 300 handy Excel tools. But Kutools for Excel can do it! Kutools for Excel's Print Multiple Workbooks Wizard tool can completely print all or specific workbooks no matter they are staying in one folder or different folders. If you want to print the specified worksheets in the selected workbooks from a folder or multiple folders, the above methods are not effective for you. Print specific or all worksheets of multiple workbooks with Kutools for Excel Then press F5 key to run the code, and all of the worksheets within the workbooks will be printed.
Quick print excel code#
Click Insert > Module, and paste the following code in the Module Window.ģ. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.Ģ. If you want to print all worksheets of multiple workbooks, the above method will not work, but the following short VBA code can help you quickly print them.ġ. Print all worksheets of multiple workbooks with VBA code It can only print the active worksheets of each workbook. All workbook files that you want to print must be in the same folder.Ģ.
![quick print excel quick print excel](https://www.omnisecu.com/images/excel/basics/customize-excel-quick-access-toolbar-qat.jpg)
Go to the folder contains the workbooks you want to print, select all of the workbooks, and right click, choose Print from the context menu, see screenshot:Īnd then all of the active worksheets within the opened workbooks are printed.ġ. Put the workbooks that you want to print into one folder, and make sure the workbooks are opened, then activate the worksheets you want to print of the workbooks.Ģ. If you have multiple workbooks which contain many worksheets, but you just need to print the active worksheet of each workbooks, you can solve this problem with following steps:ġ.