If you hover over the cell, the comment will appear. The comment indicator is the red triangle positioned in the top right corner of the cells that contain comments. Now when you return to the Excel spreadsheet, you should see the comment indicator. Then scroll down to the Display section in the right side of the window and select the option called " Indicators only, and comments on hover". When the Excel Options window appears, click on the Advanced option on the left. To apply the most recently selected text color, click Font Color. To turn on the comment indicator, select the File tab in the toolbar at the top of the screen and then click on Options at the bottom of the menu. How to select data in a cell On the Home tab, in the Font group, do one of the following: To change the text color, click the arrow next to Font Color and then, under Theme Colors or Standard Colors, click the color that you want to use. What can I do to remedy this in Microsoft Excel 2016?Īnswer: As you can see, the little red triangle is not being displayed in cell A3 even though there is a comment in that cell. Question: When a comment has been inserted in a cell, the little red triangle is not being displayed to indicate a comment in a cell.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |