Use an adjacent column with a formula like:

=hyperlink(a1)
or
=hyperlink("mailto:" & a1)

Depending on what's in those cells.

Zoya wrote:

i have a database of e- mail ID's, and want to hyperlink the entire column so
that when I click on the ID, the Mail window opens. Can anyone help me how to
do that? and can the whole column of 2000 Mail IDs can be hyperlinked at a
time?

--

Dave Peterson