Excel Functions Tutorials
- Excel Tips
- Excel vs Access
- Excel Rows vs Columns
- Apple Numbers vs Excel
- 3D Reference in Excel
- Absolute Reference in Excel
- Mixed References in Excel
- Excel Reference to Another Sheet
- Array Formulas in Excel
- Arrays in Excel VBA
- Auto Numbering in Excel
- AutoFit in Excel
- AutoCorrect in Excel
- AutoSave in Excel
- AutoRecover in Excel
- Bullet Points in Excel
- Break Links in Excel
- Barcode in Excel
- Change Case in Excel
- CAGR Formula in Excel
- Calculate Age in Excel
- Calculate Percentage in Excel Formula
- Cell Reference in Excel
- Checklist in Excel
- Circular Reference in Excel
- Column Sort in Excel
- Column Lock in Excel
- Move Columns in Excel
- Custom List in Excel
- Consolidate in Excel
- Combine Cells in Excel
- Compare Two Columns in Excel
- Compare and Match Columns in Excel
- Compound Interest Formula in Excel
- Convert Columns to Rows in Excel
- Convert Date to Text in Excel
- Convert Numbers to Text in Excel
- Convert Text to Numbers in Excel
- Convert Excel to CSV
- Count Characters in Excel
- Count Rows in Excel
- Count Unique Values in Excel
- Countif not Blank in Excel
- Create Templates in Excel
- Family Tree in Excel Template
- Custom Number Format in Excel
- Delete Row Shortcut in Excel
- Divide in Excel Formula
- Drop Down List in Excel
- Dynamic Tables in Excel
- Dashboard in Excel
- KPI Dashboard in Excel
- Date to Text in Excel
- Date Format in Excel
- Database in Excel
- Delta Symbol in Excel
- $ Symbol in Excel
- Excel Column to Number
- Edit Drop-Down List in Excel
- Equations in Excel
- Exponents in Excel
- Excel Extensions
- Excel Translate
- Excel Not Responding
- Excel Find and Replace
- Find and Select in Excel
- Excel Subtraction Formula
- Excel Formula for Grade
- Excel as Calculator
- Excel Formula Not Working (Updating)
- Excel Table Styles & Formats
- Excel vs Google Sheets
- External Links in Excel
- Excel Alternate Row Color
- Excel Worksheet Tab
- Extract Number from String Excel
- Evaluate Formula in Excel
- Find Duplicates in Excel
- Finding Links in Excel
- Filter Shortcut in Excel
- Formatting in Excel
- Format Numbers to Millions & Thousands in Excel
- Format Phone Numbers in Excel
- Formula Errors in Excel
- Fractions in Excel
- Frequency Distribution in Excel
- Group in Excel
- Group Worksheets in Excel
- Group Columns in Excel
- Hide Formula in Excel
- Hiding a Column in Excel
- Highlight Every Other Row in Excel
- Highlight Duplicates in Excel
- How to Create a Formula in Excel?
- How to Create an Excel Spreadsheet?
- How to Add Text in Excel Formula?
- How to Create Dashboard in Excel?
- How to Copy Sheet in Excel?
- How to Delete Pivot Table?
- How to Calculate Percentage Increase in Excel?
- How to Multiply in Excel Formula?
- How to Unhide Columns in Excel?
- Insert Date in Excel
- Insert Calendar in Excel
- Import Data into Excel
- Insert Comment in Excel
- Insert Hyperlinks in Excel
- Insert Multiple Rows in Excel
- Insert Row Shortcut in Excel
- Insert New Worksheet in Excel
- Insert (Embed) an Object in Excel
- Insert Image in Excel Cell
- Insert Page Break in Excel
- Line Breaks in Excel
- Linear Interpolation in Excel
- Leading Zeros in Excel
- Last Day of the Month in Excel
- Logical Operators in Excel
- Lookup Table in Excel
- Mortgage Calculator in Excel
- Moving Average in Excel
- Not Equal to in Excel
- Numbering in Excel
- Name Manager in Excel
- Page Numbers in Excel
- Page Break in Excel
- Personal Budget Template in Excel
- Project Management Template in Excel
- Percentage Difference in Excel (Increase / Decrease)
- Pivot Table Calculated Field & Formula
- Pivot Table Sort
- Pivot Table From Multiple Sheets
- Print Comments in Excel
- Print Excel Gridlines
- Print in Excel
- Print Preview in Excel
- Print Area in Excel
- Print Titles in Excel
- Print Labels From Excel
- Project Timeline in Excel
- Protect Sheet in Excel
- Ratio in Excel Formula
- Random Numbers in Excel
- Randomize List in Excel
- Refresh Pivot Table in Excel
- Relative References in Excel
- Remove Blank Rows in Excel
- Remove Duplicates in Excel
- Remove Duplicates from Excel Column
- Remove Hyperlinks in Excel
- Remove Space in Excel
- Remove Leading Spaces in Excel
- Remove Watermark in Excel
- Row Limit in Excel
- Rows and Columns in Excel
- Rows to Columns in Excel
- Row Header in Excel
- Search in Excel
- Search For Text in Excel
- Share an Excel Workbook
- Shortcut to Merge Cells in Excel
- Show Formula in Excel
- Split Cells in Excel
- Separate Text in Excel
- Strikethrough in Excel
- Strikethrough Text in Excel
- Sum by Color in Excel
- Subscript in Excel
- Superscript in Excel
- Themes in Excel
- Timesheet Calculator in Excel
- Top 20 Keyboard Shortcuts in Excel
- Unmerge Cells in Excel
- Uppercase in Excel
- Word Count in Excel
- Word Cloud in Excel
- Watermark in Excel
- Weighted Average in Excel
- Wildcard in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tools (98+)
- VBA (162+)
Insert Comment in Excel (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 a 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
- 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.
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 –