Hover pictures

By J. Carlton Collins, CPA

Q: I maintain an organizational chart in Excel, and I’d like to know if it is possible to have a picture of each employee pop up when I hover over his or her name?

A: Yes, you can add pop-up pictures in Excel 2013, 2010, 2007, and 2003 by inserting comments containing employee pictures, as follows:

1. In Excel, right-click on an employee’s name and, from the resulting pop-up menu, select Insert Comment.

2. Delete your username, which appears in the comment box.

3. Right-click on the edge of the comment box and select Format Comment. On the Color and Lines tab, select the Color dropdown menu and select Fill Effects as pictured below.

techqa-6


4. In the resulting Fill Effects dialog box, from the Picture tab, click the Select Picture option, browse to and select the desired picture, and click OK as pictured below.

techqa-7


5. Check the box labeled Lock picture aspect ratio, and then click OK, OK.

6. If the employee’s picture does not fit in the comment box, as is the case in picture 1 below, drag the grab handles to resize the resulting comment box until the picture fits. The result may produce a comment and picture that is too large, as is the case in picture 2 below. Hold the Shift key down and again drag the grab boxes to resize both the comment box and picture to the desired size, as shown in picture 3 below.

techqa-8


7. Repeat these steps for each name on your organizational chart, and the result will be an organizational chart that pops up the picture of each employee when you hover over his or her name.

J. Carlton Collins (carlton@asaresearch.com) is a technology consultant, a CPE instructor, and a JofA contributing editor.

Submit a question

Do you have technology questions for this column? Or, after reading an answer, do you have a better solution? Send them to jofatech@aicpa.org. We regret being unable to individually answer all submitted questions.

SPONSORED REPORT

How to make the most of a negotiation

Negotiators are made, not born. In this sponsored report, we cover strategies and tactics to help you head into 2017 ready to take on business deals, salary discussions and more.

VIDEO

Will the Affordable Care Act be repealed?

The results of the 2016 presidential election are likely to have a big impact on federal tax policy in the coming years. Eddie Adkins, CPA, a partner in the Washington National Tax Office at Grant Thornton, discusses what parts of the ACA might survive the repeal of most of the law.

QUIZ

News quiz: Scam email plagues tax professionals—again

Even as the IRS reported on success in reducing tax return identity theft in the 2016 season, the Service also warned tax professionals about yet another email phishing scam. See how much you know about recent news with this short quiz.