custom formats in new sheets

[splot!]

Hello all,

Excel2000

I've got some custom formats which I use in pretty well all my
spreadsheets. Is there a way to make user-defined custom formats
appear in new sheets? When I start a new sheet there are always the
standard set of 'custom' formats but the ones I have defined and want
to use have to be set up again for that sheet.

I'm sure ther is a simple answer to this, something I've been getting
by with for over ten years!

Actually, related to this question: there are loads of 'custom'
formats defined in Excel which I never use but have to scroll through
to get to my defined ones. Can I get rid of ones I don't want,
somehow?

Thanks in anticipation

Regards

Chris

 

[Gord Dibben]

Open a new workbook. Customize as you wish.

File>Save 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 File>New or the Toolbar button File>New or
CTRL + n

WARNING................Do not use File>New...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 Insert>Sheet.

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

Getting rid of the Excel default Custom Formats is not possible AFAIK.


Gord Dibben Excel MVP

 

[splot!]

Ah, that's perfect thanks Gordon.

Shame about not being able to delete the standard custom formats but
this is a significant improvement - and as mine have appeared at the
bottom of the list they are easy to find anyway.



Thanks aggain

Regards

Chris

 

[Gord Dibben]

Thanks for the feedback.

Yes, it would be nice to be able to create a Template with just the custom
formats one uses regularly but never found a way.

Note also that you can create and/or modify the styles in Format>Style but these
are workbook specific so must be done in your Template.


Gord