Normally we use Ctrl+K to create a single Hyperlink, or Right-click on a cell and select Hyperlink.

If you need to create multiple hyperlinks, these methods would be very time consuming and painful.

Right-Click and Hyperlink

Right-Click and Hyperlink

 

We can instead use the function =HYPERLINK and create any number of hyperlinks in 1 shot.

 

Let’s say I am making a list of all my posts of this blog.

I need a list of all the Post titles, hyperlinked to their respective web pages.

Data structure

Data structure

 

=HYPERLINK ( link_location, friendly_name )

Link location = Select the cell that has the link of the web page.

Friendly name = Select the cell that has the Post title.

Make this formula for the 1st Post and copy the formula down to get all the links in 1 shot.

 

Hyperlink function used

Hyperlink function used