You can insert a comment in a cell using the Ribbon: Check Comments and indicators if you wish comments and indicators to display. Check Indicators only, comments on hover to display the red markers. Check No comments or indicators if you do not want the red markers to display. In the area For cells with comments, show, choose the desired option.In the right panel, scroll down to the Display section.Click the Advanced category in the left panel.Click the File tab in the Ribbon and then click Options.To control the display of comments and indicators through Excel's Options:
By default, when you insert comments in cells, Excel will display indicators as red markers in cells with comments. If you are using the comments feature within Excel, the first thing you should do is specify options as to how you want comments to display. Recommended articles: How to Hide Excel Worksheets and How to Hide Formulas from Clients, Colleagues and Other Usersĭo you want to learn more about Excel? Check out our virtual classroom or live classroom Excel courses > Setting options to manage the display of comments and indicators Although you can also insert text boxes with comments, we'll forgo that method here. Note that this article applies to Excel 20 and not 2016 and newer versions of Excel which have threaded comments and traditional comments are called notes. After you insert comments in cells, you can edit, show, hide and delete comments. You can insert comments in Microsoft Excel using the comments feature. How to Easily Insert, Edit, Delete, Show and Hide Comments in Excel Workbooksīy Avantix Learning Team | Updated December 9, 2019Īpplies to: Microsoft ® Excel ® 20 (Windows)
0 kommentar(er)
