Since the term "format" is rather generic I can only supply a generic method.

Select first worksheet tab then right-click and "select all sheets".

Do your formatting on active sheet and it will be done to all sheets.

DO NOT FORGET to ungroup the sheets when done.

NOTE: while in group mode, some Print Setup features are not
available........set print area, print titles to name two.

To do all sheets in all files would require VBA code to open each file,
operate on all sheets in the file, save/close and open next file.


Gord Dibben Excel MVP


On Tue, 17 May 2005 10:46:03 -0700, "mdeanda"
wrote:

For proper printing I need to copy the format from one tab into all of the
other tabs in a work book. I have 35 files with up to 40 tabs in each file.
Is there a way to copy the format once for each Excel file