ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel
  • »
  • Technology»
  • Computers & Software

Computer Hyperlink - Excel, PowerPoint, Word

Updated on October 8, 2011

Understanding Hyperlinks

Microsoft Office is most widely used across the globe and has well established its brand by providing a wide variety of Applications that can be used at office as well as at home and by students. There are many features and functions available in its applications which can save u a lot of time and get your work done without much hassles. The added advantage is that the output is also very presentable.

"Hyperlink" is one of such features offered in the applications. Hyperlinks are a very useful tool in the Microsoft Office Suite and I would like to share some details on it.

What is Hyperlink?

Hyperlink is a feature that allows you to insert a link into your document (Excel/PowerPoint/Word), clicking which, will open the target Document / Web Page / Some place in the same document.

To make it simple, you can insert a link into your document. You can define the target which you want to open by clicking on that link. The target can be a web page (for example: http://www.91laws.blogspot.com). The target can also be some other document on your drive (for example: an Excel file on your computer). The target can also be some place in the same document in which you are inserting the hyperlink.

How does it work?

Hyperlink feature works similarly across all of the Microsoft Office Applications. Lets say for example you are working on a PowerPoint Presentation and you need to insert a hyperlink on slide number 3 to open a webpage (http://www.squidoo.com/free-hr-software-in-excel).

The set-up:

In order to make a hyper link work, you will need to put a trigger on your slide. This trigger will be the displayed on your slide. By clicking this trigger your target will open. Follow these steps to set-up your hyper link.

  1. On your slide number 3 at the bottom of the slide insert a text box and write these words: "Click here"
  2. Now select the text (not the text box) and right click on it.
  3. Select Hyperlink
  4. A dialogue box will open
  5. On the left side you can see under "Link to:" the option of "Existing File or Web Page" is already selected
  6. Now at the bottom there is a field named "Adress" and the cursor blinking next to it.
  7. Enter here, the full web page address that you want to open (for example:http://www.squidoo.com/free-hr-software-in-excel)
  8. Click OK and its done

Remember

  • When you are editing your PowerPoint Presentation, simply one click on trigger will not open the hyperlink. In order to test it, you will have to view slideshow and then click on it or else while in edit mode you can right-click on the trigger and select "Open Hyperlink" to test it.
  • If you do not want any TEXT as your trigger, you may also select an autoshape, an image, or a symbol as your trigger.
  • During your presentation when you open your hyper link and want to go back to the presentation, you may directly close the internet browser and you will be back to the slide show.
  • If you want some file on your computer to be your target then you must select it in the dialogue box instead of entering the web page address.
  • If you want to target some place in your document then on the left hand side of the dialogue box under "Link To: you must select "Place in this document" and you will be able to see list of slides in your presentation. Select the one you want and click OK

Why my hyperlink did not work on other computer?

There may be times when you need to prepare presentation on you computer and then show it in another computer. You may either carry your presentation to that computer in a pen drive, memory card or a disc or simply email it. When your presentation is saved it on that computer it will not open the target because the folder names and the "address" of the target is not same as your computer. To avoid these mishaps consider the following example: I am making this presentation named "Review Presentation.ppt" and in that presentation I want to hyper link a file named "Sales Data.xls" which is on my computer. Now I will open a folder on my desktop named "XYZ" and put "Review Presentation.ppt" in it. In "XYZ" folder I will create another folder named "Targets" and put "Sales Data.xls" in it. If I have some more target to be opened, I will put them all in the folder named "Targets". Now I will create Hyper Links in my presentation with the method mentioned above. Once when I am done, I will Simply SAVE my presentation file first and then exit it after which I will Select the folder "XYZ" and compress/zip it so that it can be sent in email or carried in a pen drive as 1 single attachment or file. Now when i save it in other computer, it will function properly as it should. Thanks to Microsoft for keeping things simple!! lol :)

I will be soon updating this hub for some stuff on "Fun With Hyperlinks" please keep checking in.

If you need any help on this topic, One is glad to be at service :) Post comments or contact me through hubpages. Thanks Hub Pages, Thanks Microsoft and Thanks to you guys for reading my hub. Good Day!

Comments

    0 of 8192 characters used
    Post Comment

    No comments yet.

    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)