Show All Comments
You can use Show All Comments button to show/hide all comments on an Excel worksheet. It is especially useful when you need to work on a workbook which has many cell comments.
Comments can be very obstructive if they are many and all visible. You may need to switch them on and off to be able to work effectively. This can be done by clicking on a cell and selecting show/hide comments option from right-click menu. But with a large amount of cells with comments, it will take too much time and effort.
To show/hide all comments on a worksheet at once, you can use Show All Comments button on Review Tab of menu ribbon. This button will show all comments on a worksheet with first click and hide all comments with the second one.