Add to list of custom formats

[kkjensen]

Hi there,

I'm curious where the list of custom formats is so I can add a few entries to it.

I've got a couple cell formats that I use all the time and it's a bit of a waste of time to have to type out the formula and copy it around on my worksheets.

It get great if I could just pick the format off a list OR (even better) assign a quick key to the format (I guess this could be a macro in my personal.xls file)



...okay, so I kinda found a solution to my own question but is there anywhere I can add my format to the list of customs cell formats???

Thanks!

 

[RalphA]

Simply click on Format, Cells, Number, Custom (at the bottom of the list). Then, enter your specially customized format in the slot under "Type". Tell us if this solves your problem.

 

[kkjensen]

You've explained how to give something a custom format but there's this list over down at the bottom of all the other pre-defined formats you can apply to a cell. After creating a format I find it in this list as long as I'm in the same workbook

Is there some way to add my new format to that list in a "permanent" fashion so it is still there when I create new sheets? Currently I've created a macro that applies the custom format that I want but am just curious if excel allows for this kind of functionality.[/i]

 

[RalphA]

You can try using the Format Painter. It's the little, yellow paintbrush icon in the Standard Toolbar.

If you are not familiar with its use, maybe this example will serve:

1. On same sheet:
On Sheet1 of Workbook1, you have formatted cell A1, and you wish to format cells C3:D5 in the same manner. You click on A1, click on the Format Painter icon, then you click and drag on C3:D5. Done!

2. From Workbook1, Sheet1, A1 to Workbook2, Sheet2, C3:C5:
Open Workbook1, Sheet1, in a window, say half-sized. Open Workbook2, Sheet2, also in a half-sized window, so you can see both at the same time.
Do as explained above, in 1. Done!

Do tell us if this solves your problem.

 

[Mark W.]

Add the custom formats to a blank template, Book.xlt, and save it in your XLStart folder. Once done those custom formats will always be available when you open a new workbook.

 

[kkjensen]

The template did it. Thanks!

 

[lenze]

Open your file Book1. It is probably in your xlstartup folder. If not searh your C drive to locate it. If you can't find it, you can create on one in xlstartup. Now open this file and choose format>styles. Enter a name for each custon format and then modify as desired. . Now when you open a new workbook, the styles will be there and all you need to do is select the cells you need and choose format>styles and select your style

HTH

lenze