How to add hyperlink a column of URLs using Ctrl+K

V

VCKW

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?
 
V

VCKW

This is not the solution I want.

Pasting the URL using Ctrl+K which create a hyperlink without showing the
URL in "fx" box, while using =HYPERLINK function to create a hyperlink, it
will show the formula in the "fx" box when you point to the cell.

I would like to have the Ctrl+K format, but I can only do it one by one
while I am having 3000 link to create.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is there a function to extract the URL part of a hyperlink in another cell? 4
Hyperlink to the meat of a cell 4
How do I create a hyperlink to a cell with the hyperlink function 2
how to hyperlink a column of fileserver addresses? 2
Excel Worksheet_change with 2 functions to insert date and hyperlink window 0
Hyperlink to another sheet within a workbook using formula 1
How to create a hyperlink to open a file with part of the name 4
How do I get Excel to automatically calculate the value of a hyper 2

Top