Course Content

Course Content

Comments in MS Excel

How to Edit-Update Comments

 

Sometimes more than one or two person are working on same Excel sheet, so to understand every step which you have taken for next person, we use comments.

 

To add any comment to a particular cell, we will right click on it and select 'Insert Comment' option. After that we can write whatever we want to in that comment.

 

Now that particular cell with comment will show a red arrow on top right corner of it. This will help the next person to understand that this is where comment is written. For reading that comment we just need to hover our mouse pointer on that red arrow.

 

We can also add comment by going to our REVIEW tab and selecting add comment option.

 

So by using comments we can make our work book for our Excel sheet very easily understandable for the next person or next user.

 

Shortcut for adding comment is 'Shift+F2' keys.

FAQs

Comments are a way to add notes and explanations to a spreadsheet. They are not visible when you open the document, but they can be helpful for you or other people who might use the spreadsheet.

Comments are a useful tool in Excel to provide insight into what is happening in the worksheet. They can be used to explain formulas, highlight important information or provide feedback on a workbook. Comments are not visible when the workbook is published, but they can be helpful for other people who might need to edit or update the workbook.

Comments are a useful tool in Excel to provide insight into what is happening in the worksheet. They can be used to explain formulas, highlight important information or provide feedback on a workbook. Comments are not visible when the workbook is published, but they can be helpful for other people who might need to edit or update the workbook.

Comments are also an excellent way to leave instructions for other people who might use the spreadsheet. If someone else needs to update the spreadsheet, they can see what changes were made and why they were made.

In order to add comments to a spreadsheet, you will need to click on the cell you want to comment on and then click on comment opion and type in your comment. You can also make the comment italic by using **. You can even use shortcut key Ctrl+alt+M.

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere