my cells with email addresses ling me to the wrong ones

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BillT - 19 Jun 2006 21:51 GMT

After I data sorted the spreadsheet the email and web site cell's take me to
the wrong addresses. Its like the link stayed with the cell instaed of the
address.

Reply to this Message

Dave Peterson - 20 Jun 2006 03:10 GMT

Another reason to use the =hyperlink() worksheet function.

With the email addresses in column A:
=hyperlink("mailto:"&a1,"Click Me")

> After I data sorted the spreadsheet the email and web site cell's take me to
> the wrong addresses. Its like the link stayed with the cell instaed of the
> address.

Signature

Dave Peterson

Reply to this Message