HOW TO INSERT HYPERLINK IN EXCEL?

Table of Contents

INTRODUCTION

When we create reports in Excel, we might need to create hyperlinks in our sheet for easy navigation of the user through our sheets.

“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. 

Hyperlinks make it very easy to navigate through the sheet itself or to reach any other link, websites, etc., or open any file too.

WHAT IS HYPERLINKING?

Have you ever visited any webpage where you click a word and you directly land on a new website?

This is a type of hyperlink. Similarly, we can create such hyperlinks to open any website or file from Excel.

CLICK ANYWHERE ON THIS LINE. IT IS A HYPERLINK.


The button for the insertion of hyperlink is located under the

INSERT TAB>LINKS>HYPERLINK

HYPERLINK BUTTON 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 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

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.