{"id":18774,"date":"2013-05-08T15:52:18","date_gmt":"2013-05-08T10:22:18","guid":{"rendered":"http:\/\/vskills.in\/certification\/tutorial\/?p=18774"},"modified":"2024-04-12T14:24:22","modified_gmt":"2024-04-12T08:54:22","slug":"apply-workbook-security-settings","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/apply-workbook-security-settings\/","title":{"rendered":"Apply Workbook Security Settings"},"content":{"rendered":"

Apply Workbook Security Settings<\/strong><\/h4>\n

Click the Protect Workbook command button in the Changes group on the Review tab.<\/p>\n

Excel opens the Protect Structure and Windows dialog box, where the Structure check box is selected by default. With the Structure check box selected, Excel won\u2019t let anyone mess around with the sheets in the workbook (by deleting them or rearranging them).<\/p>\n

\"4\"<\/p>\n

    \n
  1. (Optional) If you want to protect any windows that you set\u00a0up, select the Windows check box.When selected, this setting keeps the workbook windows in the same size and position each time you open the workbook.<\/li>\n
  2. To assign a password that must be supplied before you can remove the protection from the worksheet, type the password in the Password (optional) text box.<\/li>\n
  3. Click OK.If you typed a password in the Password (optional) text box, Excel opens the Confirm Password dialog box. Re-enter the password in the Reenter Password to Proceed text box exactly as you typed it Step 3, and then click OK.<\/li>\n<\/ol>\n

    Unprotecting a workbook<\/h2>\n

    To remove protection from the current workbook, follow these steps:<\/p>\n

      \n
    1. Click the Unprotect Workbook command button in the Changes group on the Review tab.<\/li>\n
    2. If you assigned a password when protecting the workbook, type the password in the Password text box and click OK.<\/li>\n<\/ol>\n

      Protecting a shared workbook<\/h2>\n

      If you create a workbook with contents to be updated by several different users on your\u00a0network, you can use the Protect and Share Workbook command to ensure that Excel tracks all the changes made and that no user can intentionally or inadvertently remove Excel\u2019s tracking of changes. Follow these steps:<\/p>\n

        \n
      1. Click the Protect and Share Workbook command button in the Changes group on the Review tab.The Protect Shared Workbook dialog box appears.<\/li>\n
      2. Select the Sharing with Track Changes check box.<\/li>\n<\/ol>\n

        \"6\"<\/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":"

        Apply Workbook Security Settings Click the Protect Workbook command button in the Changes group on the Review tab. Excel opens the Protect Structure and Windows dialog box, where the Structure check box is selected by default. With the Structure check box selected, Excel won\u2019t let anyone mess around with the sheets in the workbook (by…<\/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":[5172,5170,5171],"class_list":["post-18774","page","type-page","status-publish","hentry","category-ms-excel","tag-apply-workbook","tag-apply-workbook-security-settings","tag-security-settings"],"acf":[],"yoast_head":"\nApply Workbook Security Settings - Tutorial<\/title>\n<meta name=\"description\" content=\"Apply workbook security settings. 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\/apply-workbook-security-settings\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Apply Workbook Security Settings - Tutorial\" \/>\n<meta property=\"og:description\" content=\"Apply workbook security settings. 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\/apply-workbook-security-settings\/\" \/>\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:22+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/43-300x224.jpg\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/apply-workbook-security-settings\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/apply-workbook-security-settings\/\",\"name\":\"Apply Workbook Security Settings - Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/apply-workbook-security-settings\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/apply-workbook-security-settings\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/43-300x224.jpg\",\"datePublished\":\"2013-05-08T10:22:18+00:00\",\"dateModified\":\"2024-04-12T08:54:22+00:00\",\"description\":\"Apply workbook security settings. 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\/apply-workbook-security-settings\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/apply-workbook-security-settings\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/apply-workbook-security-settings\/#primaryimage\",\"url\":\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/43-300x224.jpg\",\"contentUrl\":\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/43-300x224.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/apply-workbook-security-settings\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Apply Workbook Security Settings\"}]},{\"@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":"Apply Workbook Security Settings - Tutorial","description":"Apply workbook security settings. 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\/apply-workbook-security-settings\/","og_locale":"en_US","og_type":"article","og_title":"Apply Workbook Security Settings - Tutorial","og_description":"Apply workbook security settings. 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\/apply-workbook-security-settings\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","article_modified_time":"2024-04-12T08:54:22+00:00","og_image":[{"url":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/43-300x224.jpg","type":"","width":"","height":""}],"twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/apply-workbook-security-settings\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/apply-workbook-security-settings\/","name":"Apply Workbook Security Settings - Tutorial","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/apply-workbook-security-settings\/#primaryimage"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/apply-workbook-security-settings\/#primaryimage"},"thumbnailUrl":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/43-300x224.jpg","datePublished":"2013-05-08T10:22:18+00:00","dateModified":"2024-04-12T08:54:22+00:00","description":"Apply workbook security settings. 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\/apply-workbook-security-settings\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/apply-workbook-security-settings\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/apply-workbook-security-settings\/#primaryimage","url":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/43-300x224.jpg","contentUrl":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/43-300x224.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/apply-workbook-security-settings\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Apply Workbook Security Settings"}]},{"@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\/18774","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=18774"}],"version-history":[{"count":6,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/18774\/revisions"}],"predecessor-version":[{"id":130092,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/18774\/revisions\/130092"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=18774"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=18774"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=18774"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}