{"id":18784,"date":"2013-05-08T15:53:21","date_gmt":"2013-05-08T10:23:21","guid":{"rendered":"http:\/\/vskills.in\/certification\/tutorial\/?p=18784"},"modified":"2024-04-12T14:24:23","modified_gmt":"2024-04-12T08:54:23","slug":"define-and-modify-workbook-properties","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/define-and-modify-workbook-properties\/","title":{"rendered":"Define and Modify Workbook Properties"},"content":{"rendered":"

Define and Modify Workbook Properties<\/strong><\/h4>\n

Workbook properties in Microsoft Excel are metadata that provide information about the workbook, such as its author, title, and subject. Here’s how to define and modify workbook properties in Excel:<\/p>\n

Open the Excel workbook you want to modify the properties for.<\/p>\n

Go to the “File” tab in the ribbon, and choose “Info” in the left-hand menu.<\/p>\n

Click the “Properties” dropdown menu and select “Advanced Properties.”<\/p>\n

In the “Properties” dialog box, you can modify various properties such as Title, Subject, Author, Manager, Company, Category, and Keywords.<\/p>\n

After making the desired changes, click “OK” to save the properties.<\/p>\n

You can also define custom properties by clicking the “Custom” tab in the “Properties” dialog box and entering a new property name and value.<\/p>\n

In addition, you can view and modify some of the workbook properties directly in the backstage view under the “Info” tab. For example, you can change the document’s author and add tags to the document.<\/p>\n

Keep in mind that workbook properties can be useful for organizing and searching for your files, so it’s a good practice to fill in relevant properties for your workbooks.<\/p>\n

\n

Apply for MS Excel Certification Now!!<\/h3>\n

https:\/\/www.vskills.in\/certification\/excel-online-certification-course<\/a><\/p>\n

Back to Tutorial<\/strong><\/a><\/h4>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Define and Modify Workbook Properties Workbook properties in Microsoft Excel are metadata that provide information about the workbook, such as its author, title, and subject. Here’s how to define and modify workbook properties in Excel: Open the Excel workbook you want to modify the properties for. Go to the “File” tab in the ribbon, and…<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[47],"tags":[],"class_list":["post-18784","page","type-page","status-publish","hentry","category-ms-excel"],"acf":[],"yoast_head":"\nDefine and Modify Workbook Properties - Tutorial<\/title>\n<meta name=\"description\" content=\"Define and modify workbook properties. Govt of India Certification for Excel . Get Certified and improve employability. Certification assesses candidates in excel 2003 concepts\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.vskills.in\/certification\/tutorial\/define-and-modify-workbook-properties\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Define and Modify Workbook Properties - Tutorial\" \/>\n<meta property=\"og:description\" content=\"Define and modify workbook properties. Govt of India Certification for Excel . Get Certified and improve employability. Certification assesses candidates in excel 2003 concepts\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/define-and-modify-workbook-properties\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutorial\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/vskills.in\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-12T08:54:23+00:00\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/define-and-modify-workbook-properties\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/define-and-modify-workbook-properties\/\",\"name\":\"Define and Modify Workbook Properties - Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"datePublished\":\"2013-05-08T10:23:21+00:00\",\"dateModified\":\"2024-04-12T08:54:23+00:00\",\"description\":\"Define and modify workbook properties. Govt of India Certification for Excel . Get Certified and improve employability. Certification assesses candidates in excel 2003 concepts\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/define-and-modify-workbook-properties\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/define-and-modify-workbook-properties\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/define-and-modify-workbook-properties\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Define and Modify Workbook Properties\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"name\":\"Tutorial\",\"description\":\"Vskills - A initiative in elearning and certification\",\"publisher\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\",\"name\":\"Vskills\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"contentUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"width\":73,\"height\":55,\"caption\":\"Vskills\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/vskills.in\/\",\"https:\/\/x.com\/vskills_in\",\"https:\/\/www.linkedin.com\/company-beta\/1371554\/\",\"https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Define and Modify Workbook Properties - Tutorial","description":"Define and modify workbook properties. Govt of India Certification for Excel . Get Certified and improve employability. Certification assesses candidates in excel 2003 concepts","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.vskills.in\/certification\/tutorial\/define-and-modify-workbook-properties\/","og_locale":"en_US","og_type":"article","og_title":"Define and Modify Workbook Properties - Tutorial","og_description":"Define and modify workbook properties. Govt of India Certification for Excel . Get Certified and improve employability. Certification assesses candidates in excel 2003 concepts","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/define-and-modify-workbook-properties\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","article_modified_time":"2024-04-12T08:54:23+00:00","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/define-and-modify-workbook-properties\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/define-and-modify-workbook-properties\/","name":"Define and Modify Workbook Properties - Tutorial","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"datePublished":"2013-05-08T10:23:21+00:00","dateModified":"2024-04-12T08:54:23+00:00","description":"Define and modify workbook properties. Govt of India Certification for Excel . Get Certified and improve employability. Certification assesses candidates in excel 2003 concepts","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/define-and-modify-workbook-properties\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/define-and-modify-workbook-properties\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/define-and-modify-workbook-properties\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Define and Modify Workbook Properties"}]},{"@type":"WebSite","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","name":"Tutorial","description":"Vskills - A initiative in elearning and certification","publisher":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization","name":"Vskills","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","contentUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","width":73,"height":55,"caption":"Vskills"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/vskills.in\/","https:\/\/x.com\/vskills_in","https:\/\/www.linkedin.com\/company-beta\/1371554\/","https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw"]}]}},"_links":{"self":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/18784","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/comments?post=18784"}],"version-history":[{"count":6,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/18784\/revisions"}],"predecessor-version":[{"id":130008,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/18784\/revisions\/130008"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=18784"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=18784"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=18784"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}