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

Revenue recognition: A complex effort

Implementing the new standard requires careful judgment. Learn how to make significant accounting judgments and document them and collaborate with peers for consistent application.

VIDEO

How to Excel pivot a general ledger

The general ledger is a vast historical data archive of your company's financial activities, including revenue, expenses, adjustments, and account balances. J. Carlton Collins, CPA, shows how to prepare data for, and mine data with, PivotTables.

QUIZ

News quiz: Taking an economic snapshot and looking to the future

Recent news included IRS actions that affect individuals and partnerships and a possibly influential move by a Big Four accounting firm.Take this short quiz to see how much you know about the news.