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.
Adding Multiple Email Hyperlinks in Excel 2003
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.
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.
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.
Step 7
Click on your cell and configure the shape.
Step 8
Type the email address into the text box.
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.
Adding Multiple Email Hyperlinks in Excel 2007
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.
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.
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.