Excel 2007 default font

[Stu]

Am I missing something? Is there no way in Options to change the default font
& size, permanently, for every spreadsheet or workbook that you open, without
preparing a template? I personally like Arial 11. Who selected Calibri 11 as
the default?

 

[T. Valko]

You're welcome. Thanks for the feedback!

 

[Kamlesh]

Biff,

This works well for new files which we create by opening MS Excel.

But if we right click on Windows Explorer and create a new excel worksheet,
then open it (dbl click), then the changed font is not being applied.

Do you have any trick to fix this?

Regards,
Kamlesh

 

[T. Valko]

Hmmm...

Yes, I see that.

I never create new files in that manner so I'm not sure how you'd correct
that. You might have to create a new default Book.xltx template.

 

[Gord Dibben]

When in Explorer and right-click New>Microsoft Office Excel 2007 Workbook.

C:\Windows\SHELLNEW\Excel12.xlsx is the workbook that opens.

Open it and make your changes to that workbook.

Save.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Biff

See my reply to OP.


Gord

 

[T. Valko]

I never knew this!

Thanks, Gord!

 

[Gord Dibben]

Welcome.

Has been around for years as Excel9.xls

Since installing 2007 I see I now have both files in shellnew.


Gord

 

[Kamlesh]

Gord, thats fantastic. It works! Thanks for your inputs.
You are awesome.

Regards,
Kamlesh

 

[Gord Dibben]

Thanks for the feedback.

Don't forget to keep a BOOK.XLTX in your xlstart folder for opening a new
workbook from within Excel


Gord

 

[Kamlesh Rao]

What does "OP" mean?

 

[Dave Peterson]

Original poster or original post.

What does "OP" mean?