| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to add hyperlink a column of URLs using Ctrl+K
I have a column of 3000 URLs and a column of book titles associate to the ULRs.
I want to create the hyperlink of these URLs to the titles if I am using =HYPERLINK function, select on any sell, it shown the formula {=HYPERLINK(C3,B3)} in the function box If I am using Ctrl+K and paste the link, it will shown the title name directly in the function box. How shall I do this one shot for all 3000 titles? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Edit All Hyperlink URLs | Excel Discussion (Misc queries) | |||
| Excel 2007: Ctrl+PgUp or Ctrl+PgDn with Protected Sheets | Excel Discussion (Misc queries) | |||
| ???[Ctrl Space] does not highlight Column | Excel Worksheet Functions | |||
| activate column of URLs as hyperlinks | Excel Discussion (Misc queries) | |||
| ctrl-click hyperlink activation in excel | Excel Discussion (Misc queries) | |||
Threaded Mode
