PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

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
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.
HOW TO INSERT HYPERLINK
HYPERLINK DIALOG BOX

STEPS TO INSERT HYPERLINK FOR WEBSITE

INSERT HYPERLINK WEBSITE

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.

Leave a Reply

Your email address will not be published. Required fields are marked *

OTHER WAYS TO REACH THIS ARTICLE

  • HYPERLINK,HOW TO CONNECT TO OTHER POST, HOW TO CONNECT TO WEBSITE, HOW TO LINK YOUR PAGE TO OTHER PAGE, HOW TO OPEN A LOCAL FILE IN WEBSITE, HOW TO OPEN A FILE IN EXCEL, HYPERLINK IN EXCEL

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

gyankosh060309@gmail.com

Leave a Reply

Your email address will not be published. Required fields are marked *

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: