custom formats in new sheets

  • Thread starter Thread starter splot!
  • Start date Start date
S

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
 
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
 
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
 
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
 
Back
Top