Use the previous/next buttons to preview the comments one by one. The Show All Comments option shows all the comments on all worksheets in the workbook, and the workbooks you create while the option is active. To hide all the comments, click Show All Comments again to undo the previous action. If you want to show all the comments in the workbook, click the Review tab and then the Show All Comments button.Alternatively, click the review tab to open the commenting tools and click the show/hide comments. Right-click somewhere on the cell and select either show or hide the comment.If you want to hide or show the comment in each cell, do the following: To view the comment, hover your mouse pointer over the cell with a small red triangle.īy default, Excel is designed to keep the comments hidden, and each comment can be viewed by hovering over the cell with the comment.The triangle makes it easy to locate the cell with a comment. An inverted small red triangle will appear at the right corner of the cell. Then, click on the outside of the cell to close editing.Click the Review tab to expand the commenting tools and then click on “New Comment.” A new text box will appear, and it contains the name of the user and an insertion point located at the start of a new line below the user name.To add a comment to a cell, start by placing the cursor on the cell you want to add a comment, right-click on the cell, and scroll down the list to the Insert Comment command.Īlternatively, follow the following steps: While there are different Excel versions, adding comments in all the versions is done in almost the same way. Users can also resize and move the Excel comment box.Excel provides users with the flexibility of editing, deleting, and showing or hiding comments on an Excel worksheet.Excel comments are used to add a note or explain a formula in a cell.