Most valuable professional
  • Excel Book Excerpt

Excel Control How Your Name Appears in Comments

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Control How Your Name
Appears in Comments

Problem: When I insert a comment, the name displayed in bold is Customer. Can I change this so everyone knows which comments I inserted?

LE10001306.jpg 

Figure 1254 The comment offers a generic name.

Strategy: You can change the name that is displayed in comments. To do so, you select File, Options. At the bottom of the first category, edit the User Name to the name you would like displayed in comments.

LE10001307.jpg 

Figure 1255 Change the name displayed in comments.

Additional Details: Would you prefer no name in the comments? If you completely erase this field, Excel will pick up the computer user name. If you put a space, the comment will appear with a space and a colon in row 1.

LE10001310.jpg 

Figure 1256 You can’t completely remove the default comment name.

If you want to remove the name from a single comment, you can select the name and press Delete or backspace through the name. Be careful that your comment doesn’t end up in bold. Typically, the name will appear in bold, and the comment you type will appear in normal font.

LE10001308.jpg 

Figure 1257 Name in bold, comment in normal font.

When you backspace through the name and then begin to type, Excel will be in bold mode, and any comment you type will appear in bold.

LE10001309.jpg 

Figure 1258 When you clear the comment, you are left in bold mode.

To turn off the bold mode, press Ctrl+B before you begin to type the comment.

<-Previous Topic                    Next Topic->

For more resources for Microsoft Excel: