MrExcel.com - Your One Stop for Excel Tips & Solutions

Control How Your Name Appears in Notes

November 02, 2023 - by

Control How Your Name Appears in Notes

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

Sometimes, the name in the Note is wrong. Here, it says "Customer"
Figure 1403. The note offers a generic name.

Strategy: You can change the name that is displayed in notes. 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 notes.

File, Options, General. There is a User Name field. This name is used in the Note.
Figure 1404. Change note name.

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

Make the user name (in Excel options) be a space. Now, the note appears with a space, colon on line 1 and you can type your comment in row 2.
Figure 1405. You can’t completely remove it..

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

The name is Bold in line1, then your note is not bold in line 2.
Figure 1406. Bold name. Normal note.

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

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

When you backspace through your name, the bold setting is turned on. Type a note and it will be in bold.
Figure 1407. When you clear the note, you are left in bold mode.

This article is an excerpt from Power Excel With MrExcel

Title photo by Austin Kirk on Unsplash