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
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
=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
