How to Pass the Contents of a Cell in Excel to an Email

Email and cloud-based apps enable you to collaborate online rather than in person.
... Jacob Wackerhausen/iStock/Getty Images

If you want to email someone the contents of a single Excel worksheet cell, you don't have to send the entire file as an attachment. Instead, you can use Excel's Hyperlink function to launch your email application, address the message and include the contents of one or more cells with a single mouse click. An even simpler way to pass worksheet data by email is the old-fashioned, copy and paste method.

1 Excel Hyperlink Function

2 Click an empty worksheet cell

Click an empty worksheet cell that will contain the email Hyperlink function.

The
... Courtesy Microsoft

Type the Hyperlink function formula to email a worksheet cell. The formula should contain at least the recipient's email address and the cell that contains the data you want to pass. In addition, you can add a subject for your message. The final Hyperlink function argument is an optional "friendly" name for the link itself. If you omit the friendly name, however, Excel will display the contents of the formula instead as a hyperlink instead. For example, if the email address is "[email protected]," your subject is "My Excel Data," your data is in cell H1 and your “friendly” name is “Send Data From Cell Above," your formula will resemble the following:

\=HYPERLINK("mailto:[email protected]?&subject=My Excel Data&body="&H1,"Send Data From Cell Above")

Click "Enter" to accept the formula.

Mail is the default Windows 8 email application.
... Courtesy Microsoft

Click the friendly name or email hyperlink to send your message using your system's default email application.

3 Copy and Paste Method

Select the Excel worksheet cell containing the data you want to send.

Press "Ctrl-C" to copy the cell's content to your clipboard.

Launch your email application, click your mouse within the body or message section and then press "Ctrl-V" to paste the worksheet cell contents into the email.

  • Information in this article applies to Excel 2013. It may vary slightly or significantly with other versions of Excel.

Allen Bethea has written articles on programming, web design,operating systems and computer hardware since 2002. He holds a Bachelor of Science from UNC-Chapel Hill and AAS degrees in office technology, mechanical engineering/drafting and internet technology. Allen has extensive experience with desktop and system software for both Windows and Linux operating systems.

×