Digital Web

All about Apple, Android, BlackBerry and Windows Phone

How to Add Comments in Microsoft Excel

How to Add Comments in Microsoft Excel? Cell comments display related information about the contents of a cell. They can serve as a reminder to yourself and they're a great way to share information with users and other developers.

You're probably already familiar with this feature and if you're like me, you've sprinkled your sheets with useful comments.
To do so, simply right-click a cell and start typing. Once you've inserted a comment, Excel displays a small red triangle in the cell's upper right corner. To view the comment, simply hover over the cell.

How to Add Comments in Microsoft Excel?
Cell comments aren't the only way to share relevant information about the contents of a cell. Did you know that you can insert a comment into a formula? Most likely, you'd use this feature to document a formula when the formula itself isn't clear. For instance, perhaps a formula is long or it references oddly-named ranges. Or, you might want to include a note about what the formula does or the type of data it should return.
How to Add Comments in Microsoft Excel

To add a comment to a formula, use the following form:
Formula + N("your comment") 
For instance, the following formula contains a note that explains the formula's purpose:
=($C2-$B2 + ($B2>$C2))-$D2+N("Returns the elapsed time between two time values")

In this particular formula, there's no way to tell what's going on, so the note adds valuable information to other users. Of course, users can easily see the formula's purpose by simply viewing the spreadsheet! Of more value, might be a note that shares the required data types, or even a development note that identifies the person who entered the formula, or perhaps the person who last modified the formula and why--if that information is relevant to other users in some way.

This feature begs for abuse though, so keep notes simple and relevant. The more notes you add, the less likely users are to pay attention to them.

This feature works in all versions of Excel.
You are reading How-to / Office with title How to Add Comments in Microsoft Excel. You can bookmartk the URL!
Posted by: Trito Hartono

No comment for "How to Add Comments in Microsoft Excel"

Post a Comment