Excel Guides

Working With Multiple Printers in Excel

There are a few different ways to work with multiple printers in Excel. You can use the File > Print method, which will give you a list of all the installed printers on your computer. From there, you can select the printer you want to use. Another way is to use the Application.ActivePrinter property. This will let you change the printer that is currently active within Excel. You can also use the Application.Printer property to set a specific printer as the active one.

If you want to print to multiple printers at once, you can use the Application.Dialogs(xlDialogPrinterSetup). This will bring up the Print dialog box, where you can select multiple printers. To do this, hold down the Ctrl key while clicking on each printer you want to use. Once you have all the printers selected, click OK. Now when you go to print your document, it will be sent to all of the selected printers.

Note: If you are using a Mac computer, the process for printing to multiple printers is a bit different. Instead of using the Application.Dialogs(xlDialogPrinterSetup), you'll need to use the Application.CommandBars("File").Controls("Print").Execute. This will open up the Print dialog box where you can select multiple printers.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.