Change format to landscape for whole workbook at once

  • Thread starter Thread starter hw
  • Start date Start date
H

hw

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
 
Select all sheets (click first, hold down shift and press last), then do the
page setup
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Landscape selected but printout persists in portrait. How to fix? 1
How do I copy formatting from 1 sheet to next in same workbook? 1
Add footers in 20 worksheets at once 4
set up for whole workbook 1
Formatting 3
page setup 3
Workbook Printing Page Format 3
change the orientation of a worksheet to Landscape 2

Back
Top