Sorting messes up the hyperlinks

Question

I have Excel for Mac 2011 Version 14.5.2 (150604)  I have a simple sheet with some content (names, company name, email, etc).  Some of the content has a hyperlink associated with it. When I sort this sheet, the hyperlinks for a particular column (company name) are not 'attached' in the sort.

Simplistically, if I had the following columns

Company

CompanyA

CompanyB

with a hyperlink associated with both companies (CompanyA points to CompanyA's website, CompanyB point to CompanyB's website).  If I change the sort, the underlying hyperlinks aren't included in the sort, so

Company

CompanyB

CompanyA

Of course this messes up everything.  

Bug? Feature? Braindead user who missing some option?

thanks.

Answer 1

So you added a hyperlink to the cell, not added hyperlink text to another cell right? If so, you will be much better by adding the text for the URL hyperlink to an adjacent cell. Then they will sort properly.

Answer 2

Nope.

Multiple columns, just one shown in the example

The Company column contains text (the company name).  Each text cell has a hyperlink associated with it (the company's website).  If you hover your mouse over the CompanyA and CompanyB text in the original posting, you'll notice that there is a hyperlink associated with that text.  When I sort the table (again, it's multi-column, so I can't just sort on a single column), the text in the cell changes (it gets sorted), but the hyperlink at is associated with the text in that cell remains associated with the cell, not the text.  So CompanyA now has the hyperlink for CompanyB (in our simple example).

No separate column for the hyperlink, the hyperlink is associated with the text in the cell, but it appears that the hyperlink is attached to the cell, not to the text.

I'm not sure I can describe it better that I have already.

Answer 3

I am not sure what your data layout is. Is column A a company name, with column B containing a hyperlink to company A's web site? If so, then is the name of company B in the next row in column A with the hyperlink to company B's website in the same row but column B? And, what are you sorting on, the company name?

If the above is the case, then just select the necessary columns and rows and sort on the company name in column A. Is this not what you want?