Join 400,000+ professionals in our courses here 👉 [ Ссылка ]
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: [ Ссылка ]
LINKS to related videos:
To find out how to search for specific text in Excel comments: [ Ссылка ]
check out my Excel basics playlist: [ Ссылка ]
★ My Online Excel Courses ► [ Ссылка ]
➡️ Join this channel to get access to perks: [ Ссылка ]
👕☕ Get the Official XelPlus MERCH: [ Ссылка ]
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: [ Ссылка ]
🎥 RESOURCES I recommend: [ Ссылка ]
🚩Let’s connect on social:
Instagram: [ Ссылка ]
LinkedIn: [ Ссылка ]
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
Ещё видео!