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]