How to Insert Comment and Note in Excel

How to Insert Comment and Note in Excel

In this tutorial, you’ll see how to insert and use comments in Excel. Thanks to this function, you’ll be able to communicate effectively with other users who are working in the same spreadsheet. We’ll also be talking about how to add and use Excel notes.

Shall we start?

See the video tutorial and transcription below:

See this video on YouTube:
https://www.youtube.com/watch?v=JYaIOnLG5c0

Let’s have a closer look at how to use comments and notes in Excel, today.

Comments are a great way to communicate with other users working within the same spreadsheet.

You can insert a comment by clicking on a cell, open the menu of options with a right-click and select ‘New Comment’.

How to Insert Comment and Note in Excel - how to adde comment in Excel

You’ll see a window with a field where you can type in your text and start a conversation with other users.

[‘John, could you please provide an update?’]

How to Insert Comment and Note in Excel - How to add comment in Excel

The conversation has started now and the users can carry on – create a thread like this one.

[‘Done’]

How to Insert Comment and Note in Excel - How to add note in Excel

Each cell where a comment has been added shows a purple comment indicator, which you can see in the top right-hand corner.

How to Insert Comment and Note in Excel - how do I see where comment is in Excel table

Any of the comments you inserted can be edited or deleted.

How to Insert Comment and Note in Excel - How to edit comment in Excel
How to Insert Comment and Note in Excel - How to delete comment in Excel

The whole thread can also be marked as solved through the option ‘Resolve thread’, or you can remove the whole conversation completely.

How to Insert Comment and Note in Excel - How to resolve thread
How to Insert Comment and Note in Excel - How to delete conversation in Excel

Now, let’s insert one more comment and have a quick look at some more advanced options you can use when working with comments.

How to Insert Comment and Note in Excel - Adding of comment in Excel

Click on the ‘Review’ tab and find the section ‘Comments’, where you can click through multiple comments using the options ‘Previous Comment’ and ‘Next Comment’.

 If you want to have all comments displayed in one place, click on ‘Show Comments’

How to Insert Comment and Note in Excel - How to show comment in Excel

and they’ll appear along with the whole threads listed in the ‘Comments’ pane on the right.

How to Insert Comment and Note in Excel - add comment in Excel

Great! Now we’ll take some time to go through Excel notes in more detail.

Notes come quite handy when all you need to do is just add a short annotation about specific data within a table.

Remember how to insert a comment? Inserting a note works the same way. Click on the relevant cell in the sheet, right-click and select ‘New Note’.

How to Insert Comment and Note in Excel - How to enter new note in Excel

A window opens where you can enter the note.

[‘Waiting for update’]

A note is usually marked by a small red triangle in the upper right-hand corner of the cell, so it’s easy to tell whether there’s a comment or a note.

How to Insert Comment and Note in Excel - Adding of note in Excel

Of course, you can give your note any look you want through formatting options. Hover over the bottom right-hand corner of the note until a black cross made of double arrows turns up. Then use the right mouse button to select ‘Format Comment’.

How to Insert Comment and Note in Excel - How to format comment in Excel

You’ll see all formatting options and apart from changing the type and the size of the font, you can change the background colour in the tab ‘Colors and Lines’ and pick, for example, this blue.

How to Insert Comment and Note in Excel - How to change colour of the comment in Excel

Now click on OK to see the colour you’ve chosen in the background!

How to Insert Comment and Note in Excel - colouring of the comment in Excel

To edit the note, click on the cell again and through a right-click, select ‘Edit Note’.

How to Insert Comment and Note in Excel - How to edit note in excel

This will allow you to modify the text of the note.

How to Insert Comment and Note in Excel - How to adjust note in Excel

And before we wrap it all up, there are a couple more things worth mentioning.

Just as with comments, there are multiple functions available on the Ribbon that you can use with notes, too. Click on ‘Notes’ and you’ll be able to insert a new note, click through already existing notes, show all notes or even convert them into comments.

How to Insert Comment and Note in Excel -how can I edit notes in Excel

So, which one do you think you’ll be using more – comments or notes? Make sure you’ll leave a comment below!

Don’t miss out a great opportunity to learn:

If you found this tutorial helpful, give us a like and watch other video tutorials by EasyClick Academy. Learn how to use Excel in a quick and easy way!

Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers!

Thanks for watching and I’ll see you in the next tutorial!

Comments

Add comment

Your email address will not be published. Required fields are marked *

Your personal information will only be used for the purpose of processing this comment.