How to Add Two Email Hyperlinks to One Cell in Excel

Written by matthew burley
  • Share
  • Tweet
  • Share
  • Email

Microsoft Excel 2007 can be used for a variety of functions. Many individuals will use it as a way to calculate values based on different values inserted into cells, while others will use it as a structured way to store data. If you are one of the latter types of users, you may have encountered a situation where you needed to store e-mail hyperlinks within your spreadsheet. While many individuals will only need to include one hyperlink in each cell, others may require more than that. Fortunately, with the use of functions available within Excel, this is easily accomplished.

Skill level:
Moderately Easy

Other People Are Reading

Instructions

    Adding Multiple Email Hyperlinks in Excel 2003

  1. 1

    Launch the Microsoft Excel 2003 application.

  2. 2

    Create a new spreadsheet or open an existing sheet in which you wish to add the email hyperlinks.

  3. 3

    Configure the desired cell to a size that can easily accommodate two lines of text. This can be accomplished by clicking on the side of a row or column heading that you wish to expand and dragging it in the direction of expansion. For example, if you want to adjust cell B2, you would click on the right border of the column B heading and drag it to the right. The actual width will depend on the length of the email address. You would then click on the bottom border of the row 2 heading and drag it down. A height of 50 should easily accommodate two rows of text.

  4. 4

    Click the "View" option at the top of the screen.

  5. 5

    Choose the "Toolbars" option, then select the "Drawing" option.

  6. 6

    Select the text box from the bottom toolbar.

  7. 7

    Click on your cell and configure the shape.

  8. 8

    Type the email address into the text box.

  9. 9

    Repeat steps 7 and 8 for the second text box, making sure the boxes are not overlapping. Your e-mail hyperlinks will appear automatically.

    Adding Multiple Email Hyperlinks in Excel 2007

  1. 1

    Launch the Microsoft Excel 2007 application.

  2. 2

    Create a new spreadsheet or open an existing sheet in which to add the email hyperlinks.

  3. 3

    Configure the desired cell to a size that can easily accommodate two lines of text. This can be accomplished by clicking on the side of a row or column heading that you wish to expand and dragging it in the direction of expansion. For example, if you want to adjust cell B2, you would click on the right border of the column B heading and drag it to the right. The actual width will depend on the length of the email address. You would then click on the bottom border of the row 2 heading and drag it down. A height of 50 should easily accommodate two rows of text.

  4. 4

    Select the "Insert" tab, then click the "text box" option. Configure the shapes of the boxes within your cell so that they are not overlapping.

  5. 5

    Highlight each e-mail address, then right-click it and choose "Hyperlink." Click the "email address" option on the bottom-left and type in the email address.

Tips and warnings

  • This method can be used to insert more than two e-mail hyperlinks in one cell.
  • Note that clicking on the link will open a new message in your default mail application.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.