To place links in cells that enable you to load other documents with one click, enter a name for the link in a cell and press [Ctrl] + [K]. You have four options to allow a cell link to:

  • Existing File or Web Page allows you to link to existing file or open a web page.
  • Place in this document allows you to link to specific sheet or defined ranged name.
  • Create new document allows you to create and link with a new document.
  • Email Address allows you to send an email with specified email address and Subject.

You may also like to check out:

Example

You want to send an email on click of particular cell, Just select the cell and Press [Ctrl] + [K] to specify Email address and subject and click Ok.

How to Create Hyperlinks to support files in Microsoft Excel 2010