How to Add Notes in Excel | Shortcut Keys, Customize Background & More

Ideal for anyone seeking to organize and enhance their Excel spreadsheets, this video demonstrates how to add, edit, and customize comments (now called notes in Excel) for clearer communication and data annotation.

Note: Excel 365 has upgraded to threaded comments - The comments we see in this video are called Excel Notes in Office 365.

🔑 Key Points:
- Understanding Notes and Comments: Learn the difference between the newly introduced threaded comments and the traditional Excel comments, now known as notes.
- Shortcut Keys for Quick Access: Discover how to insert and edit notes using shortcut keys for speed and efficiency.
- Showing and Hiding Comments: Understand how to easily display all comments on a sheet or hide them when not needed.
- Printing Comments: Explore options for printing comments either as displayed on the sheet or at the end of it.
- Copying and Pasting Comments: Find out how to copy comments from one cell to multiple cells without altering cell content.
- Customizing Comments: Learn to change the background color, font, and even add images or icons to your notes for a personalized touch.

00:00 How To Add Notes in Excel
00:58 Excel shortcut keys to insert & edit a comment
01:49 How to show and hide Excel comments
02:11 How to print comments
03:07 How to copy and paste Excel comments and copy comments to multiple cells
03:36 How to format the comment (change background color, font etc.)
04:14 Replace the background with an image or icon of your choice

LINKS to related videos:

🚩Let’s connect on social:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#excel

[yellowriverboy]

The notes / comments distinction 50 seconds in saved us from our troubles. Thank you!

[mohammadshamasneh]

Comments management is a very important tool to explain thank you Leila !!

[ca.lakshminarayanreddyjamb]

Awesome Leila. I learnt new things. I never expected there will be a video on comments. Thanks once again.

[EricaDyson]

Particularly useful is printing notes at the end .. didn't know about that. Thanks once again.

[manojkadam]

Awesome that is helpful and i love it the way of teaching

[RahulJauhari]

Thanks for information now I can manage comments simpleily

[hardeepbajwa]

1 Thing that sets you apart is the Sincerity in your voice and passion for enlightening others . Excel Wizard 👍

[pjfaherty]

How do you set a default shape for the comment box?

[dddoda]

I'm trying to change the font type on all notes and future notes, bu cannot find how to do it. Singly, yes, but not all.

[kamalsaba]

Hi . Can u help me with my excel sheet problem?

[excelisfun]

Thanks for the Notes and Comments tricks, love the transition Blue with the Comment Note "Comment" : )

[YitzhakMoniz]

Nice video Leila. The only problem I have with comments is that they don't quite move with the cell say in case you happen to filter a specific set of cells in a table. And when you want to see the comments for those cells they all seem to be floating in the original place where the comment was first created. Hopefully you understand what I'm trying to explain. That's why I've been using the validation message option as of lately, but the draw back here is that unlike comments you don't quickly notice that that cell has a comment (i.e. the red arrow in the corner of the cells).

[alghazalizakaria]

NICE VIDEO...my Q is...how to changes the
'Name' first appear on the comment ?

[HusseinKorish]

Well ...i just learned that powerpoint may convert pictures format ...i usually use other programs for that ... Many thanks liela for the tip

[alanendurace]

Hi Leila. Why is the comment box always showing next to the cell and not where I dragged it on another side of the screen? do you know a trick to make it stick where I dragged it?

[robertflynn]

Hi Leila, I’ve noticed that in Excel 365 that if you want to copy and paste what is now called a “note” that after you copy and try to paste special, the only option you see is “comments” - thankfully it works whether you are trying to copy & paste either a comment or a note. Great video as always!

[JimFikes]

Another great training session with you, Leila. You are the best!

[satyenpurohit]

Woah! We never took comments so seriously, thanks for sharing ma'am

[Space]

Hi Leila, even with functions I've ben using for years always I can catch some new tips from you. Thank you a lot :)

[shadrackawunyo]

Well explained. Never knew it can be customized to that degree. Many thanks