How to add comments in Excel
In 2019 Comments have changed! Comments can now be used for having a conversation or discussion with other users working on the same workbook.
This allows you and other users to reply back and forth in the workbook forming a comment thread you can always go back to read on. It’s like chatting in Excel. Awesome, right? 👍
To start a conversation 💬 with your co-workers in an Excel workbook, just add a comment. You can add a comment using the Standard Menu option. Here’s how.
- Click the cell you want to comment on.
- Click the Review Tab in the Excel Ribbon above.
- Click New Comment.
- Type your comment. You can also mention @someone to address this comment to them.
- Click the Post button or Press “Ctrl” + “Enter” to post.
You can’t see your comment, but it’s there👀
See that small purple comment icon in the upper right corner of the cell? It’s the sign that a comment has been inserted in that cell.
When you hover your mouse pointer in that cell, you will see your comment pop up.
Add a comment using the Right-click option
The second way is the fastest way ⚡ to add a comment without clicking on the Review tab. You can add a comment using the right-click menu option.
- Right-click the cell and choose “New Comment“
- Type your comment.
- Click “Post” or click outside the comment box when done.
See? It’s easy as 1-2-3!
You have started a conversation in that cell. Others can now reply to continue the discussion. They can right-click the cell and choose Reply to Comment.
You can also reply to the comment by resting your cursor on the threaded comments, then click on the Reply box.
Just as our conversations start with a simple “Hello”👋, start a conversation in Excel by adding a comment💬