Lots of settings can be changed all at once if you group the sheets (select the
first and ctrl-click (or shift-click to select subsequent.

Then when all of the sheets are grouped, try file|page setup and see if you can
change all the settings you want.

Make sure you ungroup the sheets when you're done--almost any change you make to
one of the grouped sheets, you make to the others.

ps. You may want to try it on a few grouped sheets. If it works, then group
all of them and do it for real.

Paul Canal wrote:

Currently I have to go down the view/header& footer/custom route for each tab
on each worksheet.

Is there a default setting that includes it automatically?

--

Dave Peterson