how to applythe page setup setings to allsheets in afile in excel
 

iI want to apply the page setup settings to all sheets in an excel work book.
How can I do it without having to go to each sheet and then doing it
individually?
Cn any one help?

how to applythe page setup setings to allsheets in afile in excel
 

Asif -

One method: Right-click a worksheet tab (at the bottom of the display), and
choose Select All Sheets. Then choose File | Page Setup ... and make any
other format changes that you want to apply to all sheets. Finally,
right-click a worksheet tab, and choose Ungroup Sheets.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



"Asif" wrote in message
...
iI want to apply the page setup settings to all sheets in an excel work
book.
How can I do it without having to go to each sheet and then doing it
individually?
Cn any one help?