ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

How to Insert Hyperlinks in Microsoft Excel

Updated on May 5, 2012
This navigation control spreadsheet was created using hyperlinks. It links to external websites, documents on local drive and sections within the worksheet.
This navigation control spreadsheet was created using hyperlinks. It links to external websites, documents on local drive and sections within the worksheet. | Source

Why should I use hyperlinks within Microsoft Excel?

Microsoft Excel is a powerful tool, however with large files you can often have too much information, or no way of finding data quickly and easily. Hyperlinks allow you to assist navigation, link to other documents and sources and will enhance the usability of the spreadsheet.

Advanced options allow you to add hyperlinks to pictures. As an example you could create a spreadsheet that tracks the NFL results and tables - on each table you could use the teams logo and add a hyperlink that takes you to their main website.


What is a Hyperlink?

A hyperlink (often called a link) is a reference to data that the reader can click on and follow. The hyperlink can point to a document, a specific element of a document, a website and also can be used to create an email.

Other uses of hyperlink include:

  • Indexes
  • Footnotes
  • Tables of Content
  • Bibliogarphies
  • Glossaries

Hyperlinks are usually used on websites to navigate to different pages within the website, or to external websites, however they can be used within documents such as spreadsheets, word documents, books etc.

With clever use of links and hyperlinks you can quickly and easily create an intuitive navigation system within websites and documents especially if you use advanced techniques such as adding a hyeprlink to an image or other multimedia files.

Microsoft Hyperlink Quick Tips

Here are some quick tips for how to use Hyperlinks in Microsoft Excel:

  • Right click any worksheet cell for a sub-menu - this gives you a 'Hyperlink' option that brings up the main Hyperlink dialogue box.
  • Right click a picture )or any other object) for the same sub-menu - this allows you to associate a picture with a Hyperlink.
  • Simply type in a web URL into any cell and it will automatically create a Hyperlink

What types of hyperlink can I insert into Microsoft Excel?

  • Existing File or Web Page – you can create a hyperlink that opens an existing file (stored on your hard drive or network) or opens a web page in a browser.
  • Place within this document – you can use a hyperlink to move the cursor to a place within the spreadsheet – this is a great way of adding Menus to Excel.
  • New Document – you can create a new document, save it and automatically create a hyperlink to the new document.
  • Email Address – you can use a hyperlink that when clicked will open and create an ‘blank’ email with the address specified in the hyperlink.

How to create a hyperlink to an Existing File or Web Page.

The video below demonstrates how simple it is to add a hyperlink to a file you have saved on your hard-drive or to a website:

How to create a hyperlink that takes you to a place within the document

The video below demonstrates how to create a hyperlink that takes you to a different part of your spreadsheet - it is ideal for creating navigation menus within Microsoft Excel:

How to create a hyperlink that creates a new spreadsheet and links to it

The method below details how to create a hyperlink that will create a new worksheet and then automatically add a hyperlink in the original spreadsheet:

Step 1:

  • Use Insert Menu => Hyperlink

Setting up the name, description and 'pop-up' tip of the new file
Setting up the name, description and 'pop-up' tip of the new file | Source

Step 2:

  • Click OK
  • Create and save your new spreadsheet

Creating the new file with the original file still open
Creating the new file with the original file still open | Source

Step 3:

  • Save New File
  • Close New File

Saving new file
Saving new file | Source

When the file closes the hyperlink will be uploaded with the relevant save file information. The new file will open if you click the hyperlink.

How to create a hyperlink that opens an email message and populates the send to box

The method below details how to create a hyperlink that will create a email with a subject:

Step 1:

  • Use Insert Menu => Hyperlink

Setting up the email address, subject and 'pop-up' tip of the new file
Setting up the email address, subject and 'pop-up' tip of the new file | Source

Step 2:

  • Click OK

You have now setup a hyperlink that will send an email to the specified email address with the specified subject:


Click the hyperlink opens up a blank email and populates the 'send to' and 'subject'
Click the hyperlink opens up a blank email and populates the 'send to' and 'subject' | Source

Comments

    0 of 8192 characters used
    Post Comment

    • chrissieklinger profile image

      chrissieklinger 

      6 years ago from Pennsylvania

      I just love all the neat things you can do with Excel. This is such an easy to follow explanation; great job!

    • GoodLady profile image

      Penelope Hart 

      6 years ago from Rome, Italy

      Stunning looking informative information.

    • Just Ask Susan profile image

      Susan Zutautas 

      6 years ago from Ontario, Canada

      Very useful hub for anyone learning how to use Excel or for a refresher course.

    working

    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, hubpages.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: https://hubpages.com/privacy-policy#gdpr

    Show Details
    Necessary
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
    Features
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Marketing
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Statistics
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)