Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to calculate correlation coefficient Correlation in Excel
  • Get column index in Excel Table
  • How To Remove Duplicates In Excel Column Or Row?
  • How to count table columns in Excel
  • How to combine 2 or more chart types in a single chart in Excel

References

  • How to get first row number in range in Excel
  • How to retrieve first match between two ranges in Excel
  • How to use Excel INDIRECT Function
  • How to create dynamic named range with OFFSET in Excel
  • Basic INDEX MATCH approximate in Excel

Data Validations

  • Excel Data validation date in specific year
  • Data validation must not exist in list
  • Excel Data validation must not contain
  • Excel Data validation no punctuation
  • Excel Data validation whole percentage only

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:   To count total rows in a range 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:   How to test for all values in a range are at least 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:   Cell References: Relative, Absolute and Mixed Referencing Examples

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:

MDETERM function: Description, Usage, Syntax, Examples and Explanation

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

Logical Functions

  • OR function: Description, Usage, Syntax, Examples and Explanation
  • Complete List of Excel Logical Functions, References and Examples
  • How to use Excel AND Function
  • Not Equal To ‘<>‘ operator in Excel
  • XOR function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Get day from date in Excel
  • Count dates in current month in Excel
  • Get last day of month in Excel
  • WORKDAY.INTL function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate quarter from date in Excel

Grouping

  • Group numbers with VLOOKUP in Excel
  • How to randomly assign data to groups in Excel
  • Calculate conditional mode with criteria in Excel
  • Map text to numbers in Excel
  • Group times into 3 hour buckets in Excel

General

  • How to generate random date between two dates in Excel
  • Excel Ribbon Quick Overview For Beginners
  • Sum by group in Excel
  • Check if multiple cells have same value with case sensitive in Excel
  • How to get random value from list or table in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning