Monday, May 26, 2014

Change Default User Name


Excel by default picks up the system login ID as the user name. All the Excel files you create will be stamped with your login name as author. Also, when you insert a comment, every comment by default starts with the user name.

If you don't like the default logic ID to be your Excel user name, you can change it and put any name you fancy. Let's see how to do it.

Excel 2010 and later:

File tab > Options > General > Personalize your copy of Microsoft Office segment > type a name in the User Name.

Excel 2007:

Click the Microsoft Office button > Excel Options > Popular tab > Personalize your copy of Microsoft Office segment > type a name in the User Name.

Excel 2003:

Tools menu > Options > General tab > > type a name in the User Name.

Points to remember:
  1. User Name cannot be more than 52 characters. You can have special characters too in the name.
  2.  If you keep user name field blank, Excel automatically places the Windows user name.
  3. Changing the user name will effect the future workbooks. Files already saved with earlier user name will not be updated.

No comments:

Post a Comment