Unfreeze panes If the comment appears at the top of the window or worksheet and the bottom or right half of the comment is cut off, you may have frozen panes. To view the entire comment, click Unfreeze Panes on the Window menu.
Enlarge the comment box Right-click the cell that contains the comment, click Edit Comment on the shortcut menu, and then drag the handles until you can see all of the comment text.
I don't want my name in the comments.
To prevent your name from appearing in a comment, select your name and then press the DELETE key.
You can change the name that appears when you insert new comments, but you can't keep Microsoft Excel from including your user name. To change the name, click Options on the Tools menu, click the General tab, and type the name you want in the User name box. If you delete this name, Excel uses the default user name you've established for your computer.
Keep in mind that Excel also uses the user name for sharing workbooks and for identifying users when files containing multiple changes are merged.
Comments in a PivotTable report don't stay with their cells.
Comments in a PivotTable report remain anchored to the cells where you entered them, not to the data in a cell. If you change the layout of the report so that the data values move to different cells, the comments do not move with the data.