Excel The Difference Between Threaded Comments And Legacy Notes - Episode 2242
HTML-код
- Опубликовано: 28 июн 2024
- Microsoft Excel Tutorial: Contrast Excel Threaded Comments with Notes in Excel.
Welcome back to another episode of the MrExcel netcast! In this episode, we're diving into the world of Excel notes and threaded comments. Just two weeks ago, I released a video where I complained about the lack of threaded comments in Excel. But thanks to Microsoft and all of you who voted for my Excel User Voice idea, they have been brought back! So let's take a look at the difference between notes and threaded comments in Excel.
First, let's talk about notes. Many of you may know them as comments, but they were originally called notes when they debuted in Excel 97. Then, in Excel 2000, they were renamed to comments. But now, they are back to their original name of notes. You can access them by pressing Alt + IM, and they still have all the same features we know and love, such as changing the shape and color. And thanks to Microsoft for bringing them back!
Now, let's move on to the new feature - threaded comments. These are available in version 1810 of Insider Fast and will be hitting the monthly channel soon. To access them, instead of using Alt + IM, we use the new comments button. This allows us to add a comment with our name and a time stamp, and we can even add replies to the comment. These threaded comments can live side by side with notes, and you can easily tell them apart by the purple indicator for threaded comments and the red indicator for notes.
But that's not all - there's also new VBA for these comments! In the video, I show you how to record a macro to add a new comment, reply to a comment, and even edit a comment. The old comment code will still work, but it's great to have this new functionality available. So if you're interested in VBA, be sure to stick around for the outtake at the end of the video.
Thanks for watching this episode of the MrExcel netcast. If you enjoyed it, please subscribe and ring that bell for notifications. And as always, a big thank you to Microsoft for bringing back the notes and introducing the new threaded comments feature. See you next time for another netcast from MrExcel!"
Buy Bill Jelen's latest Excel book: www.mrexcel.com/products/latest/
You can help my channel by clicking Like or commenting below: www.mrexcel.com/like-mrexcel-...
Table of Contents
(0:00) Threaded comments and notes in Excel
(0:14) Jon Peltier and Excel.Uservoice
(0:30) Inserting a Note
(1:16) Tricks with the legacy notes keep working
(2:01) New Threaded Comments
(2:36) Seeing Replies to Excel Threaded Comments
(3:05) Purple indicator versus red indicator
(3:16) Icons in the Review tab of Ribbon
(3:31) Comments Panel with Show Comments
(4:09) Recording a Macro for Comments
(4:41) New .AddThreadedComment method in VBA
(5:09) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #tutorial
This video answers these common search terms:
Difference between notes and threaded comments
Editing comments in VBA
Excel notes formatting
Excel notes vs comments
Excel threaded comments
Icons for notes and threaded comments
Learn Excel from MrExcel Podcast Episode #2242
Microsoft Excel bug fix
New features in version 1810 of Insider Fast
Notes and Threaded Comments
Show/hide all notes in Excel
VBA for comments and threaded comments
Join the MrExcel Message Board discussion about this video at www.mrexcel.com/board/threads...
Build 1810 of Excel introduces Threaded Comments and they are cool. You can now have a conversation about each cell in Excel. Threaded comments will show date, time, author, and the comment. What if you want the old features of comments? They are now called Notes.
To download the workbook from this video: www.mrexcel.com/download-cent...
Buy Bill Jelen's latest Excel book: www.mrexcel.com/products/latest/
what is threaded comments in excel
how to add threaded comments in excel
how to read threaded comment in excel
how to read threaded comments in excel
how to view threaded comments in excel
how to read a threaded comment excel
change color of comment box in excel
excel how to add image to comment
excel how to add text comment in cell
how to add a comment to an excel cell
how to add a picture to a comment on excel 365
how to add image in excel comment
how to change comment color in excel
how to insert a picture in excel comment
how to insert a picture into an excel comment
how to insert a picture into excel comment
how to insert an image in excell as comment
how to insert picture as a comment in excel
how to put an image in a comment in excel
how to put image in comments in excel
how to put pictures in excel comment
¡Gracias, cumpa!
Thanks for the update, Mr Excel!
I like these new comments. Thanks for sharing, Bill!
Thanks for leading the way on this!
Hi Bill,
For years one of the glaring omissions with Comments was that while you could define the size, Excel would never let you define the display positioning. So, now that they're called NOTES again, can we define the display positioning of the NOTE?
As a follow-on, can we now link dynamic content to a NOTE - like a web-based or other video or other web based data or images?
Thanks!
Thank You!
Thank you sir
thanks from Bangladesh
I cannot edit my notes on excel for mac on 365 to allow me to save pictures in the notes. Just doesn't seem to have that functionality (or changing shape etc). Any ideas Mr Excel? Is this feature just missing from the mac version? Otherwise everything appears as in your video.
Ciao ottimo video, grande... Volevo chiedere un parere se è possibile: è da qualche giorno che mentre uso excel, quando mi trovo a dover scorrere verso il basso escono lungo tutta la schermata delle linee nere, lo schermo sembra andare in tilt, tenendo premuto la freccia verso il basso il problema aumenta e da essere una semplice linea viene a sparire metà schermo. Se chiudo excel il problema scompare. Ho pensato a qualche programma che potrebbe fare interferenza con excel ma mi pare strano... A qualcun altro è capitato? Sapete come risolvere? Grazie in anticipo
Hey, Great video. My Question is:
Is a comment linkable. I have a table of customers, then I use query to
split the table into sub tables which show me certain customers based on
different criteria. is there a way to bring the comments about that customer across
too?
Thanks Again Allan
How do I add 'Note' option to my excel? I only have 'Comment' option.
The new threaded comments were released to Microsoft 365 subscribers in 2018. It was not a feature in Excel 2016 or earlier.
hello sir, can you please give some excel tips/formula on how to auto calculate difference and also totals of two digit numbers of a cell.
eg : 91-->2 ; 31--->8 ; 21-->9 ; 20-->8 (difference)
eg : 91-->10 ; 31-->4 ; 21-->3 ; 20-->2 (total)
OK so VBA can edit Notes and comments. So to be clear, if I had VBA code that adjusted/changed, etc formerly known as comments, now I must use "notes"?
RickK Evil the old existing VBA code keeps working to create notes.
Threaded Comments I don't have what to do?
I have Office 2019
Is their a short cut key for threaded comments? shift+F2 only brings up "notes"
Ctrl+Shift+F2 for Comments
@@MrXL Thank You!! Much appreciated!!
Hi can someone else delete your thread comment that you left? thank you
Can you remove the date and time from the comment threads?
I have not found a way to do this
I don't understand why they felt the need for Comments and Notes separately. I understand the different functionality, but couldn't they have merged them somehow? Unnecessary compliction IMO
They did originally merge them and it was going to cause havoc. I put out a video explaining the havoc it would cause and over 100 people voted at Excel.UserVoice.com to change it to the new way. On behalf of the people who used Notes with formatting to create on-screen help systems, keeping them separate will prevent the people using those worksheets from destroying all of the formatting in one click.