HOW TO INSERT HYPERLINK IN EXCEL?

“HYPERLINK” IS A TEXT OR ANY LINK WHICH WILL TAKE THE USER TO THAT PARTICULAR LOCATION AFTER CLICKING IT. THE LOCATION CAN BE ANY PARTICULAR AREA OF THE SAME PAGE OR ANY OTHER SITE ADDRESS. 

BUTTON LOCATION TO INSERT A HYPERLINK

The button for the insertion of hyperlink is located under the

INSERT TAB>LINKS>HYPERLINK

HYPERLINK BUTTON LOCATION

STEPS TO INSERT A HYPERLINK IN EXCEL FOR LOCAL FILE

STEPS:

  • Select the cell where link is to be created.
  • Click the button-HYPERLINK.
  • The dialog-box shown in the figure will open.
  • Enter the name of the link which you would see as per the picture.
  • Browse and select the link. We have linked a file with a name declared as “chipset driver”. Refer to picture.
  • Now when you would click the hyperlink “chipset driver”, it’ll directly open the file which you have linked with this text.
SETTING THE HYPERLINK FOR A LOCAL FILE

STEPS TO INSERT HYPERLINK FOR WEBSITE

SETTING THE HYPERLINK LOCATION

STEPS:

  • Select the cell where link is to be created.
  • Click the button-HYPERLINK.
  • The dialog-box shown in the figure will open.
  • Enter the link of the web address, you would see as per the picture.
  • Browse and select the link. We have linked a file with a name declared as “Go to Blog.gyankosh.net”. Refer to picture.
  • Now when you would click the hyperlink “Go to Blog.gyankosh.net”, it’ll directly open the website address in a browser.