The following Options dialog box appears in 20: 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 using Excel's Options in Excel 20: By default, when you insert comments in cells, Excel will display indicators as comment markers or red markers in cells with comments. If you are adding comments in Excel, you can specify options as to how you want comments to display in your workbook.
Managing the display of comments and indicators Threaded comments appear with a comment marker as opposed to the traditional red marker.
Options for 2016 and later versions are therefore slightly different from earlier versions of Excel. In Excel 2016, comments changed to threaded comments and the legacy comments became notes. Recommended articles: How to Hide Formulas from Clients, Colleagues and Other Users The N function has been around for a long time so you can use it in older versions of Excel. In addition to adding comments in Excel, there is a little known function called the N function that you can use to enter notes directly within a formula. You can hide comments and notes in Excel workbooks. Hide Notes and Comments in Microsoft Excelīy Avantix Learning Team | Updated October 17, 2020Īpplies to: Microsoft ® Excel ® 2010, 2013, 2016, 2019 and 365 (Windows)
0 kommentar(er)
