ไม่สามารถเล่นวิดีโอนี้
ขออภัยในความไม่สะดวก
How to Add Notes in Excel | Shortcut Keys, Customize Background & More
ฝัง
- เผยแพร่เมื่อ 16 ส.ค. 2024
- Join 400,000+ professionals in our courses here 👉 link.xelplus.c...
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
⯆ Read the blog post: www.xelplus.co...
LINKS to related videos:
To find out how to search for specific text in Excel comments: • Find or Replace Text a...
check out my Excel basics playlist: • Excel Introduction - L...
★ My Online Excel Courses ► www.xelplus.co...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creato...
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.co...
🎥 RESOURCES I recommend: www.xelplus.co...
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
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
Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter
1 Thing that sets you apart is the Sincerity in your voice and passion for enlightening others . Excel Wizard 👍
I appreciate that!
Agreed.
I have a deep excitement for learning new things. I project that onto others. I share what I learned because I cannot experience that feeling of initial understanding when I learn something. However, I can experience it vicariously through others when they learn it for the first time.
Some people take my sharing of what I know as a sign of arrogance in what I know. That’s their loss. I ALWAYS look to learn from others, especially from people like Leila because the genuinely seem to want to spread their love of knowledge and wisdom for others.
I hope that I am not the smartest person in the room because I have less chance to learn if I am. If I am the “smartest” in the room, then I am motivated to share. If I am not the “smartest” in the room, then I am motivated to learn.
If you study neuroscience, you find the same pattern in neurons. Their purpose is to receive signals, processes those signals, and send a summary to other neurons. They NEED to receive AND transmit to serve their purpose. They need to serve their purpose to receive nourishment.
I am a neuron. I need to learn AND teach to serve my purpose.
I live to serve, and I serve to live.
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!
The notes / comments distinction 50 seconds in saved us from our troubles. Thank you!
Another great training session with you, Leila. You are the best!
Thank you Jim for your support! I'm glad you're enjoying the sessions.
Hi Leila......90% of the excel formulas and tricks you explain us that we don't know earlier. You are awesome in explaining. I am fan of yours.
Happy to hear that!
4:17 I love the idea of using icons as the border. It makes the notes more interesting related to the project. I’m always looking to take my excel spreadsheets to the next level.
Great work Leila. Every time I watch your videos, these is something new to learn even if the subject is well known to me. Thank you, please continue to upload new videos
Happy to hear that!
Hi Leila. I have to say by far you are my favorite person to learn new skills and take my excel projects to the next level. I really like the way you communicate and visually present the information in a clear and concise manner. Very easy to follow. I’m creating my next project and adding so many of your tips from your various videos. I can’t wait to show my co-workers everything I’ve done with it. I’m definitely going to recommend they subscribe and watch your channel so they too can EXCEL at it! 😊
Thank you so much for the kind words! I hope your co-workers will find the content useful too.
Thanks for the Notes and Comments tricks, love the transition Blue with the Comment Note "Comment" : )
Thank you teammate Mike :)
@@LeilaGharani You guys are teammates? Sounds like a conspiracy going on here.
Woah! We never took comments so seriously, thanks for sharing ma'am
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).
Hi Leila, even with functions I've ben using for years always I can catch some new tips from you. Thank you a lot :)
Well ...i just learned that powerpoint may convert pictures format ...i usually use other programs for that ... Many thanks liela for the tip
Very easy to follow especially for foreigners like me whose English listening ability is not as good as natives. Thank you very much for uploading these useful videos. Your videos save my work and time. Please continue adding more videos. Loved it!
Very nice, Leila. You are the best! Thank you for sharing.
Glad you liked it!
New to me. Well done. Thank you very much.
Thank you for your videos. Very helpful.
Thanks leila its helped me lot❤🎉
Well explained. Never knew it can be customized to that degree. Many thanks
Comments management is a very important tool to explain thank you Leila !!
You're welcome Mohammad. Agree - they're very useful
You are amazing .. I like your simple and powerful solutions 👍👍👍👍👍
Everything was new! Thank you!! You are an excellent teacher!!!
Awesome Leila. I learnt new things. I never expected there will be a video on comments. Thanks once again.
Great lesson, keep going
Very nice and well explained.. Thank you so much
My pleasure. I'm glad you like the video.
Thanks Leila! Each and every video from you new for me. We should thank for sharing your knowledge.
You're welcome. I thank you for watching, commenting and liking the video.
Hi Leila.. thanks for your comments on comments.. haha!! As always, an excellent and complete tutorial. Thanks also for showing how to get pictures into comments which is buried in the options and so not so obvious how to set up. Thumbs up!
Thank you Leila! Talk about geeky though... copy an icon in Powerpoint, save it as a picture, just so you can have a 'fancy' comment! LOL You go, girl! I cannot use it on my work product but I can play with it on my home system! I remember years ago that I would create icons for use in letterheads and Powerpoint presentations I made ... my PPT presentations were definitely a cut above all the ones put out by the company and other coworkers. I used to be frustrated when people would not adapt presentations of Charts and especially spreadsheets for an audience... TOO small to be read from the back for sure! Ha ha.
I enjoy your content very much. Your delivery is excellent. You are also nice on the eyes... not as nice as my wife but hey, that's why I married her! LOL
Haha. Attention to detail is important. Just have to find the border where it becomes annoying for others. Still working on that sometimes :)
Great lesson about comments, thank you for dropping knowledge Leila
My pleasure!
@@LeilaGharani just texted u in LinkedIn
amazing, thanks! this is new for me.
Love it. Every little bit helps secure my position. Thank You
Awesome that is helpful and i love it the way of teaching
Didn't know there was a shortcut to open comments (Notes). Needed the refresher about printing & formatting.
- Looks like Microsoft finally added one of Google Sheets features instead of the other way around.
Leila, thanks for keeping it concise!
I've been using comments and never knew all the other things possible. Thank you
Your videos always show..how to work smartly... 100K subscribers are not far away for your channel.
Thank you Sachin. Yes I can't believe we are nearly at 100k! Thank you for your support.
Thanks for the great video. I will reference you now on.
Genius to workflow accountability and effectiveness! Thanks, Leila, another Outstanding Video.
Thanks Leila,all except basic comments were new to me 😉👍
Keep it up as usual
Brilliant presentation dear Leila. Very helpful. This was new for me!
I like the feature of images and icons. Will be using it soon.
I also find it nice to give the spreadsheet a personal touch :)
I'll just start doing this and not telling people how so they get confused. It's a great way to mess with people. That and formatting a cell to read "[supervisor] is a [random teasing insult]" whenever a negative value is entered. Makes for a good laugh.
Oh, that's mean :)
beautifully explained... :)
Wow. Almost all of it was new for me. Thank you!
You just made it even more fun to work with Excel. Great job!
I'm happy to hear that Michaël.
No one like you You are above the super.
You are the best Leila
BADASS!!! I love these tricks...
superbly introduced thanks. most are new. thanks.
Glad you liked it!
I didn’t know about threaded comments and those cool comment hacks. Thanks for informing us!
Excellent, thanks Leila.
You're very welcome Peter.
Love your thorough explanation. This will be really useful. I knew how to change fonts in comments; pretty much everything else was new
All the presentation is new for me, thanks helping me.
Always exciting stuff.
Excel can do some exciting stuff :)
Love this! Idea: Demonstrate how to automatically stamp comments with user name, date, and time. This is critical to my work in a multi-user environment. Your followers who work collaboratively in multi-user environments will love it - I know I do!
Thanks for the tip! Already added to my list.
Absolutely great review of Comments!
Particularly useful is printing notes at the end .. didn't know about that. Thanks once again.
Agree - that can come in really handy :)
Perfect job as usual. Thank you.
Absolutely amazing ... I was aware of inserting comments.... honestly not the way you have done ... I'll definitely put this into use .... Thanks a lot
Thank you Leila. This help me a lot.
Very helpful! Thank you, Leila!
Thank You Yes I never knew that notes can be so creative , impressive.
All.the news items appear on the you tube are far away from truth.Do not try to fool the aspirants.
Hi Leila this was a great n altogether different topic covered by you. Nice effort.
Like as always, I enjoyed the video. Very informative and still new things to discover. Thanks a lot.
THANK YOU MA'AM
7 minutes for comment video. Packed with tips. Thumbs up.
Thank you for the thumbs up!
Great video! Learned a few things. Thanks for that!
When I have to paste several texts into comments I usually use the Office Clipboard. First I copy a bunch of them from the source and then paste thems in the cells comments. Just a small tip.
Thank you for the wonderful tip. Agree - the clipboard can come in really handy.
Thank you very much, May Allah bless you.
You are an inspiration to me and the best. Thank you and Happy New Year to you.
Kindest regards.
Jason
Thank you Jason! Happy New Year to you too.
Thanks a lot, this helps.
Many thanks for this video, new to using excel everyday and your videos will be really helpful.
Thank you! I'm very glad to hear that Dee C.
Some nice neet ways to present your comments. One problem that I run into often is comments in Pivot tables. My work around on this is to post the comments in the data set however that doesn't allow for comments on subtotals or groups. If you are able to share any tips in this regard that would be great. The simply comments in fixed cells doesn't really cut it when using dynamic repots such as pivot tables.
Once again thanks for the information, very useful for printing comments
Wow - so glad you have this clip. Learned a lot! Great presentation!
I'm glad you like the tutorial.
Nice referenshing video many things still don't know thanks Leila
NICE VIDEO...my Q is...how to changes the
'Name' first appear on the comment ?
thank you, Leila... How about a dynamic comment? Thanks
good one learned new thing
This was totally new! Thank you for info
thank you leila...
Awesome 👌 👏
Hi Leila; thanks for this exhaustive video on comment.:)
Thank you for providing this. Totally new....another great learning point from your youtube channel. 😃
You're very welcome Roberto :)
Thanks. Nice video.
Thanks for video!
You're very welcome.
WOW!! THAT WAS SO USEFUL. THANKS
Thanks, that was really helpful! I think I might make more use of comments in the future, now that I know how to improve the look of them.
You're very welcome Terry. Glad you found something new here.
I’m new to excel and your Chanel but I am wondering if there is a way to search comments / notes if I was looking for a specific one? I love the Chanel and thank you for doing these videos!
Thanks Leila
Thank you
Totally new for me! All my comments were yellow so far! Now it's going to change...
Glad the video is helpful Stefano.
Nice. Thx. Very usefull.
Mam ! Thanks for this valuable tutorial !
Glad you find the tutorial helpful.
Great tips. Unortunately, this does not work in MS Office Pro Plus 2021
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?
nice leilaaaaaaaaaaaaaa for the first time i khnow that we could change icons formatting
Hello Leila
I'm a bit novice with Excel but I do enjoy learning it.
Soon
In your video I was hoping for an instruction on how to insert a photo in notes of Excel.
The reason I want to do this is I want to get away from inserting a photo in a cell as this is very fiddle to do and messy.
I use a membership Microsoft so my software is the latest version
It would be so great to tidy up the sheet.
I help my missus with her fishing permits in keeping a log of all IDs of fisherman and is very handy to have photo ID for the river watchers (River police). Rules in Scotland are somewhat different.
Id this possible to insert photo in a excel notes comment.
Fantastic Leila, this helps. This was new for me!
Beautiful
Great content on your channel!
Do you have a video for this topic using Google Sheets?
Thanks for information now I can manage comments simpleily
You're very welcome Rahul.