In article , ?B?ZGpjMTcxMQ==?= wrote:
Yep. Select all your worksheets and then go into page setup. Any change you
make to one will be replicated across them all.

To select multiple worksheets: click the left-most worksheet tab and then
shift-click on the right-most worksheet tab. Alternatively use CTRL-click on
individual tabs.

"Wease1967" wrote:

I'm creating an Excel 2003 workbook containing ten worksheets. Can I change
the page setup for all sheets at once instead of each individually?

.. and remember to select only one page before you continue after doing
this. You can make a huge cock up by selecting multiple sheets and
forgetting that you have done so :)


Bruce

----------------------------------------
I believe you find life such a problem because you think there are the good
people and the bad people. You're wrong, of course. There are, always and
only, the bad people, but some of them are on opposite sides.

Lord Vetinari in Guards ! Guards ! - Terry Pratchett

Caution ===== followups may have been changed to relevant groups
(if there were any)