DW Faisalabad New Version

DW Faisalabad New Version
Please Jump to New Version
  • Working with Tables
  • While there are four types of database objects in Access, tables are arguably the most ... read more

    Friday, 30 June 2017

    Hyperlinks

     Existing File or Web Page  |  Place in This Document

    To create a hyperlink in Excel, execute the following steps.

    1. On the Insert tab, in the Links group, click Hyperlink.



    The 'Insert Hyperlink' dialog box appears.


    Existing File or Web Page

    To create a link to an existing file or web page, execute the following steps.

    1a. To create a link to an existing Excel file, select a file (use the Look in drop-down list, if necessary).



    1b. To create a link to a web page, type the Text to display, the Address, and click OK.



    Result:



    Note: if you want to change the text that appears when you hover over the link, click ScreenTip.

    Place in This Document

    To create a link to a place in this document, execute the following steps.

    1. Click 'Place in This Document' under Link to.

    2. Type the Text to display, the cell reference, and click OK.



    Result:



    Note: if you want to change the text that appears when you hover over the link, click ScreenTip..