Search Contextures Sites

Excel Comments -- Tips Some tips for working with Excel comments. Change the User Name Change Comment Shape -- Excel 2007/2010 Change Comment Shape -- Excel 2003 Add a Picture to an Excel Comment Change the default Font Size  Change the Comment Indicator Colour  Alternative to Excel Comments

Change the User Name Instead of showing the user name at the start of an Excel comment, you can change to something generic, such as "Note:" However, this change affects the User Name in all Microsoft Office programs, so you may want to reset the name before you exit Excel. Choose Tools|Options Select the General tab Delete the existing User Name, and type a new entry Click OK

Change the Comment Shape Add a bit of interest to a worksheet, by changing the comment shape from a rectangle. To change the comment shape in Excel 2007 or Excel 2010: A) Add the Change Shape command to the QAT At the right end of the QAT, click the drop down arrow Click More Commands In the Choose Commands From drop down, click All Commands In the list of commands, click Change Shape, and click Add, to move it to the Quick Access Toolbar Close the Excel Options window. B) Change the comment shape Right-click the cell which contains the comment. Choose Edit Comment Click on the border of the comment, to select it. On the QAT, click the Change Shape command, and click on a shape to select it. When finished, click outside the comment. Watch the video, to see the steps for adding the Change Shape command to the QAT and changing the comment shape in Excel 2010 or Excel 2007.

To change the comment shape in Excel 2003: Right-click the cell which contains the comment. Choose Edit Comment Click on the border of the comment, to select it. On the Drawing toolbar, click the Draw button Choose Change AutoShape, and choose a category. Click on a shape to select it. When finished, click outside the comment.

Add a Picture to an Excel Comment Right-click the cell which contains the comment. Choose Show/Hide Comments, and clear any text from the comment. Click on the border of the comment, to select it. Choose Format|Comment On the Colors and Lines tab, click the drop-down arrow for Color. Click Fill Effects On the picture tab, click Select Picture Locate and select the picture To keep the picture in proportion, add a check mark to Lock Picture Aspect Ratio Click Insert, click OK, click OK Watch the steps in this short Excel video tutorial:

Change the Default Font Size You can change the font size of new Excel comments by changing the settings in your Control Panel. (Instructions for Windows XP) Right-click on the desktop, and choose Properties On the Appearance tab, click Advanced. From the Item dropdown, choose Tooltip Choose a font Size, click OK, click OK (Note: selecting a font type here will not affect the default font used in Excel comments)

Change the Comment Indicator Colour Comment indicators are red, and there's no option to change that setting. As a workaround, you can draw triangular shapes over the indicators, and fill them with a different colour from the palette. For instructions, see Excel Comments -- VBA

Alternative to Excel Comments Add a comment to a Data Validation Input Message, and it can be displayed when you tab to the cell. Select the cell in which you want to see the message Choose Data|Data Validation Click on the Input Message tab to activate it Add a check mark to 'Show input message when cell is selected' Type your message heading text in the Title box. This text will appear in bold print at the top of the message. Type your message in the Input message box. Click OK

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

 

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

Last updated: December 21, 2011 11:03 AM