Changing print orientation on all worksheets when printing a whole workbook in one go

New Contributor

Hi - please can you help!


I am printing a workbook with multiple sheets.


I want to change the print size of all sheets by either portrait to landscape or set all sheets to fit all columns to one page.


can this be done without having to change each sheet individually?

2 Replies


You may select all your sheets (click on first one, Shift, click on last one) and with that Page Setup will be applied to all selected sheets