How to Add Notes in Excel (The Ultimate Guide)

To add a note to a cell in your worksheet:

  • Select a cell.
  • Go to Review, then to Notes, and select New Note.

Add Notes in Excel

You’ll see a banner next to your selected cell.

  • Type your notes.

Add Notes in Excel

Excel allows you to add as many notes as you can. We’ve added two notes. The first one is in cell E5 and the second one is in cell E13.

Add Notes in Excel


Edit Attached Notes

  • Select the cell where you’ve already inserted notes.
  • Go to Review, then to Notes, and select Edit Note.

add and edit Notes in excel

  • You can add, cut, or update your notes however you want.

add notes in excel


Go from One Note to Another

  • Select a cell where you have already applied a note.
  • Go to Review and Notes.
  • If you want to go to the next note of your selected note, select the Next Note command.
  • To go back to the previous note, click on the Previous Note command.

Go from One Note to Another


Hide and Display Notes in Excel

If you want to show or hide a note:

  • Select the cell with a note.
  • Go to Review and select Notes.
  • Click on the Show/Hide Note command.

This will make your notes visible in the selected cell.

Add Notes in Excel

To show all notes:

  • Select Review, then Notes, and choose Show All Notes.

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.


Turn Notes into Comments

  • Select the cell with a note.
  • Go to Review and select Notes.
  • Select Convert to Comments.

Turn Notes into Comments in Excel

All your notes will be turned into Excel comments.


Remove Notes from an Excel Worksheet

  • Right-click on a cell with a note.
  • From the context menu, select the Delete Note command.

Remove Notes from an Excel Worksheet

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


Download the Practice Workbook


Notes in Excel: Knowledge Hub


<< Go Back to Notes in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Mrinmoy Roy
Mrinmoy Roy

Mrinmoy Roy, a dedicated professional with a BSc in Electronics and Communication Engineering from Khulna University of Engineering & Technology, Bangladesh, brings over two years of expertise to the ExcelDemy project. As a prolific contributor, he has authored around 180 articles, showcasing his deep knowledge and passion for Microsoft Excel, Data Analysis, and VBA. His unwavering commitment to continuous learning, combined with versatile skills, renders him well-suited for roles in data management and spreadsheet solutions. He has interest... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo