LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 22,906
Default how do I change default font type/size in excel?

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


Gord

On Wed, 29 Apr 2009 22:38:04 -0700, JSF
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-clickNewMicrosoft 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
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.




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change default link font size pl3453454 Excel Discussion (Misc queries) 1 April 4th 09 08:23 PM
How to change the default setting for font and size? Eric Excel Discussion (Misc queries) 5 May 13th 06 05:12 PM
How do I change default font size for comment boxes in Excel? Vormov Excel Discussion (Misc queries) 1 October 28th 05 09:33 PM
Change default font and size in Comments box in Excel. ArtieF Setting up and Configuration of Excel 3 September 19th 05 05:27 PM
How to change the default font and size of "comments"? ClayMcQ Excel Discussion (Misc queries) 1 January 7th 05 11:43 PM


All times are GMT +1. The time now is 08:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"