Creating hyperlinks in Excel


Q: My accounting software enables me to export my customer data to Excel, but the customers’ email addresses do not show up as clickable hyperlinks. I must edit each email address one at a time to delete the leading apostrophe to convert the text-based email address to clickable email addresses. Is there an easier way to do this?

A: Excel 2010, 2007, and 2003 provide a hyperlink function that converts text to a clickable hyperlink. In the example below, I entered =HYPERLINK(L2) in cell M2, which converts the text-based data in cell L2 into a clickable hyperlink. I then copied this formula (in cell M2) down to convert the other text-based email addresses to clickable email addresses.

Caution: Using the Copy, Paste Values commands to convert the =HYPERLINK formula to regular text removes the hyperlink.


Year-end tax planning strategies

Practitioners should consider the timing of income and deductions, avoiding the net investment income tax, donating to charity, and planning for retirement.


Effortless payroll service offerings

In this special focus report, experts explain how payroll providers can help CPAs help their clients. Sponsored by Paychex, Intuit, SurePayroll, ADP, BenefitMall and AccountantsWorld.


Return due dates changed in highway funding bill

The federal highway funding extension bill signed into law on July 31 contains several tax provisions, including changing the due dates for partnership, S corporation, and corporate tax returns.