This post describes how to autofit comment box in Excel. While adding a large comment in a cell in Microsoft Excel, you may have noticed that only a part of it is visible to you by default. You need ...
Click on File > Options > Advanced. In the "Display " section, go to "For cells with comments, show:" Select "No Comments or indicators". Click on Ok to validate.