How to view, change and remove document properties in Excel

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. In this article you'll also learn how to protect your document from any modifications and remove personal information from your Excel worksheet.

Do you remember your feelings when you just started to use Excel 2016 or 2013? Personally I sometimes felt angry when I couldn't find the necessary tool or option at the place where they were in the previous Excel versions. This is what happened to the document properties in Excel 2010 / 2013. In these last two versions they are hidden deeper, but it won't take you much time to dig them out.

In this article you will find a detailed guide how to view and change the document properties, protect your document from any modifications and remove personal information from your Excel worksheet. Let's get it started! :)

Types of document properties

Before starting to learn how to view, change and remove document properties (metadata) in Excel, let's clear up what kinds of properties an Office document can have.

Type 1. Standard properties are common to all Office 2010 applications. They contain basic information about the document such as title, subject, author, category, etc. You can assign your own text values for these properties to make it easier to find the document on your PC.

Type 2. Automatically updated properties include the data about your file that are controlled and changed by the system such as the file size and the time the document was created and modified. Some properties that are unique to the document at the application level such as the number of pages, words or characters in the document or the version of the application are automatically updated by the document content.

Type 3. Custom properties are user-defined properties. They allow you to add other properties to your Office document.

Type 4. Properties for your organization are properties specific to the organization.

Type 5. Document library properties refer to documents in a document library on a Web site or in a public folder. A person who creates a document library can set some document library properties and rules for their values. So when you want to add a file to the document library, you have to enter the values for any properties that are required, or correct any properties that are wrong.

View document properties

If you don't know where to find the information about your document in Excel 2016-2010, here are three ways to do it.

Method 1. Show the Document Panel

This method allows you to see the information about your document right in the worksheet.

  1. Click on the File tab. You switch to the backstage view.
  2. Choose Info from the File menu. The Properties pane is shown on the right-hand side.
    Here you can already see some information about your document.
    Choose Info from the File menu to display the Properties pane
  3. Click on Properties to open the drop-down menu.
  4. Choose 'Show Document Panel' frоm the menu.
    Choose 'Show Document Panel' from the properties drop-down list to display the panel

    It'll automatically take you back to your worksheet and you'll see the Document Panel placed between the Ribbon and the working area as on the screenshot below.
    The Document Panel is placed between the Ribbon and the working area

As you see, the Document Panel shows a limited number of properties. If you're eager to know more about the document, move to the second method.

Method 2. Open the Properties dialog box

If you can't find the necessary information in the Document Panel, take the Advanced Properties into use.

The first way to display the Advanced Properties is right from the Document Panel.

  1. Click on 'Document Properties' in the top-left corner of the Document Panel.
  2. Choose the Advanced Properties option from the drop-down list.
     Click on 'Document Properties' in the top-left corner of the Document Panel and choose 'Advanced Properties'
  3. The Properties dialog box will show up on the screen.
    Click on the Summary tab to see the information about your document

Here you can see general information about your document, some statistics and document contents. You can also change the document summary or define additional custom properties. Do you want to know how to do it? Be patient! I'll share it with you a bit later in this article.

There is one more way to open the Properties dialog box.

    Go through the first three steps that are described in Method 1.

  1. Choose 'Advanced Properties' from the Properties drop-down menu.
    Choose 'Advanced Properties' from the properties drop-down menu to open the properties dialog window

The same Properties dialog box will appear on the screen as on the screenshot above.

Method 3. Use Windows Explorer

One more easy way of displaying the metadata is to use Windows Explorer without opening the worksheet itself.

  1. Open the folder with Excel files in Windows Explorer.
  2. Select the file you need.
  3. Right-click and choose the Properties option in the context menu.
    Right-click on the file and choose Properties
  4. Move to the Details tab to view the title, subject, author of the document and other comments.
    Click on Details to see the information about the document

Now you know different ways of viewing the document properties on your PC and I am sure you'll find the necessary information without any problems.

Modify document properties

Earlier I promised to tell you how to change the document properties. So when you view properties using Method 1 and Method 2 described above, you can immediately add the necessary information or correct invalid data. As for Method 3, it's also possible if you don't have Windows 8 installed on your computer.

The quickest way to add an author

If you need just to add an author, there is a very quick way to do it right up in Excel 2010 / 2013 backstage view.

  1. Go to File -> Info
  2. Move to the Related People section on the right side of the window.
  3. Hover the pointer over the words 'Add an author' and click on them.
    Move to the Related People section to add an author
  4. Type in an author's name in the field that appears.
  5. Click anywhere in the Excel window and the name will be automatically saved.
    Type in a new author's name in the text field

You can add as many authors as there are working on the document. This quick method can be also used for changing the title or adding a tag or a category to the document.

Change the default author name

By default, the document author name in Excel is your Windows username, but this might not properly represent you. In this case you should change the default author name so that Excel will use your proper name later on.

  1. Click on the File tab in Excel.
  2. Choose Options from the File menu.
    Choose Options from the File menu to display the Excel Options dialog window
  3. Select General on the left pane of the Excel Options dialog window.
  4. Move down to the Personalize your copy of Microsoft Office section.
  5. Type in the proper name in the field next to User name.
  6. Click 'OK'.

    Type in a new name in the User name text box to change the default author name

Define custom properties

I've already mentioned that you can define additional properties for your Excel document. Follow the steps below to make it real.

  1. Navigate to File -> Info
  2. Click on Properties on the right side of the window.
  3. Select 'Advanced Properties' from the drop-down list.
  4. Click on the Custom tab in the Properties dialog box that appears on your screen.
    Click on the Custom tab to define a custom property
  5. Choose a name for the custom property from the suggested list or type in a unique one in the Name field.
  6. Select the data type for the property from the Type drop-down list.
  7. Type in a value for the property in the Value field.
  8. Press the Add button as shown below.
    Choose a name, type and enter a value to add the custom property

    Note: The value format must meet your choice in the Type list. It means if the chosen data type is Number, you have to type in a number in the Value field. Values that don't match the property type are saved as text.
  9. After you add a custom property you can see it in the Properties field. Then click 'OK'.
     Click Add to see a new custom property in the properties field

If you click on the custom property in the Properties field and then press Delete -> OK, your just-added custom property will disappear.

Change other document properties

If you need to change other metadata, except the author's name, title, tags and categories, you have to do it either in the Document Panel or in the Properties dialog box.

  • In case the Document Panel is open in your worksheet,you just need to set the cursor in the field you want to edit and enter the necessary information.
  • If you've already opened the Properties dialog box, switch to the Summary tab and add or update the information in the fields, click OK.

When you get back to the spreadsheet, any changes you made will be automatically saved.

Remove document properties

If you need to cover up your traces left in the document so that nobody will see your name or your organization name in the document properties later, you can hide any property or personal information from the public using one of the following methods.

Make the Document Inspector work

The Document Inspector is actually used for checking the document for hidden data or personal information, but it can help you to remove the properties that you aren't going to share with others.

  1. Navigate to File -> Info.
  2. Find the Prepare for Sharing section. In Excel 2013 this section is called Inspect Workbook.
  3. Click on Check for Issues.
  4. Choose the Ispect Document option from the drop-down menu.
    Click on Inspect Document from the Check for Issues drop-down menu to open the Document Inspector
  5. The Document Inspector window will pop up and you can tick the issues you want to look at. I'd leave them all selected though we're most interested in checking 'Document Properties and Personal Information'.
  6. When you make your choice, click Ispect at the bottom of the window.
    Select the issues that you want to check in the Document Inspector window

    Now you see the inspection results on your screen.

  7. Click on Remove All in each category you're interested in. In my case it's Document Properties and Personal Information.
    Click on Remove All in the necessary category
  8. Close the Document Inspector.

Then I'd recommend you to save the file with a new name if you want to keep an original version with the metadata.

Remove metadata from several documents

If you want to remove properties from several documents at once, use Windows Explorer.

  1. Open the folder with Excel files in Windows Explorer.
  2. Highlight the files you need.
  3. Right-click and choose the Properties option in the context menu.
  4. Switch to the Details tab.
  5. Click on 'Remove Properties and Personal Information' at the bottom of the dialog window.
    Click on 'Remove Properties and Personal Information' to open the Remove Properties dialog window
  6. Select 'Remove the following properties from this file'.
  7. Tick the properties you want to remove or click Select All if you want to remove all of them.
  8. Click OK.

    Tick the properties to remove

    Note: You can remove any document property from the file or several files using this method, even if you have Windows 8 installed on your computer.

Protect document properties

Protection of document properties and personal information is used in case you don't want other people to change any metadata or anything in your document.

  1. Go to File -> Info.
  2. Click on Protect Workbook in the Permissions section.
  3. In Excel 2013 this section is named Protect Workbook.
  4. Choose the Mark as Final option from the drop-down menu.
    Go to the Permissions section to protect the workbook
  5. Then you'll be informed that this document version will be final so that other people won't be allowed to make any changes to it. You need to agree or press Cancel.
    Click Ok to mark the workbook as final

If you want to let some people modify the worksheet after all, you can set a password for those who want to change something in the document.

  1. Stay in the backstage view. If you are out of the backstage view and back to the worksheet, click on the File tab again.
  2. Choose 'Save As' from the File menu.
  3. Open the Tools drop-down list at the bottom of the Save As dialog window.
  4. Select General Options.
    Select General Options from the Tools drop-down list to set a password
  5. Enter a password in the Password to modify field.
  6. Click OK.
    Enter a password in the Password to modify field
  7. Reenter the password to confirm it.
  8. Click OK.
    Reenter the password to confirm
  9. Choose the folder where you'd like to save the document and press Save.

    Now your document is secured from unwanted editing. But be careful! People who know the password can easily remove it from the Password to modify box thus letting other readers change the information in the worksheet.

Wow! This post has turned out to be long! I tried to cover all the bases that concern viewing, changing and removing the document properties so I hope you'll find proper answers to the sore points involving metadata.

You may also be interested in:

43 Responses to "How to view, change and remove document properties in Excel"

  1. Ibrahim says:

    This is a very useful post
    it really helped me a lot.
    Thank you very much.
    keep the good work.

  2. Sandra says:

    I love the details in this post. Thank you very much!

  3. Olessya says:

    Excellent post. Would you know how I could sync the document properties on the server with the custom properties tied to the SharePoint site columns?

    thanks.

  4. mark says:

    I came across this useful article, but I am not sure what the advantage is for using this document property function in excel. Can someone explain the benefit from it ?

  5. shahida says:

    If you want to let some people modify the worksheet after all, you can set a password for those who want to change something in the document.

  6. michael says:

    what if we have a user that when he clicks on remove properties and personal information for office documents nothing will pop up?

  7. Skygazer... says:

    Ekaterina,

    Do you know how to hide Protected sheet's names?

    I can hide a protected sheet name with xlVeryHidden. But it is still visible in the backstage under permissions. Is it possible to hide sheet name from here also?

    Thanks

  8. CzyJvQU says:

    alprazolam 0 5mg ems ms - xanax for anxiety and stress

  9. Khan says:

    The information and presentation is very useful.

    Is there any way to lock the properties such as "Author" of the document, while the editing is allowed? Thanks.

  10. Nic says:

    Can anyone solve the following: By default, every word document I create has the metadata TAG "XYZ" associated with it by default, probably by the last user of my networked computer in my office. How do I remove this default? I did read the great article here, and while I know how to change the AUTHOR default, how do I change other defaults (TAGS, COMMENTS, STATUS) in every document created forthwith? Thanks.

  11. Endu says:

    I found this post very helpful! I further wanted to know whether the author who modify the document last can be changed or not?
    I thank you

  12. CIndy says:

    Is there a way to fill in the Title based on a field using Visual Basic or any other method?

  13. Glen Ridenour says:

    Hello:

    Thank you for your excellent article.

    Q: Is it possible to change the created date and time in properties?

  14. Charles Boisseau says:

    Hi, Great article. It doesn't address a question I have: I'm faced with 119 similar documents. I'd like to change the title, subject and author in a batch so they all match. Two of these fields will match in every doc and I will individually change the others. Is there a way to do this and how to do it? I can do this and do it routinely in Adobe Acrobat Pro's Action Wizard to manage actions.

  15. Melissa Hare says:

    Charles - if they are Office docs, you can select all the documents, then right click and choose properties. Make your updates then press Ok/Apply. The properties on all the selected documents will at once.

  16. Hi there, i feel that i found anyone seen my personal blog site thus i came to return this desire? . I am looking to to find issues to boost this site! I suppose it is alright to utilize a few . Wimbledon Live Update 2015of your mind!

  17. Abuvihaan says:

    Really good tips. Thank you!!!

  18. music says:

    Hello there, i have faith that i actually observed anyone seen my website therefore i came to go back the drive? . I am attempting to in finding items to strengthen this web-site! I assume its good enough to try . music a just a handful of a person's ideas!

  19. Bernie says:

    Nicely done. I want to display the properties in a worksheet cell. Don't seem to see that here.
    For instance
    cell A1 displays the text: Author
    cell A2 displays the property:

  20. Scott McGregor says:

    Thank you for this very useful document.

    Same question as a few others, is there a way to populate the properties from cells within the worksheet?

  21. Aarun Poojary says:

    Thanks for the Excellent Post , it was very useful, you have really worked hard on the details , Thanks

    like as you have shown in the Custom tab , Type list Can you tell me , how to add our own custom text values to be displayed in the properties tab , and are these fields searchable while searching for a file name . please let me know

  22. Monisha says:

    Is there a way I can change the company name in advance property of a Potx and retain it in all the pptx i derive from the Potx template?

  23. Lisa B. says:

    Under Document Inspector, nos. 4 and 6, you have "Ispect", you left out the "n".

  24. Cas Kruger says:

    Hi,
    I need to know how to file my documents as text and numbers separately , as currently I file my Invoices as text and numbers combine and this cause double numbering in my invoices .
    Ex 12345MvanHeerden currently
    preferred method 12345 as number and MvanHeerden as text . I think if one can change the file property to display a space for numbers , it will be possible.
    Regards
    Cas

  25. Tulcea says:

    I like a tips you actually provide with your reports. I most certainly will save your web site as well as have a look at once again right here regularly. I am just to some degree selected I will be educated loads of innovative things good here! Best of luck for the following!

  26. Its that you go through my head! You peer to understand much about this particular, as if you wrote the actual guide in it or anything azuela cove davao. I believe that you simply can do with a bit of % so that you can power the message house somewhat, nevertheless apart from that, this is certainly exceptional blog. An outstanding study. I'll definitely be back again.

  27. Manoj says:

    Thank you so much fo the detailed explaination. But i dint find how to chamge last modified name/last saved name ...please help

  28. Olumide says:

    This is quite self explanatory. Thanks so much for the details...I really found it so helpful. Keep the good work going...

  29. Pleasant post. I just now found your blog post in addition to desired to point out that I have actually treasured searching the blog site blogposts crypto double. All things considered We will be signing up with your give exactly what intending you're posting once again rapidly!

  30. Tommy says:

    fantastic post you guys have here what is anyone's first thoughts on mine web page in relation to
    click me

  31. Antonio Minardi says:

    Nice and useful post, thank you!

  32. Jackie M says:

    We have an ex employee who just emailed us saying we are using his spreadsheets and asked us to stop unless we pay him for them. How is this possible? What is going on? Help!
    Thanks,

  33. reshma says:

    I I want to know that how we can search that exceel sheet is made in which computer

  34. Nazi says:

    It is great presentation.
    After I do all the properties changes to my workbook, save, exit.
    then every things has been removed in one fast click:
    - windows explorer
    - right click on the file
    - properties - details
    - remove properties and personal information
    that is it , it's become clear. I believe it's bug, this bug should be fixed by Microsoft programmers.
    I like Excel much than any , I hope they could solve this old and strange problem.

  35. Michael says:

    Hi,

    I am wondering if it's able to remove all the properties from all the files that are inside of many folders.

    Thanks,
    M

  36. muzaffar says:

    how can i modify the date of last saved file of excel 2013 ?

  37. FlashRouters says:

    I actually do look at the many thoughts you've provided with your posting FlashRouters. They are really genuine and will absolutely operate. Continue to, your posts particularly fast instructor can. Could you you should stretch these people a little bit through pursuing occasion? Thank you for this post.

  38. Appreciation for the nice writeup هوامير العقار. This in fact had been the excitement bank account the item. Search superior to be able to additional helped bring pleasant on your part! Moreover, precisely how may possibly we all communicate?

  39. I'm going to right away use your feed once i cannot to get your current contact request web page link as well as e-newsletter support. Accomplish you might have virtually any? Please i want to understand in order that I'll sign up. Appreciate it.. Cambridge admissions tests

  40. Travel says:

    Howdy, Tidy posting. Likely to problem with your site around ie, may possibly click here? For example nonetheless would be the market leading and also a substantial part of other individuals will certainly miss your current great creating as a result difficulty.

  41. David Davenport says:

    I have a MacPro running Excel 2011 for Mac under El Capitan 10.11.6.
    I also have MacBook Pro running Excel 16.16.2 for Mac also under El Capitan 10.11.6.

    I have an encrypted P/W protected excel file mastered on the MacPro which I share with the MacBook Pro. The copy of the file on the MacBook Pro always opens read-only. How can I make the copy writeable?

Post a comment



Unfortunately, due to the volume of comments received we cannot guarantee that we will be able to give you a timely response. When posting a question, please be very clear and concise. We thank you for understanding!
Excel add-ins and Outlook tools - Ablebits.com
33
Ultimate Suite 2018.5 for Excel
33
60+ tools for Excel
December offer: Dec. 8 – Dec. 17