ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I get the Page Setup to apply to all the worksheets? (https://www.excelbanter.com/excel-discussion-misc-queries/175971-how-do-i-get-page-setup-apply-all-worksheets.html)

colette

How do I get the Page Setup to apply to all the worksheets?
 
I have set up multiple worksheets and want all the pages to print with the
same Page Setup, ie. margins, scaling, orientation, etc. I don't want to have
to do a page setup for every worksheet.

Dave Peterson

How do I get the Page Setup to apply to all the worksheets?
 
Lots of page settings (but not all) can be changed when the sheets are grouped.

Click on the first tab
ctrl-click on subsequent
do the file|page setup stuff
and ungroup the sheets.

Then check to see if the stuff you wanted to change was changed.

Colette wrote:

I have set up multiple worksheets and want all the pages to print with the
same Page Setup, ie. margins, scaling, orientation, etc. I don't want to have
to do a page setup for every worksheet.


--

Dave Peterson


All times are GMT +1. The time now is 07:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com