How to Insert Comments in Excel Cell? (Steps)

Follow the below steps to insert a comment to a cell in Excel:

  • Step 1: To add a comment in Excel first, we must right-click on the cell with which the comment must be associated.Step 2: Then, click on “Insert Comment” and type the comment.

Shortcut to Insert Comment in Excel

The shortcut to insert a comment in the cell is “Shift+F2.”

Another way to insert a comment in Excel is to click on the “Review” tab and select “New Comment.”

Examples

Example #1

Example of adding a comment attached to a cell in Excel.

Suppose we wish to find how a student scores in an exam. There are two exam scores for a student. We must find the total score (sum of the two scores).

Example #2

Suppose we want to find the maximum salary per month from a list of some employees’ salaries.

  • 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.

The red triangle at the top right corner of the cell indicates that a comment is associated with it.

  • Step 1: To insert a comment in Excel with the maximum salary, we must right-click on the maximum salary cell and select “Insert Comment.”

  • Step 2: A box will appear: Type the comment in the box.

Example #3

If a picture needs to be inserted as a comment in Excel, we can carry out the following steps:

  • Step 1: We must right-click on the cell and select “Insert Comment.”

  • Step 2: Then, we must insert the text to be displayed in the comment and right-click on the edge of the comment box. Then, select “Format Comment.”

  • Step 3: Now, go to the “Color” and “Line” tab, expand the “Colors” dropdown listDropdown ListA drop-down list in excel is a pre-defined list of inputs that allows users to select an option.read more and select “Fill Effects.”

  • Step 4: Select the “Picture” tab and click “Select Picture.”

  • Step 5: Browse for a picture as per choice and click “OK.”

How to Add a Comment to Multiple Cells in Excel?

We can copy a single comment to multiple cells at the same time. We can carry out the following steps:

  • Step 1: We must first insert a comment in the first cell.

  • Step 2: Select the commented cell and press “Ctrl+C,” which copies the cell to the clipboard.

  • Step 3: Select the range of cells on which we want to paste the same comment.

  • Step 4: Select “Paste Special” from the “Edit” menu, and a Paste Special dialog boxPaste Special Dialog BoxPaste special in Excel allows you to paste partial aspects of the data copied. There are several ways to paste special in Excel, including right-clicking on the target cell and selecting paste special, or using a shortcut such as CTRL+ALT+V or ALT+E+S.read more will appear.

  • Step 5: Select the “Comments” button and click “OK.”.

  • Step 6: We must copy the comment from a cell in the first step to the range of cells selected in Step3.

If the range of cells selected already had some comments, those comments would be replaced by the comment we are pasting from a cell in Step2.

Things to Remember

  • The cell comments help communicate ideas, problems, and questions when collaborating on documents. They make the document review/understanding process smoother and faster for everyone involved.After entering the text as a comment and clicking on any cell again, the comment gets hidden. But the red flag or comment indicator remains.

  • Right-clicking on the cell and selecting “Show/Hide Comments” enables showing or hiding the comment associated with that cell.

  • If we want to show all the comments on all worksheets in a workbook, we must click “Show All Comments” in the “Review” tab’s “Comments” section.

  • 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. For moving a comment, it should display without the user hovering over the cell.So first, we must show the comment using “Show or Hide Comments.”Then, we must move the cursor over the border of the comment box until the cursor turns to a plus sign with arrows.Then, click to select the comment box. We will see sizing handles appear on the 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 overlap, so we must 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 change a comment.

  • A comment associated with a cell can be deleted by right-clicking on the cell and selecting “Delete Comment” in Excel.

  • We first commented using “Edit Comment” in Excel to format a comment. Then, we should highlight the text that we wish to format. Next, right-click on the selected text and click “Format Comment.” It will open a “Format Comment” dialog box. After that, we can make any changes to apply a different format to the text. For example, suppose we want to make some text bold and blue using the “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. Therefore, we can remove these flags from the cell in the following way:First, we must go to the “File”-> “Options” and click on “Advanced” on the left side of the Excel “Options” dialog box.Then, scroll down to the “Display” section on the right side of the Excel “Options” dialog box.Lastly, we must select “No comments or indicators’ under” “For cells with comments, show.”With these options selected, hovering over a cell with a comment will not display the comment.

This article is a guide to Insert Comment in Excel. We discuss adding, editing, copying, and deleting the comment in Excel manually and using keyboard shortcuts, practical examples, and a downloadable Excel template. You may learn more about Excel from the following articles: –

  • First, we must go to the “File”-> “Options” and click on “Advanced” on the left side of the Excel “Options” dialog box.Then, scroll down to the “Display” section on the right side of the Excel “Options” dialog box.Lastly, we must select “No comments or indicators’ under” “For cells with comments, show.”With these options selected, hovering over a cell with a comment will not display the comment.

  • VBA Comment BlockExcel Print CommentsInsert Calendar In Excel – ExamplesHow to Insert Button in Excel?