Тёмный

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

Leila Gharani
Подписаться 2,7 млн
Просмотров 222 тыс.
50% 1

Опубликовано:

 

18 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 389   
@LeilaGharani
@LeilaGharani 7 месяцев назад
Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter
@hardeepbajwa2868
@hardeepbajwa2868 4 года назад
1 Thing that sets you apart is the Sincerity in your voice and passion for enlightening others . Excel Wizard 👍
@LeilaGharani
@LeilaGharani 4 года назад
I appreciate that!
@josephcoon5809
@josephcoon5809 3 года назад
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.
@robertflynn7416
@robertflynn7416 5 лет назад
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!
@yellowriverboy5734
@yellowriverboy5734 4 года назад
The notes / comments distinction 50 seconds in saved us from our troubles. Thank you!
@JimFikes
@JimFikes 5 лет назад
Another great training session with you, Leila. You are the best!
@LeilaGharani
@LeilaGharani 5 лет назад
Thank you Jim for your support! I'm glad you're enjoying the sessions.
@satyenpurohit3947
@satyenpurohit3947 5 лет назад
Woah! We never took comments so seriously, thanks for sharing ma'am
@prayagkudalkar5435
@prayagkudalkar5435 3 года назад
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.
@LeilaGharani
@LeilaGharani 3 года назад
Happy to hear that!
@HusseinKorish
@HusseinKorish 5 лет назад
Well ...i just learned that powerpoint may convert pictures format ...i usually use other programs for that ... Many thanks liela for the tip
@YitzhakMoniz
@YitzhakMoniz 5 лет назад
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).
@baburajankumaran3768
@baburajankumaran3768 2 года назад
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
@LeilaGharani
@LeilaGharani 2 года назад
Happy to hear that!
@kurtisf68
@kurtisf68 11 месяцев назад
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.
@excelisfun
@excelisfun 5 лет назад
Thanks for the Notes and Comments tricks, love the transition Blue with the Comment Note "Comment" : )
@LeilaGharani
@LeilaGharani 5 лет назад
Thank you teammate Mike :)
@woolysamoan
@woolysamoan 3 года назад
@@LeilaGharani You guys are teammates? Sounds like a conspiracy going on here.
@shadrackawunyo7786
@shadrackawunyo7786 5 лет назад
Well explained. Never knew it can be customized to that degree. Many thanks
@912Space
@912Space 2 года назад
Hi Leila, even with functions I've ben using for years always I can catch some new tips from you. Thank you a lot :)
@temuulenpurevdorj4358
@temuulenpurevdorj4358 5 лет назад
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!
@mohammadshamasneh62
@mohammadshamasneh62 5 лет назад
Comments management is a very important tool to explain thank you Leila !!
@LeilaGharani
@LeilaGharani 5 лет назад
You're welcome Mohammad. Agree - they're very useful
@kurtisf68
@kurtisf68 11 месяцев назад
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! 😊
@LeilaGharani
@LeilaGharani 11 месяцев назад
Thank you so much for the kind words! I hope your co-workers will find the content useful too.
@MrJim1032
@MrJim1032 4 года назад
Love it. Every little bit helps secure my position. Thank You
@uzenoff
@uzenoff 4 года назад
New to me. Well done. Thank you very much.
@sidneyjohnson6895
@sidneyjohnson6895 5 лет назад
Genius to workflow accountability and effectiveness! Thanks, Leila, another Outstanding Video.
@AlaaTUrk
@AlaaTUrk 5 лет назад
You are amazing .. I like your simple and powerful solutions 👍👍👍👍👍
@CindyWin
@CindyWin 5 лет назад
Everything was new! Thank you!! You are an excellent teacher!!!
@scottc.7541
@scottc.7541 2 года назад
Thank you for your videos. Very helpful.
@GosCee
@GosCee 3 года назад
Very nice, Leila. You are the best! Thank you for sharing.
@LeilaGharani
@LeilaGharani 3 года назад
Glad you liked it!
@laxmisarvaesh8566
@laxmisarvaesh8566 2 месяца назад
Thanks leila its helped me lot❤🎉
@maometto6812
@maometto6812 4 года назад
Great lesson about comments, thank you for dropping knowledge Leila
@LeilaGharani
@LeilaGharani 4 года назад
My pleasure!
@maometto6812
@maometto6812 4 года назад
@@LeilaGharani just texted u in LinkedIn
@vaseemakram9609
@vaseemakram9609 5 лет назад
Very nice and well explained.. Thank you so much
@LeilaGharani
@LeilaGharani 5 лет назад
My pleasure. I'm glad you like the video.
@ubaidyaseencubaidyaseenc8207
Great lesson, keep going
@vinodvishwakarma5387
@vinodvishwakarma5387 4 года назад
No one like you You are above the super.
@sandeepreddy7687
@sandeepreddy7687 5 лет назад
Thanks Leila! Each and every video from you new for me. We should thank for sharing your knowledge.
@LeilaGharani
@LeilaGharani 5 лет назад
You're welcome. I thank you for watching, commenting and liking the video.
@sergiodanelunaiii7773
@sergiodanelunaiii7773 5 лет назад
BADASS!!! I love these tricks...
@joep9617
@joep9617 5 лет назад
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!
@ca.lakshminarayanreddyjamb9087
Awesome Leila. I learnt new things. I never expected there will be a video on comments. Thanks once again.
@zain8
@zain8 3 года назад
amazing, thanks! this is new for me.
@keishrich
@keishrich 5 лет назад
I like the feature of images and icons. Will be using it soon.
@LeilaGharani
@LeilaGharani 5 лет назад
I also find it nice to give the spreadsheet a personal touch :)
@ucplho5461
@ucplho5461 5 лет назад
Brilliant presentation dear Leila. Very helpful. This was new for me!
@persaq
@persaq 5 лет назад
Excellent, thanks Leila.
@LeilaGharani
@LeilaGharani 5 лет назад
You're very welcome Peter.
@miguelencanarias
@miguelencanarias 5 лет назад
Wow. Almost all of it was new for me. Thank you!
@manojkadam2040
@manojkadam2040 4 года назад
Awesome that is helpful and i love it the way of teaching
@MrZahiddahar
@MrZahiddahar 5 лет назад
All the presentation is new for me, thanks helping me.
@adenikeolatunde5333
@adenikeolatunde5333 11 месяцев назад
You are the best Leila
@Mohanad52023
@Mohanad52023 4 года назад
superbly introduced thanks. most are new. thanks.
@LeilaGharani
@LeilaGharani 4 года назад
Glad you liked it!
@Juxtavarious
@Juxtavarious 5 лет назад
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.
@LeilaGharani
@LeilaGharani 5 лет назад
Oh, that's mean :)
@terrywright6794
@terrywright6794 3 года назад
Thanks for the great video. I will reference you now on.
@mohamedalsaqaf8693
@mohamedalsaqaf8693 4 года назад
Thanks Leila,all except basic comments were new to me 😉👍 Keep it up as usual
@abhishekkmr001
@abhishekkmr001 4 года назад
beautifully explained... :)
@vida1719
@vida1719 5 лет назад
Absolutely great review of Comments!
@TheNabob57
@TheNabob57 4 года назад
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
@LeilaGharani
@LeilaGharani 4 года назад
Haha. Attention to detail is important. Just have to find the border where it becomes annoying for others. Still working on that sometimes :)
@A17W
@A17W 3 года назад
THANK YOU MA'AM
@kimkipper6937
@kimkipper6937 4 года назад
Thank you Leila. This help me a lot.
@wingame52
@wingame52 3 года назад
I've been using comments and never knew all the other things possible. Thank you
@andrewmoss6449
@andrewmoss6449 5 лет назад
I didn’t know about threaded comments and those cool comment hacks. Thanks for informing us!
@MyHobbyKeepsMeBusy1
@MyHobbyKeepsMeBusy1 5 лет назад
You just made it even more fun to work with Excel. Great job!
@LeilaGharani
@LeilaGharani 5 лет назад
I'm happy to hear that Michaël.
@ericgatera7149
@ericgatera7149 4 года назад
This was totally new! Thank you for info
@mflemmings
@mflemmings 3 года назад
Thank You Yes I never knew that notes can be so creative , impressive.
@shaikmahamadghouse9570
@shaikmahamadghouse9570 3 года назад
All.the news items appear on the you tube are far away from truth.Do not try to fool the aspirants.
@wayneedmondson1065
@wayneedmondson1065 5 лет назад
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!
@lodgechant
@lodgechant 4 года назад
Very helpful! Thank you, Leila!
@HubertKirchgaessner
@HubertKirchgaessner 5 лет назад
Love your thorough explanation. This will be really useful. I knew how to change fonts in comments; pretty much everything else was new
@EricaDyson
@EricaDyson 5 лет назад
Particularly useful is printing notes at the end .. didn't know about that. Thanks once again.
@LeilaGharani
@LeilaGharani 5 лет назад
Agree - that can come in really handy :)
@subramanyaswamy9052
@subramanyaswamy9052 4 года назад
Thanks a lot, this helps.
@bahmannosratollah7017
@bahmannosratollah7017 2 года назад
Perfect job as usual. Thank you.
@atcltangail
@atcltangail 5 лет назад
Thanks Leila
@venkatraj5491
@venkatraj5491 3 года назад
thank you leila...
@ulrickt
@ulrickt 5 лет назад
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.
@yurd563
@yurd563 5 лет назад
Thanks for video!
@LeilaGharani
@LeilaGharani 5 лет назад
You're very welcome.
@ckokse
@ckokse 5 лет назад
Always exciting stuff.
@LeilaGharani
@LeilaGharani 5 лет назад
Excel can do some exciting stuff :)
@sparklingNK
@sparklingNK 4 года назад
good one learned new thing
@sachinjain5698
@sachinjain5698 5 лет назад
Your videos always show..how to work smartly... 100K subscribers are not far away for your channel.
@LeilaGharani
@LeilaGharani 5 лет назад
Thank you Sachin. Yes I can't believe we are nearly at 100k! Thank you for your support.
@sameesamee6508
@sameesamee6508 8 месяцев назад
Thank you very much, May Allah bless you.
@venkatiyer7459
@venkatiyer7459 3 года назад
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
@RahulJauhari
@RahulJauhari 5 лет назад
Thanks for information now I can manage comments simpleily
@LeilaGharani
@LeilaGharani 5 лет назад
You're very welcome Rahul.
@ajayv304
@ajayv304 5 лет назад
Thanks. Nice video.
@unlisted773
@unlisted773 5 лет назад
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!
@LeilaGharani
@LeilaGharani 5 лет назад
Thanks for the tip! Already added to my list.
@kaelmercapuyan8613
@kaelmercapuyan8613 Год назад
thank you, Leila... How about a dynamic comment? Thanks
@bestscenes1469
@bestscenes1469 5 лет назад
Beautiful
@amit12000
@amit12000 5 лет назад
Nice referenshing video many things still don't know thanks Leila
@anilmudakannavar79
@anilmudakannavar79 5 лет назад
Once again thanks for the information, very useful for printing comments
@alghazalizakaria6926
@alghazalizakaria6926 4 года назад
NICE VIDEO...my Q is...how to changes the 'Name' first appear on the comment ?
@keeriti2594
@keeriti2594 11 месяцев назад
Thank you
@wofdigy
@wofdigy 4 года назад
Great vid as always Leila. Is there anyway to move the placement of the comment? I have comments in a far right cell but want them to show up in the middle of the screen. Anyway to do this? everything i try pops them up right of the cell their linked to
@joeymueller1510
@joeymueller1510 5 лет назад
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!
@olipeeeeee
@olipeeeeee 4 года назад
Nice. Thx. Very usefull.
@yashsomaiya6491
@yashsomaiya6491 5 лет назад
Hi Leila this was a great n altogether different topic covered by you. Nice effort.
@jasonagresti3069
@jasonagresti3069 4 года назад
You are an inspiration to me and the best. Thank you and Happy New Year to you. Kindest regards. Jason
@LeilaGharani
@LeilaGharani 4 года назад
Thank you Jason! Happy New Year to you too.
@09shirish
@09shirish 5 лет назад
Mam ! Thanks for this valuable tutorial !
@LeilaGharani
@LeilaGharani 5 лет назад
Glad you find the tutorial helpful.
@civilxpert935
@civilxpert935 4 года назад
Thank you its Help me
@gulzirak2727
@gulzirak2727 2 года назад
Hi Leila very nice video thank you so much, but i have one question can we give a comment for more than one cell or not?
@md.sazzadhossainrakib7650
@md.sazzadhossainrakib7650 5 лет назад
Thanks a lot
@eslamfahmy87
@eslamfahmy87 11 месяцев назад
Awesome 👌 👏
@sachinrv1
@sachinrv1 5 лет назад
Hi Leila; thanks for this exhaustive video on comment.:)
@khaledal-asbahi8716
@khaledal-asbahi8716 4 года назад
WOW!! THAT WAS SO USEFUL. THANKS
@deec.5897
@deec.5897 5 лет назад
Many thanks for this video, new to using excel everyday and your videos will be really helpful.
@LeilaGharani
@LeilaGharani 5 лет назад
Thank you! I'm very glad to hear that Dee C.
@raaafim4085
@raaafim4085 5 лет назад
Hi Leila, Thanks , its helpful. Can v add hyperlinks in comments ?
@dddphilosophy
@dddphilosophy 5 лет назад
Wow - so glad you have this clip. Learned a lot! Great presentation!
@LeilaGharani
@LeilaGharani 5 лет назад
I'm glad you like the tutorial.
@syairol
@syairol 5 лет назад
7 minutes for comment video. Packed with tips. Thumbs up.
@LeilaGharani
@LeilaGharani 5 лет назад
Thank you for the thumbs up!
@diegopagura421
@diegopagura421 5 лет назад
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.
@LeilaGharani
@LeilaGharani 5 лет назад
Thank you for the wonderful tip. Agree - the clipboard can come in really handy.
@tanweerabbasabbas649
@tanweerabbasabbas649 9 месяцев назад
beautiful
@BruceWL
@BruceWL 11 месяцев назад
Great content on your channel! Do you have a video for this topic using Google Sheets?
@RHH1095
@RHH1095 4 года назад
Thanks for the heads on new Threaded Comments and old become comments becoming Notes.
@vudrikopaul8249
@vudrikopaul8249 10 месяцев назад
Well-done Dear. But how do you change that "RED COLOR" for comment to any other color of your choice..?
@TheYesyears
@TheYesyears 2 года назад
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.
Далее
7 Things You're Doing WRONG⚡in Excel
15:22
Просмотров 1,2 млн
У НАС ДОМА ЗАВЕЛАСЬ КРЫСА 🐀
01:00
СМЕЛОЕ РЕШЕНИЕ #shorts
00:14
Просмотров 22 тыс.
Excel Tutorial for Beginners | How to Use Excel
15:54
Comments vs Notes in Excel 365 - Tutorial
3:38
Просмотров 10 тыс.
Excel Header & Footer (& Quickly Copy to other Sheets)
8:00
Create Dependent Drop Down List in Excel - EASY METHOD
12:10
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
Common Pivot Table Features People Miss (and you?)
12:45
Excel for Beginners - Threaded Comments & Notes
5:07
Excel Time-Savers - 5 Hidden Features for Busy People
14:24
Master the IF Formula in Excel (Beginner to Pro)
11:16
Просмотров 459 тыс.