New worksheets NOT default font size?

[Jason O]

Hi,

Just a quick question. I have my default font set at Verdana 12pt (in
Preferences-General), and new workbooks open with those settings ok.
However, when I then add a new worksheet to the workbook, the font in the
new sheet is 10pt (with the concomitant row height, which I find too small).

Am I missing something? Why isn't the font size in added sheets the same as
my specified standard?

Any help greatly appreciated.


Cheers,

Jason
___
*Replace .invalid with .com for replies*

 

[JE McGimpsey]

Hi,

Just a quick question. I have my default font set at Verdana 12pt (in
Preferences-General), and new workbooks open with those settings ok.
However, when I then add a new worksheet to the workbook, the font in the
new sheet is 10pt (with the concomitant row height, which I find too small).

Am I missing something? Why isn't the font size in added sheets the same as
my specified standard?

Any help greatly appreciated.

First, I assume you closed and reopened XL first...

Second, do you have a workbook named "Sheet" in your startup folder? If
so, this will be used as a template for inserted sheets.

 

[Jason O]

First, I assume you closed and reopened XL first...

Second, do you have a workbook named "Sheet" in your startup folder? If
so, this will be used as a template for inserted sheets.

Thanks. Yes I have closed & reopened, and I have checked the startup folder
& the only thing in there is the personal macro workbook?

Could you suggest anything else?

TIA

Jason
___

 

[JE McGimpsey]

Yes I have closed & reopened, and I have checked the startup folder
& the only thing in there is the personal macro workbook?

Two more checks: do you have an alternate startup folder designated in
Preferences/General, and if so, do you have a workbook named "Sheet"? Do
you have a macro in Personal Macro Workbook that overrides the default
Insert/Worksheet command?

If not, it's something I've never encountered before, and my default
suggestion is to trash your XL preferences. Since you're using Entourage
2004, I'm assuming this applies to XL2004, so the preference file to
trash is

~:Libraryreferences:Microsoft:com.microsoft.Excel.prefs.plist

where ~ is your home directory.

 

[Jason O]

Two more checks: do you have an alternate startup folder designated in
Preferences/General, and if so, do you have a workbook named "Sheet"? Do
you have a macro in Personal Macro Workbook that overrides the default
Insert/Worksheet command?

If not, it's something I've never encountered before, and my default
suggestion is to trash your XL preferences. Since you're using Entourage
2004, I'm assuming this applies to XL2004, so the preference file to
trash is

~:Libraryreferences:Microsoft:com.microsoft.Excel.prefs.plist

where ~ is your home directory.

Thanks,

No alternate startup folder designated & no overriding macro in personal
macro workbook. So I deleted the prefs file & tried again:

New inserted sheets are now the correct font size, however if I add a new
sheet to a workbook which was first created under the old default font size,
then the new sheet is still the old size?...Does xl somehow remember the old
default font size that was in place when the workbook was first created?

TIA

Jason
___

 

[JE McGimpsey]

New inserted sheets are now the correct font size, however if I add a new
sheet to a workbook which was first created under the old default font size,
then the new sheet is still the old size?...Does xl somehow remember the old
default font size that was in place when the workbook was first created?

AFAIK, it shouldn't.

You can define a default worksheet to insert:

Create a one-worksheet workbook with all the formatting you want your
inserted sheets to have. Explicitly select all the cells and set the
font/size.

Save the workbook as a template, named "Sheet" (no quotes, no extension)
in the startup/alternate startup folder.