Excel Report Hyperlink to Url

Excel Report Hyperlink to Url 

In order to add a hyperlink in a excel column create a excel sheet first like below sample data.with first two columns only.

Now in third column we will add hyperlink to site URL>

first column have site Name Second Column has Site URL now on Third Column we want the Name of Site and clicking on any Name in third column will open the Site URL. 

This is simple by hyperlink formula in Excel

Select your third column 3 rd row which is empty first 

click on fx 

Write formula
=Hyperlink(B2,A2) 

B2 is the value field which is url and A2 is the Name which we want to display. Writing formula will Automatically generate the site name with hyperlink to site URL.

Just Drag the formula field to all 5 rows of 3 rd column by clicking on plus sign..

Some play around with Hyperlink function.

The second argument of hyperlink function is optional if you will not give any value to second argument
it will take the first argument name which is url name eg

=Hyperlink(B2) 

Then site URL =http://sqslandssrssolutions.blogspot.in

and you can specify any name in Second argument of Hyperlink function.
like in last row i have use the formula

=Hyperlink(B2,"G") 

That's why it is displaying G not the site Name in row 6 of 3 rd column.

Now click on any site name in 3rd column will navigate you to corresponding Address.