Make Excel Comments Less Intrusive

BY STANLEY ZAROWIN

In December 2003 we ran a brief item on adding comments to Excel cells and showed how to get rid of those little red triangles that clutter the worksheet. Pam Luedtke, a CPA from Middleton, Wisconsin, suggested another way: With your cursor in the cell in which you want to attach a comment, click on Data and Validation , bringing up the Data Validation box (see screenshot below).

Type your message under Input message and click on OK . The message next to the cell appears only when your cursor is in the cell.

Below is a comparison of the two methods. On the left is the Validation method; on the right is the conventional Insert Comment method.

 

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.