How to Remove Last Modified By in Excel (3 Ways)

Microsoft Excel has the feature of different types of document properties, the ways of viewing and modifying these properties as per the users’ needs and choices, repeat last action performed, etc. This software allows making your data confidential. For this purpose, it provides some system properties. “Last modified By’ is such a property. If you are looking for ways to remove the last modified by in Excel, then you have landed in the right place.  In this article, I will show you how to remove the last modified by in Excel.


Why Should We Remove “Last Modified By”?

Every Excel file contains some information like Author name, Organization name, Initials, etc. It contains these data by default. Actually, these data are gathered from the device of the user. It’s not a matter of fact actually because Excel allows you to make modifications to this information. You can change this data as per your need.

The user making modifications for the last time is saved in the system interface. When we share the Excel file with someone and we want to hide the user information, then we need to remove the “Last Modified By” to make it confidential to the shared user.


Advantages & Disadvantages of Removing Last Modified By

The main advantage of removing the last modified by is that it makes it confidential by hiding the user id that has changed the file for the last time. So, if the file is somehow shared with a person or organization that it was not supposed to be, then it may be helpful to hide the information about the actual creator of the file.

The disadvantage of performing this task is that some changes while making modifications to the information cannot be undone. You will see this note while performing the task.


3 Effective Ways to Remove Last Modified By in Excel

In this section, you will find 3 simple and effective ways to remove the last modified by in Excel. I will demonstrate them one by one here. Let’s check them now!


1. Use Properties Option to Remove Last Modified By

Actually, the Microsoft team has observed that the “Last Modified By” is one of the default document options that remove the value only. So if you reject to see the value in the property option, follow the steps below.

Steps:

  • First of all, right-click the mouse on the workbook> click the Properties option from the list.

  • Then, the Properties modifier box will appear.
  • Here, go to the Details icon> click Remove Properties & Personal Information.

Properties Box to Remove Last Modified by in Excel

  • Now, select Remove the following properties from this file> select Author & Last Saved By options from the origin> click OK.

And here, the last modified by will be removed.

  • You may also proceed with creating a copy with all possible properties removed.

Read More: How to Make a Modified Box Plot in Excel (Create and Analyze)


Similar Readings


2. Remove Last Modified By from File Tab

You can perform the same task from the File tab also. For this, follow the steps below.

Steps:

  • Firstly, open the workbook and go to the File tab.

  • Then, a menu list will appear. Select Info from the list.

Menu list to remove Last Modified By

  • Now, right-click on the Author option like the screenshot below> click Remove Person.

Remove Author name to Remove Last Modified By in Excel

Thus your task will be completed.

Read More: How to Show Menu Bar in Excel (2 Common Cases)


3. Using Inspect Document Command

You can use the Inspect Document Command to clear any confidential data or information from the workbook. In order to demonstrate the process, just proceed with the steps below.

Steps:

  • Firstly, go to the File tab.
  • Then, select the Info option from the menu list> click Check for Issues> select Inspect Document.

  • Now, the Document Inspector command box will appear.
  • Here, click Inspect.

Document Inspector to Remove Last Modified By in Excel

  • After Inspecting, a segment will appear with a “!” sign just under the comment segment named Document Properties and Personal Information. This will occur because it has found some document information. Now, click Remove All to clear the information.

Inspect to Remove Last Modified By

  • Now, close the command box.

Close Document Inspector

  • If you check the properties now (from the Info window), you will see all information has been removed.

Check Properties

Read More: How to Move Data from Row to Column in Excel (4 Easy Ways)


Things to Remember

  • Some changes can’t be undone when you remove the property.
  • You don’t have to perform the action when your file doesn’t contain any confidential information.

Conclusion

In this article, I have tried to show you some methods to remove the last modified by in Excel. Hope you have got familiar with the ways of performing this task. If you have better methods, questions, or feedback regarding this article, please don’t forget to share them in the comment box. This will help me enrich my upcoming articles. You can also check our website for further information. Have a great day!


Related Articles

Rafi

Rafi

Hey there! I am Md. Rafiul Hasan. Currently I am working as an Excel & VBA content developer. I like new ideas and want to explore the field of innovation. Excel has saved our worktime and made it easy for us to quick calculations. I am trying to make it easier for you to overcome the obstacles you face while working on Excel. Stay connected!

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo