Table of Contents
Insert Excel Comments
We can insert comments to a particular cell in an excel worksheet. A comment is a way to attach additional information to a cell without changing the data itself. Inserting comment in excel can make the cell more informative and eye-catching.
Where to Use Excel Insert Comments?
Inserting comments in Excel can be useful when we need to explain formulas or describe the content or purpose of a cell. It helps in proper indentation and to understand what input a cell should have. It can also be used to clarify how to use certain parts of the worksheet.
To insert a comment to a cell in excel, the following steps need to be executed:
- To add a comment in Excel first, you need to Right click on the cell with which the comment needs to be associated.
- Click on ‘Insert Comment’ and type your own comment.
Shortcut for Inserting Comment in Excel: Press Shift+F2
Another way to insert a comment in Excel is: Clicking on Review tab and selecting ‘New Comment’.
How to Insert Comment in Excel?
Below are the examples to Insert Comment in Excel.
Insert Comment in Excel Example #1
Let’s see a simple example of adding a comment attached to a cell in excel: If we wish to find how a student scores in an exam. There are two exam scores of a student and we find the total score (sum of the two scores)
- To add a comment in excel with the total score, right click on the cell containing a total score and select ‘Insert Comment’.
- A box will appear: Type the comment in the box
The red triangle at the top right corner of the cell indicates that a comment is associated with it.
Insert Comment in Excel Example #2
Now, let’s say we want to find the maximum salary per month from a list of some employees’ salaries:
- To insert a comment in excel with maximum salary, right click on the cell containing maximum salary and select ‘Insert Comment’.
- A box will appear: Type the comment in the box.
Insert Comment in Excel Example #3
If a picture needs to be inserted as a comment in excel, the following steps can be carried out:
- Right click on the cell and select ‘Insert Comment’.
- Enter the text to be displayed in the comment and right click on the edge of the comment box and then select ‘Format Comment’.
- Go to Colors and Lines tab, expand Colors dropdown list and select ‘Fill Effects’.
- Then select the Picture tab and click ‘Select Picture’.
- Browse for a picture of your choice and click OK.
Example #4 – Adding a Comment to Multiple Cells in Excel
A single comment can be copied to multiple cells at the same time. Following steps can be carried out to do so:
- Insert a comment in the first cell.
- Select the commented cell and press Ctrl+C which copies the cell to the clipboard.
- Select the range of cells on which you wish to paste the same comment.
- Select Paste Special from Edit menu and a Paste Special dialog box will appear.
- Select the Comments button and click OK.
On doing this, the comment from a cell in the first step would be copied to the range of cells selected in step3.
If the range of cells selected already had some comments, then those comments would be replaced by the comment we are pasting from a cell in step2.
Things to Remember While Inserting a Comment in Excel
- When collaborating on documents, cell comments help communicate ideas, problems, and questions. They make the document review/understanding process smoother and faster for everyone involved.
- After entering the text as a comment, and then clicking on any cell again, the comment gets hidden but the red flag or comment indicator remains.
- Right-clicking on cell and selecting ‘Show/Hide Comment’ enables to show or hide the comment associated with that cell.
- If we wish to show all the comments on all worksheets in a workbook, click ‘Show All Comments’ in a Comments section on Review tab.
- When we have too many comments on a sheet, there may be a possibility that some of the comments may overlap. To fix this issue, we have an option of ‘Move or Resize a Comment’. So if some comments are blocking other comments or cells, we may want to move them. To move a comment, the comment should display without the user hovering over the cell.
- So first, show the comment using ‘Show or Hide Comments’.
- Move the cursor over the border of comment box until the cursor turns to a plus sign with arrows.
- Then click to select the comment box and we will see sizing handles appear on sides and corners of a box.
- Now keep the mouse cursor over the border of the comment box and then click and drag the comment box to another location.
We can see that some comments are overlapping, so we drag them to another location using the above method of moving and resizing a comment.
- Right clicking on the cell and clicking ‘Edit Comment’ in excel can help to make changes in a comment.
- A comment associated with a cell can be deleted by right-clicking on the cell and selecting ‘Delete Comment’ in excel.
- To format a comment, we first make the comment editable using ‘Edit Comment’ in excel. Then highlight the text that you wish to format. Right click on the selected text and click ‘Format Comment’. This will open a ‘Format Comment’ dialog box. Any changes can be made to apply a different format to the text. Let’s say we want to make some text bold and blue using ‘Font Style’ and ‘Color’ dropdown list:
This will make changes in a comment with the new formatting.
- When we have too many comments, the red flags on the cells might be distracting. We can remove these flags from the cell in the following way:
- Go to File-> Options, and click on ‘Advanced’ on the left side of the Excel Options dialog box.
- On the right side of the Excel Options dialog box, scroll down to the ‘Display ‘section.
- Select ‘No comments or Indicators’ under ‘For a cell with comments, show’.
- With these options selected, hovering over a cell with a comment will not display the comment.
You can Download this Insert Comment Excel template here –Insert Comment Excel Template
This has been a guide to Insert Comment in Excel. Here we discuss how to Add, Edit, Copy and Delete Comment in Excel along with practical examples and downloadable excel template. You may learn more about excel from the following articles –