| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i get all url's in a column to highlight?
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? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 255 Character limit when opening URL's, any way around it? | Excel Discussion (Misc queries) | |||
| highlight current row/column | Excel Discussion (Misc queries) | |||
| How do I highlight a column depending on other column value? | Excel Worksheet Functions | |||
| Row & column automatic highlight | Excel Discussion (Misc queries) | |||
| how to set highlight for row/column header | Excel Discussion (Misc queries) | |||
Linear Mode
