How can I format all my worksheets the same way - font , size , layout , etc

Group them before you apply the format, hold down shift and select first and
last sheet


--
Regards,

Peo Sjoblom


"format different worksheets w/same forma" <format different worksheets
w/same wrote in message
...
How can I format all my worksheets the same way - font , size , layout ,
etc

See Peo's post for existing workbook sheets.

For New workbooks and worksheets.......................

Open a new workbook. Customize as you wish.

FileSave As Type: scroll down to Excel Template(*.XLT) and select. Name your
workbook "BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT.

Store this workbook in the XLSTART folder usually located at........

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

This will be the default workbook for FileNew or the Toolbar button FileNew or
CTRL + n

WARNING................Do not use FileNew...Blank Workbook or you will get the
Excel default workbook.

NOTE: Existing workbooks are not affected by these settings.

You can also open a new workbook and delete all but one sheet. Customize as
you wish then save this as SHEET.XLT in XLSTART folder also. It now becomes
the default InsertSheet.

More can be found on this in Help under "templates"(no quotes).


Gord Dibben Excel MVP




On Fri, 18 May 2007 12:58:01 -0700, format different worksheets w/same forma
<format different worksheets w/same wrote:

How can I format all my worksheets the same way - font , size , layout , etc