While working in Microsoft Excel Sometimes we feel the need to create and edit comments so that other users can see and reply according to them. I also add comments while working so that I don’t forget to change or edit the dataset. It’s really helpful. Today in this article, I am sharing with you about creating and editing comments in Excel.
Creating and Editing Comments in Excel: 4 Examples
In the following, I have described 3 suitable examples of creating and editing comments in Excel.
Suppose we have a dataset of some Employee Names and their Sales month-wise. Now we are going to create and edit comments on our worksheet. Stay tuned!
Example 1: Creating a Comment for a Cell
To add a comment for a cell you can utilize the review option from the top ribbon in Excel. Follow the instructions below to create comments.
Steps:
- Above all, select any cell (D7) from the worksheet and press the “New Comment” option from the “Review” tab.
- Next, type your desired comment and press the “Post” icon to complete the creation of the comment.
- Finally, we have successfully created a comment in the selected cell. You can also reply to a comment in Excel when multiple users are sharing the same file.
Read More: How to Use Excel VBA to Add Comment to Cell
Example 2: Editing Comments in Excel
After creating a comment sometimes we need to edit the comment in Excel for further work. You can easily edit the comment if you want.
Steps:
- Simply, press the “Edit Comment” icon from the popped-up comment.
- Then type your desired comment and press “Post”.
- In summary, you will get the edited comment for the cell.
Example 3: Showing All Comments Using Review Option
Imagine you have added multiple comments in various cells. But whenever you want to watch the comments you need to put your mouse cursor over the cell which is a little bit irritating. For this, I am explaining a simple technique to show all the comments in all cells.
Steps:
- To start with, select all the cells in your worksheet and click the “Show Comment” icon from the “Review” tab.
- Thereafter, a right pan will appear displaying all the comments for working advantages.
Example 4: Removing Comments from Cells
Meanwhile, after a task is completed you will need to clean the worksheet by removing or deleting comments from all cells.
Suppose we have multiple comments on our worksheet. Now we will remove them with the proper tools.
Steps:
- First, select multiple cells that have comments inserted. Then, click the “Delete” option from the “Review” feature.
- Without any hesitation, you will see all the comments are removed. Simple isn’t it?
Add and Edit Notes in Excel
However, users like to use notes instead of comments which is much easier. But notes do have some limitations like other users can’t add replies to notes. On the contrary, multiple users have to edit and change the notes. Let’s begin our journey by adding and editing notes in an Excel worksheet.
Steps:
- Choose a cell (D6) and click the right button on the mouse to get the options list.
- Just press the “New Note” option to add a note.
- Within a blink of an eye, a note box will rise up. Write down your comment and that’s it, we have added a note with the cell.
- In order to edit the note similarly, click the right button of the mouse to have options.
- Now, choose “Edit Note” to continue.
- Thus, edit your note to change it.
Show All Notes in Excel
Alongside without moving your mouse to view comments click the show notes feature to get all the notes.
Here in this worksheet, we have multiple notes. Let’s visualize them together in the cell.
Steps:
- Presently, select the whole dataset and choose “Show All Notes” from the “Review” option.
- Hereafter, all the notes will pop up which was hidden.
Hide and Delete All Notes in Excel
Fortunately, we have the feature to hide and delete notes in Excel.
Steps:
- In the same fashion, choose all cells with comments in them and press the “Show All Notes”.
- As a result, all the notes will hide inside the cells. If we press the button again notes will appear again.
- Beneath, delete notes by selecting cells and hitting the right button of the mouse.
- In short, press the “Delete Note” feature to complete the task.
- As an output, you will see the notes are deleted.
Convert Notes to Comments
Once creating notes you might want to shift to comments for a better working experience. In Excel, you can achieve it with a single click. To do so-
Steps:
- Selecting cells go to the “Convert to Comments” feature from the “Notes” drop-down list.
- Specifically, the cells with notes will convert to comments within a blink. Simple isn’t it?
Read More: Convert Comments to Notes in Excel
Things to Remember
- In order to add a note to a cell, you can use the keyboard shortcut- Shift+F2 key to create a note inside the cell.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
Conclusion
In this article, I have tried to cover all the examples of creating and editing comments in Excel. Take a tour of the practice workbook and download the file to practice by yourself. I hope you find it helpful. Please inform us in the comment section about your experience. We are always responsive to your queries. Stay tuned and keep learning.