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

6 key areas of change for accountants and auditors

New accounting standards on revenue recognition, leases, and credit losses present implementation challenges. This independently-written report identifies the hurdles that accounting professionals face and provides tips for overcoming the challenges.

PODCAST

How tax reform will impact individual taxpayers

Amy Wang, a CPA who is a senior technical manager for tax advocacy at the AICPA, answers to some of the most common questions on how the new tax reform law will impact individual taxpayers.