Creating and Editing Comments in Excel (4 Practical Examples)

Get FREE Advanced Excel Exercises with Solutions!

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.

Create a Comment for a Cell for creating and editing excel comments

  • 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.

Create a Comment for a Cell for creating and editing excel comments

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.

Edit Comments in Excel for creating and editing excel comments

  • Then type your desired comment and press “Post”.

  • In summary, you will get the edited comment for the cell.

Edit Comments in Excel for creating and editing excel comments


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.

Show All Comments

  • 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.

Remove Comments from Cells

  • Without any hesitation, you will see all the comments are removed. Simple isn’t it?

Remove Comments from Cells


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.

Add and Edit Notes

  • 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.

Add and Edit Notes

  • In order to edit the note similarly, click the right button of the mouse to have options.

  • Now, choose “Edit Note” to continue.

Add and Edit Notes

  • Thus, edit your note to change it.

Add and Edit Notes


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.

Show All Notes in Excel

Steps:

  • Presently, select the whole dataset and choose “Show All Notes” from the “Review” option.

Show All Notes in Excel

  • 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”.

Hide and Delete All Notes for Creating and Editing Comments in Excel

  • As a result, all the notes will hide inside the cells. If we press the button again notes will appear again.

Hide and Delete All Notes for Creating and Editing Comments in Excel

  • 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.

Hide and Delete All Notes for Creating and Editing Comments in Excel

  • 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.

Convert Notes to Comments for Creating and Editing Comments in Excel

  • Specifically, the cells with notes will convert to comments within a blink. Simple isn’t it?

Convert Notes to Comments for Creating and Editing Comments in Excel

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.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Kawser Ahmed
Kawser Ahmed

Hello! Welcome to my Excel blog! It took me some time to be a fan of Excel. But now I am a die-hard fan of MS Excel. I learn new ways of doing things with Excel and share them here. Not only a how-to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned! You can check out my courses at Udemy: udemy.com/user/exceldemy/

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo