How to modify comments and indicator preferences in Excel

How to modify comments and indicator preferences in Excel

By default upon adding a comment to a cell under Excel, only the comment indicators will be displayed (Comments appears upon mouse over). If you want to have your comments permanently displayed in your spreadsheet or just change your preferences, follow these steps.

How to modify comments and indicator preferences in Excel

  • Click on File > Options > Advanced.
  • In the "Display " section, go to "For cells with comments, show:"
  • Select "No Comments or indicators".
  • Click on Ok to validate.

Photo by Scott Graham on Unsplash

NEED MORE HELP WITH EXCEL? CHECK OUT OUR FORUM! 

Subject Replies
Convert number to spelling 28
How to calculate positions (1st,2nd,3rd...) in Excel 6
Comparing two columns of names in Excel 8
Unable to change date format in Excel 39
Excel - IF function with multiple words 14
Copying data from one Excel sheet to another. 30
How to convert number into text in Excel 9
If a cell contains any text then add a value 20
Date formatting in dd/mm/yyyy 11
Removing " false" value in "IF" 10
Around the same subject

Excel