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. Note: To help prevent replacing existing data when. In the Advanced category, under Editing options, select or clear the Enable fill handle and cell drag-and-drop check box. You can turn this option on or off as needed by doing the following: Click File > Options. 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". Drag the fill handle to copy data or to fill adjacent cells with a series of data. (see screenshot below) 3 Select a color you want. 2 Click/tap on Text cursor on the left side, and click/tap on Pick a custom text cursor indicator color under the Use text cursor indicator section on the right side. When the Excel Options window appears, click on the Advanced option on the left. 1 Open Settings, and click/tap on the Ease of Access icon. 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. 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.
If you want to change the font color, look for the uppercase A with a colored bar under it in the.
Go to After pressing Enter, move selection and use Direction arrow to choose a direction. By default, your text in Excel 2016 appears in a black font. 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. Mac Excel: Go to Excel > Preferences > Edit.
0 kommentar(er)
