This article will show you how to add or change document author and document properties with following methods. What would cause this to happen in some documents and not others? Step 2: Click the blue File tab at the top-left corner of the window. Text, oldName, newName Next Next End Sub 2. Changing the Name of the Cell Comments Author in Excel Before learning about how to change the author name in the comments box, we have to understand about the comments. You can change it as you like.
Short of using a macro that you would have to trigger for each comment, I know of no simple way to stop the insertion. Would you like to answer one of these instead? The time has come to tell you about different types of document properties, the ways of viewing and changing them in Excel 2016, 2013 and 2010. After adding a comment, you will find your name appears together with the comment. Now the author name for that specific document is replaced. No matter what your case is, it shall do you no harm to learn ways to delete or change personal information on computer or digital documents, especially in an age when privacy breaches happen all the time. Saving an excel sheet in prep to email results to customer.
The selections and text of the other users would be visible in different colors. Then, in the box next to User name, delete your name and add the label of your choice. When you insert the comments into a worksheet, the name of the comment author is automatically inserted into the comment followed by a colon. Press Ctrl + Semi-colon ; on the keyboard and Excel will write the current date into the currently selected Excel cell. Finally, click in the text area of the comment and type away—anonymously. We can use comments in Excel to remind ourselves and inform someone else about what the cell contains.
If you want to change the author name of your Word, Excel, PowerPoint document that you have already created in or 2007 versions, after a jump you find the method to do that. When working with Word or Excel document, it is very common to when you view them. Selections of other users Users using Microsoft Excel or Excel online would be able to see other users on a list on the top. Then change the user name and initials. When someone views the workbook properties through the Document Properties or Info panels, the author is one of the few items automatically labeled.
To make it easier, Excel online allows a comment section to discuss this among users. How can I stop Excel from doing that? Not the answer you're looking for? In these last two versions they are hidden deeper, but it won't take you much time to dig them out. I am using Microsoft Word 2007 in Compatibility Mode. More often than not, the built-in feature is not enough. When adding new comments, the name is gone! The program was developed in Excel 2003, maybe on the desktop that person had been using. Change author name of all existing comments in workbook: If you want to change existing comments author name, Kutools for Excel would help you to do easily.
To run the macro, select a cell in which you want the no-name comment to appear and click on Tools, point to Macro and click on Macros. When you create the comment box, the colon will remain. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 on this site the. When I insert a comment or make a revision to some Microsoft Word documents the comment or revision correctly reflects my User Name as the reviewer. Worst of all, there seems to be a bug that randomly reverts this setting.
However, the author name of the old comments still kept the old one. You would be using these file formats:. It will not change the author name that is automatically generated for all documents that you create in Word 2010. After inserting the comment it appears with little red triangles to indicate comments in cells. Once you have a new Excel module, simply copy and paste one of the following code snippets into this module. Can you elaborate the answer better.
For changing author names in the whole workbook, please select All Sheets option. Most people simply use their first and last name. It's a document setting, not a user setting except, I believe, on new documents created by you, in which case it uses it as a default setting I may be wrong, but this is how I came across to understanding it. So, a can be a huge help. It is the best choice when you want a multipurpose tool for web experience. With this utility, you can easily change the author name of all existing comments to the new one you need not only in active sheet, but also in the whole workbook. Changing the Author Name on a Document in Word 2010 Note that the steps below will only change the author name for a specific document.