ExcelBanter - Change format to landscape for whole workbook at once

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Change format to landscape for whole workbook at once (https://www.excelbanter.com/excel-worksheet-functions/24118-change-format-landscape-whole-workbook-once.html)

Change format to landscape for whole workbook at once

Hi,

I have a workbook which has 20 worksheets included. If I want to configure
all the worksheets to print in landscape, is there any way I can do it?
Thanks

Peo Sjoblom

Select all sheets (click first, hold down shift and press last), then do the
page setup

--
Regards,

Peo Sjoblom

"hw" wrote in message
...
Hi,

I have a workbook which has 20 worksheets included. If I want to configure
all the worksheets to print in landscape, is there any way I can do it?
Thanks

All times are GMT +1. The time now is 10:04 PM.