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.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


4 Suitable Examples of Creating and Editing Comments in Excel

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 create 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 utilize the reply option if multiple users are sharing the same file.

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

Read More: How to Reply to a Comment in Excel (3 Easy Ways)


Example 2: Editing Comments in Excel

After creating a comment sometimes we need to edit the comment 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

Read More: How to Add Comment in Excel (4 Handy Methods)


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.

Read More: [Solved!] Comments Are Not Displaying Properly in Excel


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 proper tools.

Steps:

  • First, select multiple cells which have comments inserted. Then, click the “Delete” option from the “Review” feature.

Remove Comments from Cells

Remove Comments from Cells

Read More: How to Remove Pop-up Comments in Excel (4 Suitable Ways)


Similar Readings


Add and Edit Notes in Excel

Although, users like to use notes instead of comments which is much handier. 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

Read More: How to Change Comment Color in Excel (3 Suitable Examples)


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.

Read More: How to Hide All Comments in Excel (3 Simple Methods)


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 (3 Suitable Ways)


Things to Remember

  • In order to add a note to a cell, you can use the keyboard shortcut- Shift+F2 key to creating a note inside the cell.

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, the ExcelDemy team, are always responsive to your queries. Stay tuned and keep learning.


Related Articles

Khan Muhammad Kawser

Khan Muhammad Kawser

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