Hi Kevs:
it's just way to convouted. I'm going to run some complex thing and have to
keep and old column and hide it?
"=HYPERLINK(A1)"; and fill down!" is too complicated? Hmmm...
There is an interesting idea gathering pace among computer users that "You
do not have to learn anything to use a computer."
It's not true. It never has been, and it never will be. No matter what
software you use, at the very least, the user needs to have a clear
understanding of the result they want.
There are two kinds of software made these days: "Simple", and
"Professional". Simple software is designed to do one thing, and do it with
a minimum of input or knowledge. It requires that the user works exactly
the way the designer intended, and gives them only the result the designer
envisaged. If they want anything else: sorry!
Microsoft Excel is the Nikon D3x of spreadsheets. With it, you can get any
result you want. But you need to invest some time and effort to learn how.
Or pay someone to do it for you.
While family happy-snappers "can" point a Nikon D3x and maybe get a picture,
it's not the appropriate tool for them. Whereas you can guarantee a result,
on a budget, by a delivery date, every time. If you get to the venue and
things are not exactly what you hoped for, the Nikon gives you what you need
to bring the result back, despite the problems.
There are some photographers for whom the Nikon CoolPix L110 is a more
appropriate tool (although I know at least one wedding photographer who
keeps one in in his toolkit, just in case...)
Microsoft Excel is the same deal. It's the high end, and it rewards study,
planning, and effort.
For crying out loud I just want to make all emails in a single column a live
link.
I was expected a quick fix: select the column and click command K.
The fix I gave you is indeed that simple.
1) I do them one at a time: I select the cell double click hit return and the
link goes live. But in this workbook, I've never seen this before:
the email goes from 21 pt font to 10 pt font. what is this?
I already answered that:
Because the Autocorrect function applies the style "Hyperlink" to the
Hyperlink you created. Go into Format>Style if you want to change it.
2) and why are they not live links? How to prevent this from happening in
future? I just did a test and it seems by default excel make an email live
after entering it in, How did these not become live? I have interns enter this
data, what did they do in that some are live, some are not live?
Excel>Preferences>AutoCorrect "Replace internet and network paths with
hyperlinks". If you want the automatic tools to work, you need to switch
them on.
As you well know, Interns are Interns because they do not yet know
everything. Although some may be convinced that they do!
Perhaps you ought to throw this sheet back to the person who entered the
data and tell them "It's not enough to get it to look right, for people to
be able to use your work in the future, it must BE right." That's an
important lesson that every Intern must learn sometime: the sooner the
better, if they are going to work for you
Cheers
--
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]