Font size question

K

kevs14

Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel A workbook was all 10pt font was changed to all 14 pt font.
Only weird thing is, when I type in a new email, it goes to 10pt. (why?)
What to I do? thanks!
 
J

John McGhie

Hi Kevs:

Until you tell me which program you are using, I haven't a clue.

Excel has nothing to do with email.

Cheers


Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
A workbook was all 10pt font was changed to all 14 pt font.
Only weird thing is, when I type in a new email, it goes to 10pt. (why?)
What to I do? thanks!

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]
 
K

kevs14

John,
it's all excel, what I'm saying is the whole workbook one size font.
I select the workbook and change the font but the cells in the email columns remain the old font size.
 
J

John McGhie

The cells in any column containing a Hyperlink or email address are
controlled by the formatting you have defined in your "Hyperlink" style.

See Format>Style...

Cheers

John,
it's all excel, what I'm saying is the whole workbook one size font.
I select the workbook and change the font but the cells in the email columns
remain the old font size.

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]
 
K

kevs14

John,
what happens, whole document is verdana 21.
and in email columns its verdana 21 until I type a new one and hit return key. The minute I hit return key it shoots to 10.
I clicked format style, changed to 21, did not help.
Did not see a "hyperlink" style.
WHERE do you see in that little box hyperlink style? thanks!
 
J

John McGhie

Hi Kevs:

Where I said: Format>Style... It appears that in Excel 2004 you have to
have one of the cells with a hyperlink it it selected to see the Hyperlink
style.

Cheers


John,
what happens, whole document is verdana 21.
and in email columns its verdana 21 until I type a new one and hit return key.
The minute I hit return key it shoots to 10.
I clicked format style, changed to 21, did not help.
Did not see a "hyperlink" style.
WHERE do you see in that little box hyperlink style? thanks!

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]
 
K

kevs14

John,
this is not helping at all.
Whether or not I have the cell selected or not I get this:
http://tinypic.com/r/fqd85/5
This box does not help in any way shape or form.
http://tinypic.com/r/fqd85/5
Very frustrated on this one-- and you are a genius.

Again:
I have a column of emails. -- 20pt font
But for some crazy bizarre reason, when I delete someone email, and enter a new email into a cell, the second I click return it becomes microsopic 10pt. yet nothing in my workbook is 10pt. it's baffling.
 
J

John McGhie

Are you dropping down the list where it says "Normal"???


John,
this is not helping at all.
Whether or not I have the cell selected or not I get this:
http://tinypic.com/r/fqd85/5
This box does not help in any way shape or form.
http://tinypic.com/r/fqd85/5
Very frustrated on this one-- and you are a genius.

Again:
I have a column of emails. -- 20pt font
But for some crazy bizarre reason, when I delete someone email, and enter a
new email into a cell, the second I click return it becomes microsopic 10pt.
yet nothing in my workbook is 10pt. it's baffling.

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]
 
C

CyberTaz

Select a cell that already is displaying a hyperlink in it, *not* an empty
cell you want to reformat. When you go to Format> Style the box will read as
'Hyperlink' rather than 'Normal' -- Click the 'Modify' button & change the
Font formatting to whatever you please.

One thing to keep in mind, though, is that customized styles are
workbook-specific.

Regards |:>)
Bob Jones
[MVP] Office:Mac
 
K

kevs14

Bob, sorry for delay, problem with Mactopia emai notification not working.
But Bob, I have column of hudreds of cells. For some reason, when I change even one letter, it changes to 10pt from 16 pt.

Maybe I need to make a video, its not penetrating here.
 
C

CyberTaz

There is no need for a 'video' unless you simply have no better use for your
time, but what do you mean by "... Its not penetrating here"? *What* isn't
penetrating *where*? Have you done as I suggested in my last reply?

The formatting of every cell that contains a hyperlink is controlled by the
Hyperlink Style. If you modify that style the formatting of every existing
hyperlink in the workbook will change automatically & any new hyperlinks
will also be formatted according to how the style is defined.

Regards |:>)
Bob Jones
[MVP] Office:Mac
 
K

kevs14

Excellent Bob,
my question now:
This column of 5000 cells.
Do I have to do this one at a time?
 
J

John McGhie

Hi Kevs:

No, Bob has suggested that you change the font size of the Hyperlink style,
and told you very specifically how to do that.

If you had tried doing exactly as he says, you would have changed all 5,000
cells three weeks ago :)

Maybe you missed it in all the smoke and mirrors, but Microsoft Office is
increasingly using "Styles" for formatting. A style is simply a collection
of formatting properties: font, size, colour, alignment, etc; to which you
give a name.

This makes it much easier for humans to format stuff quickly and
consistently: apply the correct style name, and the formatting is correct:
you do not have to look, think, or worry about formatting.

However, it is also vastly more efficient for programs, too. Excel and Word
have been using styles for formatting for 20 years. All formatting in the
modern versions is a style, even if it appear that it isn't. If you do not
assign a name to the style, Excel will create one behind the scenes: but the
formatting is always a style.

In the case of hyperlinks, the Hyperlink style is applied automatically to
any text Excel thinks is an internet address. That's what makes it a
hyperlink. It's also what sets its font size.

Excel's style editing mechanism is so crude even its mother would burst into
tears. The reason you have to do this exactly the way Bob said is because
otherwise, Excel may not let you see the style.

Cheers


Excellent Bob,
my question now:
This column of 5000 cells.
Do I have to do this one at a time?

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]
 
C

CyberTaz

Why not try the suggestion & find out rather than nay-saying? Did you even
read my last reply? I don't know of a term more explicit than "every".

Regards |:>)
Bob Jones
[MVP] Office:Mac
 
K

kevs14

Great post/ insights John!
Bob, my apologies, I underestimated that. It indeed worked for one cell, I completely assumed it would not effect anything other than that one cell. great tip!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top