Select a sheet.

Right-click on sheet tab and "select all sheets"

Do what you wish for formatting to active sheet and will be done to all.

DO NOT FORGET to ungroup the sheets when formatting is done.


Gord Dibben MS Excel MVP

On Thu, 25 Dec 2008 20:15:00 -0800, aamir
wrote:

i have eight sheets in a worbook---they have headers, footers, row heights,
column widths, font sizes, etc. can I format these so that everything
appearance, layout, margins, etc. are identical on the eight sheets. Of
course, the text or figures un the cells would be different

thank you very much