Sorting with Hyperlinks

J

Jack

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
 
K

Ken Wright

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
 
J

Jack Taylor

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
 
K

Ken Wright

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

Jack Taylor

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
 
K

Ken Wright

Go on then, Its Xmas - send it on down. :)

Take the NOSPAM bit out of my email address
 
Top