Excel 2013 and Excel 2010 generally shows comments in worksheet with the Indicator as shown below.
And when you hover over the indicator it will display the added comments.
But in case if you are not able see the comments added to your worksheet then try the unhide option available as part of the
- Click the File menu and then the Options link
- In the Excel Option window, navigate to Advanced Options
- Scroll down to display section and For cells with comments radio option select your preferred choice i.e either Indicators only, and comments on hover or Comments and indicators.
4. Click Ok to save and confirm the changes.