Excel-forcing page-setup parameters thru entire workbook

[floydman80]

I have a "large" workbook of 65 worksheets. I have a way to copy formatting changes throughout the workbook. But it doesn't work on page set-up (ex. portrait vs landscape). Any way of doing this once and getting all worksheets to have the same page set-up template (page orientation, margins, etc.). Thanks.

 

[PeterMoran]

Hi floydman80,

You need to select all the tabs first before you start the formatting.

The easiest way to select all tabs is to select the first, hold the shift key down, display the last, and then click on it. All tabs should now be selected.

Now do your formatting once for all sheets.

HTH and Good Luck!

Peter Moran
Two heads are always better than one!