Louise

Yes, most setup functions can be done on grouped sheets.

Some of the page setup features will not be available with grouped sheets.

Print Area and Print Titles will be grayed out in grouped sheets the same as
when in Print Preview.

Joe_Bruin is not correct in his last sentence.

It is the same thing as the repeat columns and rows,
which are greyed out under the print preview option, but not when you
choose "page setup" under "File"


Gord Dibben Excel MVP

On Mon, 5 Dec 2005 07:57:05 -0800, Louise
wrote:

Does this mean that when you group the worksheets together and use 'File' and
'Page Setup' from normal view, it will allow you to change the page set up
options for every page in one go????

Thanks.

Louise

"Joe_bruin" wrote:

I would like to add a little something to all the help everyone has
offered on the formatting issue in Excel. If you would like to format
all sheets including (Header, Footer, etc..) you need to make sure and
use the "page setup" under "file" menu, because using the formatting
from the print preview option will only make changes to the sheet you
are currently viewing.

I'm guessing but I think MS wanted to make sure you don't accidentally
format all sheets thru print preview so they make you choose it from
the file menu. It is the same thing as the repeat columns and rows,
which are greyed out under the print preview option, but not when you
choose "page setup" under "File"

Make sense?

Hope this helps.