Put A Comment Into A Spreadsheet Formula


Q. I know I can add a comment to a cell by clicking on Comment under the Insert toolbar, but is there a way to embed a comment inside a formula? That way, I can explain to viewers what the formula represents without having all those little red triangles sprinkled throughout, making my spreadsheet look as if it has chickenpox. A. Well, there is a way to add a comment inside a formula (and yes, it’s hidden, except when you put your cursor over it), but there also is a way to get the “chickenpox” marks out of Comments . I’ll tell you how to do both.

Answering your immediate question, insert some numbers in a spreadsheet and then, when you write the formula that adds them up ( =SUM(D2:D4 ), attach the following to the end of the formula: +N(“Comments without chickenpox”) . So, for example, the complete formula might look this:

=SUM(D2:D4)+N(“Comments without chickenpox”).

Now, when you highlight the formula cell, the comment appears in the formula box under the toolbar.

You can achieve a similar result using the Comment function. To add a comment to a cell, click on Insert, Comment and type your comment into the balloon that appears. In Excel’s default setting, when you move the cursor off the cell, a small red triangle appears in the upper right-hand corner of the cell (see screenshot above).

When your cursor passes over the comment-embedded cell, the full comment appears in the balloon (see screenshot at left).

You can adjust the default setting so you can control how, or even whether, those red markers appear. To make the adjustment, go to Tools, Options and then click on the View tab.

Under Comments , you have three options: None (all signs of the comment are hidden), Comment indicator only (only the red triangle shows) and Comment & indicator (every comment and its marker shows).

SPONSORED REPORT

Year-end tax planning and what’s new for 2016

Practitioners need to consider several tax planning opportunities to review with their clients before the end of the year. This report offers strategies for individuals and businesses, as well as recent federal tax law changes affecting this year’s tax returns.

QUIZ

News quiz: IRS warning on cyberattacks and a change in pension rules

Once again, the IRS sounds the alarm about a threat from cyberthieves. See how much you know about this and other recent news with this short quiz.

CHECKLIST

Bolster your data defenses

As you weather the dog days of summer, it’s a good time to make sure your cybersecurity structure can stand up to the heat of external and internal threats. Here are six steps to help shore up your systems.