{"id":110011,"date":"2021-02-24T11:37:46","date_gmt":"2021-02-24T06:07:46","guid":{"rendered":"https:\/\/www.vskills.in\/certification\/tutorial\/?page_id=110011"},"modified":"2024-04-12T14:30:51","modified_gmt":"2024-04-12T09:00:51","slug":"file-management-5","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/file-management-5\/","title":{"rendered":"File Management"},"content":{"rendered":"\n<p><strong>Creating a workbook<\/strong><\/p>\n\n\n\n<p>Workbook can be created in various ways like creating a new blank document or creating a workbook from a copy of an existing workbook by using the task pane. Click File, point to New option and click. A new blank file is opened. The other way to open a new file is to press \u201cCTRL\u201d key and then press \u201cN\u201d holding down the CTRL key and this key press sequence is denoted as \u201cCTRL + N\u201d.<\/p>\n\n\n\n<p><strong>Saving a workbook<\/strong><\/p>\n\n\n\n<p>To save active workbook to a file on our hard disk,&nbsp;&nbsp; press \u201cControl\u201d and \u201cS\u201d key or in File Menu click on save option (from the menu bar). Saving first time for new document opens \u201cSave As\u201d dialog box but after first time save, no dialog box opens on consecutive saves.<\/p>\n\n\n\n<p>The Save As dialog box specifies the location to save the file and its file name. The \u201cSave in\u201d drop down list displays the default folder as the location where the file will be saved. File Name text box displays the proposed file name. The file list box displays the names of any word documents in the default location. The windows documents can have up to 256 characters in the file name. Names can contain letters or numerals, special symbols, with exception of underscore. Word files are identified by the extension doc. Document can be saved with new file name, at different location or as different file extension, in File menu after clicking Save As, apply following steps<\/p>\n\n\n\n<p><em>Save a file with a new name<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>In the File name field, enter the new name of the file.<\/li><li>Click Save<\/li><\/ul>\n\n\n\n<p><em>Save a file at different location<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>In the Save in drop down box select the directory where to save.<\/li><li>Click Save<\/li><\/ul>\n\n\n\n<p><em>Save a file as different file extension<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>In the Save as drop down box select the file type to save the document as.<\/li><li>Click Save<\/li><\/ul>\n\n\n\n<p><strong>Auto Recovery<\/strong><\/p>\n\n\n\n<p>Excel also includes an Auto Recovery feature for accidental loss of work due to power failure or other mishap. When we start up again, the recovery file is automatically opened containing all changes we made up to the last time it was saved by auto recover.<\/p>\n\n\n\n<p><strong>Closing Workbook<\/strong><\/p>\n\n\n\n<p>On the File menu, click Close or use shortcut key combination \u2013 \u201cControl\u201d and \u201cW\u201d or click on Workbook close button in right end of menu bar.<\/p>\n\n\n\n<p><strong>Opening Workbook<\/strong><\/p>\n\n\n\n<p>Click File Menu than Open. If we want to open a workbook that was saved in a different folder, locate and open the folder. Double-click the workbook we want to open. If we can&#8217;t find the document in the folder list, we can search for it.<\/p>\n\n\n\n<p><strong>Exiting Excel<\/strong><\/p>\n\n\n\n<p>The exit command in the File Menu is used to quit the Excel program or click the X close button in the title bar. If we close without saving our document, excel displays a warning asking if we want to save our work. If we do not save our work and we exit, all our changes are lost. The keyboard shortcut is Alt + F4<\/p>\n\n\n\n<p>Selecting the Close option present in the File menu does quit a worksheet. If the exit option is selected than, MS-EXCEL closes all the open workbooks as well as closes the MS-EXCEL window.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Creating a workbook Workbook can be created in various ways like creating a new blank document or creating a workbook from a copy of an existing workbook by using the task pane. Click File, point to New option and click. A new blank file is opened. The other way to open a new file is&#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":[],"tags":[],"class_list":["post-110011","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>File Management - Tutorial<\/title>\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\/file-management-5\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"File Management - Tutorial\" \/>\n<meta property=\"og:description\" content=\"Creating a workbook Workbook can be created in various ways like creating a new blank document or creating a workbook from a copy of an existing workbook by using the task pane. Click File, point to New option and click. A new blank file is opened. The other way to open a new file is...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/file-management-5\/\" \/>\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-12T09:00:51+00:00\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 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\/file-management-5\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/file-management-5\/\",\"name\":\"File Management - Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"datePublished\":\"2021-02-24T06:07:46+00:00\",\"dateModified\":\"2024-04-12T09:00:51+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/file-management-5\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/file-management-5\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/file-management-5\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"File Management\"}]},{\"@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":"File Management - Tutorial","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\/file-management-5\/","og_locale":"en_US","og_type":"article","og_title":"File Management - Tutorial","og_description":"Creating a workbook Workbook can be created in various ways like creating a new blank document or creating a workbook from a copy of an existing workbook by using the task pane. Click File, point to New option and click. A new blank file is opened. The other way to open a new file is...","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/file-management-5\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","article_modified_time":"2024-04-12T09:00:51+00:00","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/file-management-5\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/file-management-5\/","name":"File Management - Tutorial","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"datePublished":"2021-02-24T06:07:46+00:00","dateModified":"2024-04-12T09:00:51+00:00","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/file-management-5\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/file-management-5\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/file-management-5\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"File Management"}]},{"@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\/110011","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=110011"}],"version-history":[{"count":1,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/110011\/revisions"}],"predecessor-version":[{"id":110013,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/110011\/revisions\/110013"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=110011"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=110011"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=110011"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}