How to Add Notes in Excel (The Ultimate Guide)

The notes are attachments in Excel that helps to give hints about data used in an Excel worksheet. Notes are used to understand complex data tables in Excel. For example, when you save an Excel worksheet for future use, you can add notes to work on the worksheet without having any trouble. In this article, I will show you how to add notes in Excel. You will also learn to edit, show or hide, and even delete notes in Excel.


Download Practice Workbook

You can download the Excel file from the following link and practice along with it.


Add Notes to an Excel Worksheet

To add a note to a cell in your worksheet,

❶ Select a cell first.

❷ Then go to Review Notes New Note.

Add Notes in Excel

After hitting the New Note command, you’ll see a banner beside your selected cell.

❸ Just type your notes and that’s it.

Add Notes in Excel

Excel offers you to add as many notes as you can. For example, I’ve added two notes. The first one is in cell E5 and the second one is in cell E13.

Add Notes in Excel

Read More: How to Add Notes in Excel Formula (4 Effective Ways)


Edit Attached Notes

Editing your notes that you’ve already inserted is super easy.

All you need to do is,

❶ Select the cell first where you’ve already inserted notes.

❷ Then go to Review Notes Edit Note.

add and edit Notes in excel

Then the note that you’ve applied will show up. And you can add, cut, or update your note whatever you want.

add notes in excel

Read More: How Do I Stop My Notes from Moving in Excel (2 Useful Methods)


Go from One Note to Another

If you have multiple notes added, you may want to go from one note to another. Well, navigating between notes is so simple in Excel.

❶ Select a cell first where you have already applied a note.

❷ Then go to Review Notes.

Now, if you want to go to the next note of your selected note, just select the Next Note command.

To go back to the previous note, click on the Previous Note command. It’s so simple, right?

Go from One Note to Another


Hide & Display Notes in Excel

By default, the notes are remained hidden after you insert a note inside a cell. However, when you hover your mouse cursor over the cell where you’ve applied a note, that note becomes visible.

But if you want to show notes permanently, then

❶ Select the cell first.

❷ Go to Review Notes.

❸ Then click on the Show/Hide Note command.

This will make your notes visible in the select cell.

Add Notes in Excel

Suppose, you’ve applied multiple notes in multiple cells. Now you want to show them all. What can you do?

Well, it is very straightforward too.

Just select Review Notes Show All Notes.

After hitting the Show All Notes command, all the notes that you’ve applied will be visible.

Hide & Display Notes in Excel


Notes Vs Comments in Excel

The comments are more of a conversation thread in Excel. In the comment section, one user can reply to another. On the contrary, the notes are just static attachments. Notes are used to attach hints about data used in an Excel worksheet.

Read More: Difference Between Threaded Comments and Notes in Excel


Turn Notes into Comments

You can convert notes into comments. To convert the notes into comments,

❶ Select a cell first.

❷ Then go to Review Notes Convert to Comments.

Turn Notes into Comments in Excel

After hitting the Convert to Comments command, all your notes will be turned into Excel comments.

Read More: Convert Comments to Notes in Excel (3 Suitable Ways)


Remove Notes from an Excel Worksheet

Removing a note from an Excel worksheet just takes a moment.

All you need to do is,

❶ Right-click on a cell having a note.

❷ From the context menu, just select the Delete Note command.

Remove Notes from an Excel Worksheet

It will remove the note attached to the cell instantly.

You can repeat the process the remove all the notes from your Excel sheet.


Practice Section

You will get an Excel sheet like the following screenshot, at the end of the provided Excel file where you can practice all the methods discussed in this article.


Conclusion

To sum up, we have discussed how to add, edit and remove notes in Excel. And don’t hesitate to ask any questions in the comment section below. We will try to respond to all the relevant queries asap. And please visit our website ExcelDemy to explore more.


Related Articles

Mrinmoy

Mrinmoy

Hi! I'm Mrinmoy Roy. I'm an Excel and VBA content developer. I write blogs relating to Microsoft Excel on Exceldemy.com. I've completed my graduation in Electronics and Communication Engineering from Khulna University of Engineering & Technology. I've expertise in Excel functions, formulas, Pivot Table, Power Query, Visual Basic, etc. I write blogs to lessen people's hassles while working on Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo