98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Comments
Comments
Resolved · Low Priority · Version 2003
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Using Alt in Save Dialog BoxWhen you are saving (or opening) a file, try these; |