Search Contextures Sites

Excel Comments -- Basics Add Excel comments to worksheets cells, to explain the contents, or to offer tips to users. Insert an Excel Comment Display a Specific Comment Display All Comments Use the Reviewing Toolbar Format Text in a Comment Printing Excel Comments Excel Comments -- Tips Excel Comments -- VBA

Insert an Excel Comment Select the cell in which you want the comment. Choose Insert|Comment Type your comment where the cursor is flashing. Text will wrap automatically. If you want to start a new line, press the Enter key. When finished, click outside the comment box

Display a Specific Comment Right-click the cell which contains the comment. Choose Show Comment   To hide the comment: Right-click the cell which contains the comment. Choose Hide Comment

Display All Comments Choose View|Comments Note: All comments in all open workbooks will be displayed. To hide the comments, choose View|Comment

Use the Reviewing Toolbar If you're doing extensive work with Excel comments, you might save time by using the Reviewing Toolbar. Use its buttons, instead of choosing commands from the Menu Bar. To open the Reviewing toolbar, choose View|Toolbars 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

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

Format Text in an Excel Comment You can change the font, the font size, font colour and font style, for all or part of an Excel comment. Right-click the cell which contains the comment. Choose Edit Comment 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. Use the Font tools on the Formatting toolbar to modify the text appearance When finished, click outside the comment box.

Printing Excel Comments You can print Excel comments as displayed on the worksheet, or print them at the end of the worksheet   To print as displayed: Show specific comments or all comments. Choose File|Page Setup On the Sheet tab, from the Comments dropdown, choose 'As displayed on sheet'. Click Ok Choose File|Print (or click the Print button)    To print at the end of the worksheet: Choose File|Page Setup On the Sheet tab, from the Comments dropdown, choose 'At end of sheet'. Click Ok Choose File|Print (or click the Print button)    To print a worksheet with comment indicators: See instructions in Comments -- Programming

Excel Comments -- Basics Excel Comments -- Tips Excel Comments -- VBA

Home     Excel Tips     Excel Files     The Excel Store     Blog     Contact
Privacy Policy		Contextures Inc., Copyright © 2009. All rights reserved.	Debra Dalgleish