Formatting worksheets, existing and new, in existing workbooks

[G. Dagger]

Hi, not sure if my 1st message posted ok, but in any case, my question
relates to what the best method would be to format each worksheet the same
(i.e. same page layout, orientation, header) in any given workbook that has
information already saved on it, and have the same formatting for when a new
worksheet is added. I have severak workbooks that require their own specific
editing, thus i need to avoid a mass default of specific parameters.

Thanks.

 

[Kevin B]

Select the sheets to format (click on the first sheet and shift click on the
last sheet to select contiguous worksheets, or click on the first sheet and
Control + Click to select non-contiguous sheets) to turn Group Mode on and
then add the formatting as needed as well as any common formulas. Formatting
and formulas are placed in all selected worksheets.

When finished right click on any selected worksheet tab and selet UNGROUP
SHEETS.

 

[G. Dagger]

Thanks Kevin, just one more thing however, when i add a new worksheet the
default parameters are still there. Is there anyway for a new worksheet to
reflect the changes automatically?

 

[Kevin B]

You could keep a blank worksheet fully formatted w/formulas in place and use
it as a template. When you need a new worksheet just make a copy of the the
template sheet by right clicking on the tab and selecting move or copy.
Click the check box that says MAKE COPY and you're set to go.

 

[Gord Dibben]

See your first post for another response.


Gord Dibben MS Excel MVP