Thread: how do i get all url's in a column to highlight?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default how do i get all url's in a column to highlight?
If your URLs are in column A, then in B1 enter:

=HYPERLINK(A1) and copy down to make a nice clickable list
--
Gary''s Student - gsnu200782


"Nick Riffbroker" wrote:

I made a database of press and radio contacts for my record label. In one
column i list contacts websites. Only some of the url's pasted in are
highlighted and clickable. How do I make all of them clickable?
Reply With QuoteReply With Quote