How to Add Two Email Hyperlinks to One Cell in Excel

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 email 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.

Woman with a laptop computer
credit: Pixland/Pixland/Getty Images

Adding Multiple Email Hyperlinks in Excel 2003

Step

Launch the Microsoft Excel 2003 application.

Step

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

Step

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.

Step

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

Step

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

Step

Select the text box from the bottom toolbar.

Step

Click on your cell and configure the shape.

Step

Type the email address into the text box.

Step

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

Adding Multiple Email Hyperlinks in Excel 2007

Step

Launch the Microsoft Excel 2007 application.

Step

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

Step

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.

Step

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.

Step

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