Editing Comments

Once a comment has been added to a cell in a worksheet, it is easy to edit the comment. All you need to do is right-click on a cell to which a comment is attached, then you can choose Edit Comment from the resulting Context menu. If you prefer, you can simply select the cell that has a comment attached and choose Edit Comment from the Insert menu. Either method results in the insertion point appearing inside of the comment text box. You can then add more text or delete text, as desired.

Another way to edit comments is available if you have all the comments displayed on-screen. (By choosing Comment & Indicator from the View tab of the Options dialog box, as discussed in the previous tip.) In this instance, you can edit a comment simply by positioning the insertion point within the text box and clicking on the mouse button. The text box becomes active and you can edit to your heart's content.