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?

Hi,

Copy the hyperlink formula to all the other 2,999 rows

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"VCKW" wrote in message
...
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?

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.