Comments in Excel can be used to describe different cells in a worksheet, without changing their contents. You can use comments in many different situations, such as: asking a question, drawing attention or informing about a mistake.
There are three different ways you can use to add comments in Excel 2013:
- REVIEW >> Comments >> New Comment.
- Right-click a cell and choose Insert Comment.
- Use the Shift + F2 keyboard shortcut.
After you choose one of these methods, Excel will insert a new box. At the top of it, you will find your name (which you can delete) and the place to insert your text.
To exit the edit mode, click any cell or press the Esc key twice. The Cell containing a comment will be marked with a small red triangle in the upper right corner.
If you want to edit a comment that already exists, go to REVIEW >> Comments >> Edit Comment or use the Shift + F2 keyboard shortcut.
Showing and hiding comments
In order to preview comment, hover your cursor over the cell that contains a comment. If you want comments to be constantly visible, go to REVIEW >> Comments >> Show/Hide Comment. In order to do the same for all comments at once, choose the Show All Comments button.
Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.