In this article, we will explore how to add, copy, hide, remove notes, etc. in Excel. We will also learn to add pictures in notes and convert notes to comments.
Notes in Excel is a very useful feature that allows you to add information, provide instructions, or include explanations in the worksheet. Notes can be useful to help other viewers better understand a dataset. These can be used to guide the users and help them navigate through the worksheets easily. Moreover, if you need to explain something about a cell, dataset, or chart, notes come in handy.
Note: We have used Microsoft 365 to prepare this article. However, you can find all the features used in this article in other versions of Excel as well.
⏷Add Notes in Excel
⏵Apply Keyboard Shortcut
⏵Use New Note Option
⏵Insert Notes from Review Tab
⏷Edit Notes in Excel
⏵Move Between Notes
⏷Copy Notes in Other Cells
⏷Insert Picture in Notes
⏷Convert Notes to Comments
⏷Frequently Asked Questions
⏷Notes in Excel: Knowledge Hub
There are 3 ways to add notes in Excel: applying a keyboard shortcut, using the New Note option, and inserting from the Review tab.
Select the cell you want to add notes to and press Shift+F2 on your keyboard. As a result, a note will appear. You can write text as per your need in the note.
Right-click on cell E5 and select New Note.
As a result, a note will be added.
You can also insert notes from the Review tab. Select the cell and go to,
Review >> Notes >> New Note
This will add a new note to the cell.
We can edit an Excel note by changing its font, shape, and size, or by moving it.
First, right-click on the note and select Format Comment.
A dialog box will pop up. From there, you can change the Font, Font style, Size, etc. according to your requirements.
Select the note and click on the Change Shape icon from the Excel ribbon.
From there, click on any shape and the note will convert into that shape.
First of all, select the note you want to move or resize. Move your cursor to the note border or sizing handle.
Then you can move or resize the note by dragging your cursor.
If your worksheet is full of a large number of notes, it might be difficult to move from one note to another. To navigate through notes quickly, select any note and go to,
Review >> Notes >> Next Note
As a result, you will be able to move on to the next note. You can also click on Previous Note to move to the previous note.
- Select the cell with a note and press Ctrl+C to copy. Then select the cell where you want to copy the note.
- After that, press Ctrl+Alt+V on your keyboard. As a result, the Paste Special dialogue box will appear.
- Select Comments and Notes and click on OK.
- Consequently, the note will be copied to your desired cell.
- First, right-click on the note and go to Format Comment.
- Select the Colors and Lines tab and click on the Color dropdown.
- Then select Fill Effects.
- After that, go to the Picture tab and click on Select Picture.
- Add your desired image and click OK.
- Finally, you will have your selected picture inside the note.
To show or hide notes, select the cell with a note and then go to,
Review >> Notes >> Show/Hide Note
You can convert notes to comments by following a few simple steps. First, click on the note and navigate to,
Review >> Notes >> Convert to Comments
As a result, the note will be converted to a comment.
To remove a note in Excel, select the note and press the Delete button on your keyboard.
1. What are notes and comments in Excel?
Notes are used to add annotations or reminders to a cell. On the other hand, comments are added to communicate with the users. Notes don’t have any reply box, whereas the comment box comes with a reply option.
2. Can I protect Excel notes from being modified or deleted?
You can protect the notes from being modified or deleted by protecting the worksheet or the entire workbook. Just go to the Review tab and click on Protect Sheet.
3. Can I format the appearance of Excel notes, such as the background color?
Excel does not offer any built-in formatting option to change the appearance of the notes. The worksheet formatting and theme determines how the notes will look like.
Download Practice Workbook
In this article, we have discussed how to add, copy, hide, and remove notes in Excel worksheets. We have also covered how to add images to notes and how to convert notes to comments. If you have any queries or recommendations regarding this article, feel free to let us know in the comment section below.