Changing default font size

R

Richard Evans

I have an Excel 2003 spreadhseet in which I want the defaul font size
to be 12 points. The Help text says:

Tools > Options > General > Standard Font Size 12

I did that, got a message to quit and reopen the file for the change
to take effect, but when I reopened it it was still 10 points.

Then I read elsewhere on this group that that only changes the default
for future worksheets, but not the current one. That didn't work
either. I created a new worksheet and it too was still 10 points.

What's the deal?
 
A

Anne Troy

got a message to quit and reopen the file for the change....

Change the default font.
Say OK to the message (by the way, the message is "For your changes to the
standard font to take effect, you must quit and then restart Microsoft
Excel"--not just the workbook).
Quit Excel.
Open Excel.
What's the default font?
Worked for me in Excel 2003.
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
 
R

Richard Evans

Anne Troy said:
Change the default font.
Say OK to the message (by the way, the message is "For your changes to the
standard font to take effect, you must quit and then restart Microsoft
Excel"--not just the workbook).
Click to expand...

Yes, that's what I did.
Quit Excel.
Open Excel.
What's the default font?
Click to expand...

What do you mean by this? Is this a question I should have seen upon
restarting Excel? If you are asking me what the default font is, it's
still 10 points.
Worked for me in Excel 2003.
****************************
Click to expand...

Not for me.
 
B

Beege

Richard said:
Yes, that's what I did.


What do you mean by this? Is this a question I should have seen upon
restarting Excel? If you are asking me what the default font is, it's
still 10 points.


Not for me.
Click to expand...

Richard,

Change default font.
SAVE and exit.
Re-open your workbook.

Does this work?

Beege
 
R

Richard Evans

Beege said:
Change default font.
SAVE and exit.
Re-open your workbook.

Does this work?
Click to expand...


Nope. FWIW, if in the reopened file I go back to the General tab, the
font size there shows 12 point. However, the font box in the toolbar
shows 10 point and any text I type is 10 point.
 
B

Beege

Richard said:
Nope. FWIW, if in the reopened file I go back to the General tab, the
font size there shows 12 point. However, the font box in the toolbar
shows 10 point and any text I type is 10 point.
Click to expand...

Richard,

OK then, the sheets are formatted for 10 point, as the default was 10
when the sheet was created. You'll have to select all cells, each sheet,
and change to 12.
New sheets should "default" to 12 now ( that doesn't include any blank
sheets you already have)


Just curious... why do you need to change the font size?

Beege
 
R

Richard Evans

Beege said:
OK then, the sheets are formatted for 10 point, as the default was 10
when the sheet was created. You'll have to select all cells, each sheet,
and change to 12.
Click to expand...

OK, that works. All text becomes 12 point and any new text is entered
as 12 point.

Just curious... why do you need to change the font size?
Click to expand...

To make it easier to read. It's getting increasingly difficult for me
to read small text. I use the magnification features on my mouse a lot
and I routinely work in larger fonts whenever possible.

Yes, I know I could change the magnification level, but that doesn't
change the printed size.
 
Top