Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

comments

ResolvedVersion 2003

Sarah has attended:
Excel Intermediate course

Comments

How do I add a comment?

Edited on Mon 14 Jul 2008, 12:43

RE: Comments

Hi Sarah,

Thank you for your post, welcome to the forum.

In answer to your question, to insert a comment and some other options of working with comments follow these steps:

Adding comments to worksheets cells; Comments explain the contents of the cells, or to offer tips to users.

To Insert a Comment
1. Select the cell in which you want the comment.
2. Choose Insert>Comment
3. Type your comment where the cursor is flashing.
4. Text will wrap automatically. If you want to start a new line, press the Enter key.
When finished, click outside the comment box
To Display a Specific Comment
1. Right-click the cell which contains the comment.
2. Choose Show Comment
To hide the comment:
1. Right-click the cell which contains the comment.
2. Choose Hide Comment
To Display All Comments
1. Choose View>Comments
Note: All comments in all open workbooks will be displayed.
To hide the comments, choose View>Comment
To Use the Reviewing Toolbar
If you're doing extensive work with comments, you might save time by using the Reviewing Toolbar. Use its buttons, instead of choosing commands from the Menu Bar.
1. To open the Reviewing toolbar, choose View>Toolbars
2. If the active cell contains a comment, the Reviewing Toolbar displays the following Comment buttons:
a) Edit comment b) Previous comment c) Next comment
d) Show comment e) Show all comments f) Delete comment
3. If the active cell does not contain a comment, the Reviewing Toolbar displays the following Comment buttons:
a) New comment b) Previous comment c) Next comment
d) N/A e) Show all comments f) N/A
To Format Text in a Comment
You can change the font, the font size, font colour and font style, for all or part of a comment.
1. Right-click the cell which contains the comment.
2. Choose Edit Comment
3. To format all text, click on the border of the comment shape.
To format specific text within the comment, drag over the text to select it.
4. Use the Font tools on the Formatting toolbar to modify the text appearance
When finished, click outside the comment box.
To Print Comments
You can print comments as displayed on the worksheet, or print them at the end of the worksheet
To print as displayed:
1. Show specific comments or all comments.
2. Choose File>Page Setup
3. On the Sheet tab, from the Comments dropdown, choose 'As displayed on sheet'.
4. Click Ok
5. Choose File>Print (or click the Print button)
To print at the end of the worksheet:
1. Choose File>Page Setup
2. On the Sheet tab, from the Comments dropdown, choose 'At end of sheet'.
3. Click Ok
4. Choose File>Print (or click the Print button)

I hope those are helpful, regards Pete

Excel tip:

Editing a formula quickly

If you want to edit a fomrula or text quickly witin a cell instead of the formula bar, you can click either double click in the cell or press the F2 key

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.