Sorting with Hyperlinks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet that contains a column of URL links. When I sort on a different column of information, the links to not sort with the rest of the data...the URL letters change, but the link itself does not. Exampl

How can I get the links to sort with the rest of the data

JT
 
Are you sure you are selecting the whole range, INCLUDING the column with the
links when you do your sort.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
Seasons Greetings and Very Best wishes to all :-)
----------------------------------------------------------------------------



Jack said:
I have a spreadsheet that contains a column of URL links. When I sort on a
Click to expand...
different column of information, the links to not sort with the rest of the
data...the URL letters change, but the link itself does not. Example
 
Ken: Thanks for your reply.

Yes, I have selected the entire range of data but the actual link does not go with the link text.

Its got me baffled!

Jack
 
Are your links text inside the cells, or have you attached links to
images/objects sitting on top of cells?
 
Ken

I'm not sure exactly what you mean, but I simply typed the URL into the cell

I fyou would like I can send an abreviated copy of the file to you so you can see what I'm talking about

Jack
 
Back
Top