EDUCBA

EDUCBA

MENUMENU
  • Explore
    • Lifetime Membership
    • All in One Bundles
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Login
Home Excel Excel Resources Excel Tips Insert Comment in Excel

Insert Comment in Excel

Ashwani Jaiswal
Article byAshwani Jaiswal
Madhuri Thakur
Reviewed byMadhuri Thakur

Updated August 21, 2023

Excel Insert Comment

Insert Comment in Excel

In this article, we will learn about Insert Comment in Excel. Microsoft Excel has a feature where we can add comments in any cell and mention the things which might be important to someone else or for future reference. This helps in getting noticed by us and others who use our data so that if there is something important to do, that comment will help as a prompt. To add new comments, go to the Review menu, under the Comments sections, and Click on New Comment.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

How to Insert Comment in Excel?

To Insert a Comment in Excel is very simple and easy. Let’s understand how to insert comments in Excel with some examples.

You can download this Insert Comment Excel Template here – Insert Comment Excel Template

Example #1

  • We have sample data, as shown in the below screenshot.
  • We will insert comments in different cells and make some changes. Keep the cursor on any cell where we need to apply the filter. We have kept the cursor at Product Type, the first cell in the above screenshot.

Insert Comment in Excel Example 1-1

  • Now go to Review –> New Comment to insert the new comment in a selected cell, as shown below.

Insert Comment in Excel Example 1-2

  • Click on New Comment; we will get the comment box in that cell’s editable form, as shown below.

Insert Comment in Excel 1-3

  • We can add any comment which may be important and specific to that cell. Let’s edit and enter something in the comment, as shown in the screenshot below.
  • By inserting comments, the data looks more professional, and it reminds users about it as well. Click outside to come out of the edit mode of the comment.

Insert Comment 1-4

  • We can edit, delete, change to next/previous, and hide any comment. Let’s insert more comments and see what the data will look like.

Insert Comment 1-6

  • As we can see in the above screenshot, we have added a few more comments and specific comments about data and cell value. We have a few more options apart from adding New Comments.
  • Let’s learn the significance of every option available under the Comments section.

comments section

  • Delete – We can delete any selected comment.
  • Previous – We can move to the previously inserted comment if we have multiple comments.
  • Next – We can move to the next inserted comment if we have multiple comments from the currently selected comment.
  • Show All Comments – Show All Comments allows the user to see all the sheet comments if comments are hidden.
  • Show/Hide Comment – We can show or hide any comment.
  • Show Link – We can see the hidden inserted link in any cell.

Example #2

  • There is another method for Inserting Comments in any cell. For this, select any cell or put the cursor where we need to Insert a Comment. And right-click on it. Once we do this, we will get the Right-Click Menu, and there we will see Insert Comment shown in the screenshot below.

Comment 2-1

  • Once we Click on an Insert Comment, we will see a comment box where we can add anything per our need.

Insert Comment 2-2

  • We access more functions like Edit Comment, Delete Comment, and Show/Hide Comment, as discussed in the above example-1. This is a shortcut way of using Comments.

Comments 2-3

  • Another way to Insert a Comment in any cell is by pressing Shift + F2 together.
  • Once we add a comment in any cell, that comment, by default, will be hidden. And which becomes active once we put the cursor on that cell.
  • A cell with a comment inserted will have a Red Flag at the top right corner of the cell, as shown below.

Comments 2-4

  • Excel has one more feature for changing the User Name, which comes when we insert any comment, as shown in the screenshot below, where User Name is mentioned as Microsoft Excel.

red flag

  • We can add/remove/change the User Name as well. Go to the File menu and click Options, as shown in the screenshot below.

insert comments 2

  • Once we click on Options, we will get an Excel Options box.
  • Go to the General tab, and in the User name box, change the user name as per your wish, and Click on Ok.

Excel Options 2-7

  • We changed the name to Master Data. To see whether changes are done or not.
  • Go to any already Inserted comment and place the cursor on it. Or Insert a new comment to see the changes.

master data

  • As we can see, the new User Name Master Data is now applied to the comment.

Pros of Insert Comment in Excel

  • Insert comments allows a user to take action as per comments added in a cell.
  • This makes users cautious about making changes in data and also allows the user to handle data cautiously.
  • Inserted comment can easily be seen with the help of the Red Flag in an added cell. 

Cons of Insert Comment in Excel

  • If the huge data and the comments are hidden, it mostly gets ignored.

Things to Remember about Insert Comment in Excel

  •  When dealing with large data sets, it is important to add comments primarily in the heading to ensure they are not ignored.
  • Always be specific about inserting comments so the reader can get the motive quickly.

Recommended Articles

This has been a guide to Insert Comment in Excel. Here we discussed How to Insert Comments in Excel, practical examples, and a downloadable Excel template. You can also go through our other suggested articles to learn more –

  1. Excel Insert Button
  2. Print Comments in Excel
  3. Excel Insert Page Break
  4. VBA Comment
ADVERTISEMENT
All in One Excel VBA Bundle
500+ Hours of HD Videos
15 Learning Paths
120+ Courses
Verifiable Certificate of Completion
Lifetime Access
ADVERTISEMENT
Financial Analyst Masters Training Program
2000+ Hours of HD Videos
43 Learning Paths
550+ Courses
Verifiable Certificate of Completion
Lifetime Access
ADVERTISEMENT
All in One Data Science Bundle
2000+ Hour of HD Videos
80 Learning Paths
400+ Courses
Verifiable Certificate of Completion
Lifetime Access
ADVERTISEMENT
All in One Software Development Bundle
5000+ Hours of HD Videos
149 Learning Paths
1050+ Courses
Verifiable Certificate of Completion
Lifetime Access
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Insert Comment Excel Template

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Insert Comment Excel Template

EDUCBA

डाउनलोड Insert Comment Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

🚀 Extended Cyber Monday Price Drop! All in One Universal Bundle (3700+ Courses) @ 🎁 90% OFF - Ends in ENROLL NOW