Does this help?

http://office.microsoft.com/en-us/ex...164221033.aspx

--
Susan Ramlet
**please reply to the newsgroup so others may benefit**


"JSF" <(E-Mail Removed)> wrote in message
news:EA7FB20A-CEE6-480F-A346-(E-Mail Removed)...
> When I create a new spreadsheet from desktop right-click>>new>>MS Excel
> Worksheet, it starts in Calibri 11 font which I hate. How can I change
> that
> once and for all?

Thank you for your suggestion, Susan.

I am aware of that option and I've tried it before, only to find out that it
doesn't do the trick. This option ONLY affects new worksheets created from
WITHIN another worksheet, by selecting Office Button >> New. The option does
NOT affect new worksheets created from the "new" template.
Needless to say that setting is useless. Having to open a worksheet in
order to CREATE A NEW worksheet is absolutely counterintuitive.

As I said before, I create new worksheets from the "new" templates by
righ-clicking and selecting new excel spreadsheet (logical). Unfortunately,
the template always starts in Calibri (Body) 11 font, regardless of the
setting in the options.

The default workbook for Right-click>New>Microsoft Office Excel Worksheet is
found in C:\Windows\ShellNew folder.

Named EXCEL12.XLSX

Replace this file by opening Excel first and creating a new workbook with
the desired formatting.

Save as to the name and path as above.


Gord Dibben MS Excel MVP


On Mon, 27 Apr 2009 19:53:01 -0700, JSF <(E-Mail Removed)>
wrote:

>Thank you for your suggestion, Susan.
>
>I am aware of that option and I've tried it before, only to find out that it
>doesn't do the trick. This option ONLY affects new worksheets created from
>WITHIN another worksheet, by selecting Office Button >> New. The option does
>NOT affect new worksheets created from the "new" template.
>Needless to say that setting is useless. Having to open a worksheet in
>order to CREATE A NEW worksheet is absolutely counterintuitive.
>
>As I said before, I create new worksheets from the "new" templates by
>righ-clicking and selecting new excel spreadsheet (logical). Unfortunately,
>the template always starts in Calibri (Body) 11 font, regardless of the
>setting in the options.
>

Thank you for the valuable info Gord.

I fixed the problem by creating a custom template using Tweak UI.

Btw, C:\Windows\ShellNew folder contains the Excel and PowerPoint templates,
but not the Word template. Do you know where I can find that one? I
searched the entire C: drive for .docx files but no template was found.

Thank you.

"Gord Dibben" wrote:

> The default workbook for Right-click>New>Microsoft Office Excel Worksheet is
> found in C:\Windows\ShellNew folder.
>
> Named EXCEL12.XLSX
>
> Replace this file by opening Excel first and creating a new workbook with
> the desired formatting.
>
> Save as to the name and path as above.
>
>
> Gord Dibben MS Excel MVP
>
>
> On Mon, 27 Apr 2009 19:53:01 -0700, JSF <(E-Mail Removed)>
> wrote:
>
> >Thank you for your suggestion, Susan.
> >
> >I am aware of that option and I've tried it before, only to find out that it
> >doesn't do the trick. This option ONLY affects new worksheets created from
> >WITHIN another worksheet, by selecting Office Button >> New. The option does
> >NOT affect new worksheets created from the "new" template.
> >Needless to say that setting is useless. Having to open a worksheet in
> >order to CREATE A NEW worksheet is absolutely counterintuitive.
> >
> >As I said before, I create new worksheets from the "new" templates by
> >righ-clicking and selecting new excel spreadsheet (logical). Unfortunately,
> >the template always starts in Calibri (Body) 11 font, regardless of the
> >setting in the options.
> >
>
>

Don't work much with Word so can't answer the question.


Gord

On Wed, 29 Apr 2009 22:38:04 -0700, JSF <(E-Mail Removed)>
wrote:

>Thank you for the valuable info Gord.
>
>I fixed the problem by creating a custom template using Tweak UI.
>
>Btw, C:\Windows\ShellNew folder contains the Excel and PowerPoint templates,
>but not the Word template. Do you know where I can find that one? I
>searched the entire C: drive for .docx files but no template was found.
>
>Thank you.
>
>"Gord Dibben" wrote:
>
>> The default workbook for Right-click>New>Microsoft Office Excel Worksheet is
>> found in C:\Windows\ShellNew folder.
>>
>> Named EXCEL12.XLSX
>>
>> Replace this file by opening Excel first and creating a new workbook with
>> the desired formatting.
>>
>> Save as to the name and path as above.
>>
>>
>> Gord Dibben MS Excel MVP
>>
>>
>> On Mon, 27 Apr 2009 19:53:01 -0700, JSF <(E-Mail Removed)>
>> wrote:
>>
>> >Thank you for your suggestion, Susan.
>> >
>> >I am aware of that option and I've tried it before, only to find out that it
>> >doesn't do the trick. This option ONLY affects new worksheets created from
>> >WITHIN another worksheet, by selecting Office Button >> New. The option does
>> >NOT affect new worksheets created from the "new" template.
>> >Needless to say that setting is useless. Having to open a worksheet in
>> >order to CREATE A NEW worksheet is absolutely counterintuitive.
>> >
>> >As I said before, I create new worksheets from the "new" templates by
>> >righ-clicking and selecting new excel spreadsheet (logical). Unfortunately,
>> >the template always starts in Calibri (Body) 11 font, regardless of the
>> >setting in the options.
>> >
>>
>>

It's called normal.dotm. To edit it:

Select the big round Office button

Select Open

Select Templates

Select (double-click) the Normal template

The Normal template should open. Make changes as you would to any Word
document. Any changes you make will be applied to all new documents. When
you’re done making changes to the Normal template, click Save on the Quick
Access toolbar.

--
Susan Ramlet
**please reply to the newsgroup so others may benefit**


"JSF" <(E-Mail Removed)> wrote in message
news:69249101-5AD5-4BCB-A7E7-(E-Mail Removed)...
> Thank you for the valuable info Gord.
>
> I fixed the problem by creating a custom template using Tweak UI.
>
> Btw, C:\Windows\ShellNew folder contains the Excel and PowerPoint
> templates,
> but not the Word template. Do you know where I can find that one? I
> searched the entire C: drive for .docx files but no template was found.
>
> Thank you.
>
> "Gord Dibben" wrote:
>
>> The default workbook for Right-click>New>Microsoft Office Excel Worksheet
>> is
>> found in C:\Windows\ShellNew folder.
>>
>> Named EXCEL12.XLSX
>>
>> Replace this file by opening Excel first and creating a new workbook with
>> the desired formatting.
>>
>> Save as to the name and path as above.
>>
>>
>> Gord Dibben MS Excel MVP
>>
>>
>> On Mon, 27 Apr 2009 19:53:01 -0700, JSF <(E-Mail Removed)>
>> wrote:
>>
>> >Thank you for your suggestion, Susan.
>> >
>> >I am aware of that option and I've tried it before, only to find out
>> >that it
>> >doesn't do the trick. This option ONLY affects new worksheets created
>> >from
>> >WITHIN another worksheet, by selecting Office Button >> New. The option
>> >does
>> >NOT affect new worksheets created from the "new" template.
>> >Needless to say that setting is useless. Having to open a worksheet in
>> >order to CREATE A NEW worksheet is absolutely counterintuitive.
>> >
>> >As I said before, I create new worksheets from the "new" templates by
>> >righ-clicking and selecting new excel spreadsheet (logical).
>> >Unfortunately,
>> >the template always starts in Calibri (Body) 11 font, regardless of the
>> >setting in the options.
>> >
>>
>>

[jn1480]

This is the first post I have found that finally answers the question of right-click new for default font - thank you!!

Only issue I found though...
You right-click, new excel worksheet, open and it finally gives me the correct default font and size.
However, if I then create a new sheet in this new file, it STILL defaults back to the Calibri 11.

I even set the default font in Office Button, Excel Options to Calibri 9, but no luck.

Help?
Thanks!