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

How to display the merge function "url" of a picture? 0
How to Select Multiple Emails using Surface Pen 0
Convert hyperlink function into hyperlink 4
using different sheets match string to specific work and enter that work in active 0
Hyperlink to the meat of a cell 4
Is there a function to extract the URL part of a hyperlink in another cell? 4
Insert Column, Keep Average range 1
series of formulas to get to one formula 0

Top