Here you can already see some information about your document. The Properties pane is shown on the right-hand side. This method allows you to see the information about your document right in the worksheet. If you don't know where to find the information about your document in Excel 2016-2010, here are three ways to do it. 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. A person who creates a document library can set some document library properties and rules for their values. Document library properties refer to documents in a document library on a Web site or in a public folder. Properties for your organization are properties specific to the organization. They allow you to add other properties to your Office document. Custom properties are user-defined properties. 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.

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

Let's get it started! :)īefore 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. 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. In these last two versions they are hidden deeper, but it won't take you much time to dig them out. This is what happened to the document properties in Excel 2010 / 2013. In this article you'll also learn how to protect your document from any modifications and remove personal information from your Excel worksheet.ĭo 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. The time has come to tell you about different types of document properties, the ways of viewing and changing them in Excel 2019, 20.

Edit document properties word mac