Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Convert text string to valid reference in Excel using Indirect function
  • Get nth match with INDEX / MATCH in Excel
  • To count total rows in a range in Excel
  • How to get relative row numbers in a range in Excel
  • Approximate match with multiple criteria in Excel

Data Analysis Examples

  • Get column name from index in Excel Table
  • Working With Tables in Excel
  • Filter Data Based on Date in Excel
  • How to sum a total in multiple Excel tables
  • Remove Duplicates Example in Excel

Data Validation Examples

  • Excel Data validation date in next 30 days
  • Excel Data validation allow uppercase only
  • Excel Data validation whole percentage only
  • Prevent invalid data entering in specific cells
  • Excel Data validation must contain specific text

How To Insert, Edit Show or Hide Comments

by

You can insert a comment in Excel to give feedback about the content of a cell.

Insert Comment

To insert a comment, execute the following steps.

1. Select a cell.

2. Right click, and then click Insert Comment.

3. Type your comment.

Excel displays a red triangle in the upper-right corner of the cell.

4. Click outside the comment box.

Worked Example:   How to create dynamic named range with OFFSET in Excel

5. Hover over the cell to view the comment.

Excel automatically adds your user name. To change this name, execute the following steps.

6. On the File tab, click Options.

7. Change the User name.

Edit Comment

To edit a comment, execute the following steps.

1. Select the cell with the comment you want to edit.

Worked Example:   Check if range contains a value not in another range in Excel

2. Right click, and then click Edit Comment.

3. Edit the comment.

Note: To delete a comment, click Delete Comment.

Show/Hide Comment

By default, a comment is only visible when you hover over the cell that contains the comment. To keep a comment visible all the time, execute the following steps.

Worked Example:   Flash Fill in Excel

1. For example, select cell B4 below.

2. On the Review tab, in the Comments group, click Show/Hide Comment.

3. Select another cell.

Note: to hide the comment, select cell B4 and click Show/Hide Comment again. To keep all comments visible all the time, click Show All Comments.

Post navigation

Previous Post:

How to use Custom Lists to fill range in Excel

Next Post:

Hide and Unhide Columns or Rows in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to strip html from text or numbers in Excel
  • Count Number of Words in Excel
  • Remove text by variable position in a cell in Excel
  • Split numbers from units of measure in Excel
  • How to convert numbers to text using TEXT function in Excel
  • Display Days until expiration date in Excel
  • Create date range from two dates in Excel
  • Calculate expiration date in Excel
  • Convert decimal minutes to Excel time
  • SECOND function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate Net Present Value (NPV) in Excel
  • Calculate interest for given period in Excel
  • DISC function: Description, Usage, Syntax, Examples and Explanation
  • YIELDMAT function: Description, Usage, Syntax, Examples and Explanation
  • INTRATE function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles