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.
After hitting the New Note command, you’ll see a banner beside your selected cell.
❸ Just type your notes and that’s it.
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.
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.
Then the note that you’ve applied will show up. And you can add, cut, or update your note whatever you want.
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?
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.
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.
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.
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.
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.