How to Add Two Email Hyperlinks to One Cell in Excel

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
Image Credit: Pixland/Pixland/Getty Images

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.

Advertisement

Video of the Day

Step 1

Launch the Microsoft Excel 2003 application.

Video of the Day

Step 2

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

Advertisement

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

Advertisement

Step 4

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

Step 5

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

Step 6

Select the text box from the bottom toolbar.

Advertisement

Step 7

Click on your cell and configure the shape.

Step 8

Type the email address into the text box.

Advertisement

Step 9

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

Advertisement

Step 1

Launch the Microsoft Excel 2007 application.

Step 2

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

Advertisement

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

Advertisement

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

Step 5

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.

Advertisement

Advertisement

references