{"id":18742,"date":"2013-05-08T15:57:34","date_gmt":"2013-05-08T10:27:34","guid":{"rendered":"http:\/\/vskills.in\/certification\/tutorial\/?p=18742"},"modified":"2024-04-12T14:24:19","modified_gmt":"2024-04-12T08:54:19","slug":"create-new-workbooks-from-templates","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/create-new-workbooks-from-templates\/","title":{"rendered":"Create New Workbooks From Templates"},"content":{"rendered":"<h4><strong>Create New Workbooks From Templates<\/strong><\/h4>\n<p><strong>Create new workbooks from templates<\/strong><\/p>\n<ol start=\"1\" type=\"1\">\n<li>Click\u00a0Microsoft Office Button\u00a0, and then click\u00a0New.<\/li>\n<li>Under\u00a0Templates, make sure that\u00a0Blank and recent\u00a0is selected, and then under\u00a0Blank and recent\u00a0in the right pane, double-click\u00a0Blank Workbook.<\/li>\n<\/ol>\n<p><strong>Keyboard shortcut\u00a0<\/strong>\u00a0To quickly create a new, blank workbook, you can also press CTRL+N.<\/p>\n<h3>Tips<\/h3>\n<ul type=\"disc\">\n<li>By default, a new workbook contains three worksheets, but you can change the number of worksheets that you want a new workbook to contain under\u00a0When creating new workbooks\u00a0on the\u00a0Popular\u00a0tab in the\u00a0Excel Options\u00a0dialog box (Microsoft Office Button\u00a0,\u00a0Excel Options\u00a0button).<\/li>\n<li>You can also add and remove worksheets as needed.<\/li>\n<\/ul>\n<p><strong>Workbook template<\/strong><\/p>\n<p>1. Create a workbook that contains the sheets, default text (such as page headers and column and row labels), formulas,\u00a0<a>macros<\/a>,\u00a0<a>styles<\/a>, and other formatting you want in new workbooks based on the template.<\/p>\n<ol start=\"2\" type=\"1\">\n<li>To display a picture of the first page of a template in the\u00a0Preview\u00a0box of the\u00a0Templates\u00a0dialog box (General Templates&#8230;,\u00a0New Workbook\u00a0task pane), click\u00a0Properties\u00a0on the\u00a0File\u00a0menu, click the\u00a0Summary\u00a0tab, and then select the\u00a0Save preview picture\u00a0check box.<\/li>\n<li>On the\u00a0File\u00a0menu, click\u00a0Save As.<\/li>\n<li>In the\u00a0Save as type\u00a0box, click\u00a0Template.<\/li>\n<li>In the\u00a0Save in\u00a0box, select the folder where you want to store the template.<\/li>\n<\/ol>\n<p><a ref=\"magnificPopup\" href=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/14.bmp\"><img decoding=\"async\" class=\"alignnone size-medium wp-image-30708\" src=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/14.bmp\" alt=\"14\" \/><\/a><\/p>\n<div class=\"apply\">\n<h3>Apply for MS Excel Certification Now!!<\/h3>\n<p><a href=\"https:\/\/www.vskills.in\/certification\/excel-online-certification-course\" target=\"_blank\" rel=\"noopener\">https:\/\/www.vskills.in\/certification\/excel-online-certification-course<\/a><\/p>\n<h4><a href=\"https:\/\/www.vskills.in\/certification\/tutorial\/certified-excel-2003-professional\/\" target=\"_blank\" rel=\"noopener\"><strong>Back to Tutorial<\/strong><\/a><\/h4>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Create New Workbooks From Templates Create new workbooks from templates Click\u00a0Microsoft Office Button\u00a0, and then click\u00a0New. Under\u00a0Templates, make sure that\u00a0Blank and recent\u00a0is selected, and then under\u00a0Blank and recent\u00a0in the right pane, double-click\u00a0Blank Workbook. Keyboard shortcut\u00a0\u00a0To quickly create a new, blank workbook, you can also press CTRL+N. Tips By default, a new workbook contains three worksheets,&#8230;<\/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":[5132,5134,5133],"class_list":["post-18742","page","type-page","status-publish","hentry","category-ms-excel","tag-create-new-workbooks-from-templates","tag-new-workbooks","tag-templates"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Create New Workbooks From Templates - Tutorial<\/title>\n<meta name=\"description\" content=\"Create new workbooks from templates. Govt of India Certification for Excel\" \/>\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\/create-new-workbooks-from-templates\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Create New Workbooks From Templates - Tutorial\" \/>\n<meta property=\"og:description\" content=\"Create new workbooks from templates. Govt of India Certification for Excel\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/create-new-workbooks-from-templates\/\" \/>\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:19+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/14.bmp\" \/>\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\/create-new-workbooks-from-templates\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/create-new-workbooks-from-templates\/\",\"name\":\"Create New Workbooks From Templates - Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/create-new-workbooks-from-templates\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/create-new-workbooks-from-templates\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/14.bmp\",\"datePublished\":\"2013-05-08T10:27:34+00:00\",\"dateModified\":\"2024-04-12T08:54:19+00:00\",\"description\":\"Create new workbooks from templates. Govt of India Certification for Excel\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/create-new-workbooks-from-templates\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/create-new-workbooks-from-templates\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/create-new-workbooks-from-templates\/#primaryimage\",\"url\":\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/14.bmp\",\"contentUrl\":\"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/14.bmp\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/create-new-workbooks-from-templates\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Create New Workbooks From Templates\"}]},{\"@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":"Create New Workbooks From Templates - Tutorial","description":"Create new workbooks from templates. Govt of India Certification for Excel","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\/create-new-workbooks-from-templates\/","og_locale":"en_US","og_type":"article","og_title":"Create New Workbooks From Templates - Tutorial","og_description":"Create new workbooks from templates. Govt of India Certification for Excel","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/create-new-workbooks-from-templates\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","article_modified_time":"2024-04-12T08:54:19+00:00","og_image":[{"url":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/14.bmp","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\/create-new-workbooks-from-templates\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/create-new-workbooks-from-templates\/","name":"Create New Workbooks From Templates - Tutorial","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/create-new-workbooks-from-templates\/#primaryimage"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/create-new-workbooks-from-templates\/#primaryimage"},"thumbnailUrl":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/14.bmp","datePublished":"2013-05-08T10:27:34+00:00","dateModified":"2024-04-12T08:54:19+00:00","description":"Create new workbooks from templates. Govt of India Certification for Excel","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/create-new-workbooks-from-templates\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/create-new-workbooks-from-templates\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/create-new-workbooks-from-templates\/#primaryimage","url":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/14.bmp","contentUrl":"http:\/\/vskills.in\/certification\/tutorial\/wp-content\/uploads\/2013\/05\/14.bmp"},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/create-new-workbooks-from-templates\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Create New Workbooks From Templates"}]},{"@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\/18742","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=18742"}],"version-history":[{"count":6,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/18742\/revisions"}],"predecessor-version":[{"id":130060,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/18742\/revisions\/130060"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=18742"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=18742"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=18742"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}