How do I hide a comment box??

Dear Nicola

Hiding a Comment box is quiet simple. All you have to do is move your mouse away from the cell which contains the Comment!!

You can simply go to View > Comments to view all your comments. If it gets too much and the comment boxes obscure your view then you can either drag them away from the worksheet may be near the formula bar or toolbars. Note that there will be an arrow attached to it.

You will see a new Reviewing toolbar appear on your screen. You can click on the fifth button from the left hand side called “Hide all Comments” stop displaying.

A quick tip: Sometimes when you have a lot of comments attached to the cells and you try to go from one cell to another the comment boxes become nuisance and you wish you could make them disappear!! Well the good news is that you can!!

Choose Tools > Options… and in the View tab choose None in the comments section. Press OK. NB: Even the red triangles (that normally indicate that the cell has a comment attached to it) will disappear. Please note that it doesn’t delete your comments. After you have entered all your data you might want to go back to Tolls > Options… and then choose comment indicator only in the Comment section!!

Ctrl+Shift+O (This is Letter O). This will select all the cells that contain comments.

I hope that answers your question.

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000/2003