{"id":4512,"date":"2016-12-26T09:39:10","date_gmt":"2016-12-26T09:39:10","guid":{"rendered":"http:\/\/www.isunshare.com\/blog\/?p=4512"},"modified":"2023-04-13T08:31:59","modified_gmt":"2023-04-13T08:31:59","slug":"rename-multiple-workbooks-in-excel","status":"publish","type":"post","link":"https:\/\/www.isunshare.com\/blog\/rename-multiple-workbooks-in-excel\/","title":{"rendered":"2 Ways to Rename Multiple Workbooks in Excel 2010"},"content":{"rendered":"<p><strong>Renaming workbook<\/strong> or worksheet is usual thing in MS Excel 2016-2003 no matter the workbook or worksheet is opened or closed. It would make all the workbooks different from each other.<\/p>\n<p>So when you need to <strong>change the workbook name<\/strong>, please follow this article, which would take excel workbook 2010 as example to introduce how to do.<\/p>\n<ul>\n<li><a href=\"#way1\">Way 1: Rename Workbook in &#8220;Open&#8221; dialog when it is closed<\/a><\/li>\n<li><a href=\"#way2\">Way 2: Rename Workbook in &#8220;Save As&#8221; dialog when it is opened<\/a><\/li>\n<\/ul>\n<h2 id=\"way1\">Way 1: Rename Workbook in &#8220;Open&#8221; Dialog When It is Closed<\/h2>\n<p><strong>Steps to change workbook name in &#8220;Open&#8221; dialog:<\/strong><\/p>\n<p><strong>1.<\/strong> Press <strong>CTRL + O<\/strong> to display the <strong>Open <\/strong>dialog box after MS Excel is opened.<\/p>\n<p><strong>2.<\/strong> Navigate to the location of workbook you want to rename.<\/p>\n<p><strong>3.<\/strong> Right click the workbook and choose <strong>Rename<\/strong> option in right menu.<\/p>\n<p><strong>4.<\/strong> Type in a new name and press <strong>Enter<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/rename-workbook-in-excel-open-dialog.png\" rel=\"attachment wp-att-4516\"><img loading=\"lazy\" decoding=\"async\" width=\"500\" height=\"339\" class=\"alignnone wp-image-4516 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/rename-workbook-in-excel-open-dialog.png\" alt=\"rename workbook in excel open dialog\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/rename-workbook-in-excel-open-dialog.png 500w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/rename-workbook-in-excel-open-dialog-300x203.png 300w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/a><\/p>\n<p>Do the same for all of excel workbooks you want to rename with above steps.<\/p>\n<p><strong>Note:\u00a0<\/strong>If the workbook you want to rename has been opened in Excel, please close it in Excel and then take rename it with this way. Or go to see <strong><a href=\"#way2\">way 2<\/a><\/strong> to learn how to give the multiple workbooks new names in MS Excel.<\/p>\n<h2 id=\"way2\">Way 2: Rename Workbook in &#8220;Save As&#8221; Dialog When It is Opened<\/h2>\n<p>If you want to rename current workbooks opened in MS Excel, please give it a new name in <strong>Save As<\/strong> dialog one by one.<\/p>\n<p><strong>In Excel 2016\/2013:<\/strong><\/p>\n<ol>\n<li>Click <strong>File &gt; Save As<\/strong> in Excel 2016\/2013.<\/li>\n<li>Under\u00a0<strong>Places<\/strong>, pick the place where you want to save the workbook. For example,\u00a0pick\u00a0<strong>OneDrive\u00a0<\/strong>to save it to your Web location or\u00a0<strong>Computer\u00a0<\/strong>to save it in a local folder like your\u00a0<strong>Documents<\/strong>.<\/li>\n<li>In the <strong>Save As<\/strong> dialog box, navigate to the location you want.<\/li>\n<li>Type a new name for the workbook and save it.<\/li>\n<\/ol>\n<p><strong>In Excel 2003\/2010:<\/strong> Click\u00a0<strong><em>File<\/em><\/strong>\u00a0&gt;\u00a0<strong><em>Save As<\/em><\/strong>, type in the new workbook name and save it.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/save-as-workbook-needed-to-rename.png\" rel=\"attachment wp-att-4518\"><img loading=\"lazy\" decoding=\"async\" width=\"500\" height=\"359\" class=\"alignnone wp-image-4518 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/save-as-workbook-needed-to-rename.png\" alt=\"save as workbook needed to rename\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/save-as-workbook-needed-to-rename.png 500w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/save-as-workbook-needed-to-rename-300x215.png 300w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/rename-workbook-in-save-as-dialog.png\" rel=\"attachment wp-att-4519\"><img loading=\"lazy\" decoding=\"async\" width=\"500\" height=\"194\" class=\"alignnone wp-image-4519 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/rename-workbook-in-save-as-dialog.png\" alt=\"rename workbook in save as dialog\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/rename-workbook-in-save-as-dialog.png 500w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/rename-workbook-in-save-as-dialog-300x116.png 300w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/a><\/p>\n<p><strong>In Excel 2007:<\/strong> click\u00a0<strong><em>Office icon<\/em><\/strong>\u00a0&gt;\u00a0<strong><em>Save As<\/em><\/strong>, type in a new workbook name and save it.<\/p>\n<p>Besides, with <strong>Office Tab<\/strong> or Office Tab Enterprise, you can also <a href=\"https:\/\/www.isunshare.com\/blog\/rename-multiple-workbooks-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>rename multiple excel workbooks<\/strong><\/a> at once when they opened in MS Excel.<\/p>\n<p><strong>1.<\/strong> Install and run <a href=\"http:\/\/www.office-tabs.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Office Tab<\/a> evaluation version on your Windows computer.<\/p>\n<p><strong>2.<\/strong> Open multiple workbooks in Excel, then you can right click on the workbook tab and choose the <strong>Rename<\/strong> command item to rename it easily.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/open-multiple-workbooks-as-tab-in-excel.png\" rel=\"attachment wp-att-4520\"><img loading=\"lazy\" decoding=\"async\" width=\"500\" height=\"387\" class=\"alignnone wp-image-4520 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/open-multiple-workbooks-as-tab-in-excel.png\" alt=\"open multiple workbooks as tab in excel\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/open-multiple-workbooks-as-tab-in-excel.png 500w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/open-multiple-workbooks-as-tab-in-excel-300x232.png 300w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/a><\/p>\n<p><strong>3.<\/strong> Enter new name for selected workbook in pop-up <strong>Office Tab<\/strong> dialog and click <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/rename-workbook-with-office-tab.png\" rel=\"attachment wp-att-4521\"><img loading=\"lazy\" decoding=\"async\" width=\"411\" height=\"121\" class=\"alignnone wp-image-4521 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/rename-workbook-with-office-tab.png\" alt=\"rename workbook with office tab\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/rename-workbook-with-office-tab.png 411w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/rename-workbook-with-office-tab-300x88.png 300w\" sizes=\"auto, (max-width: 411px) 100vw, 411px\" \/><\/a><\/p>\n<p><strong>Tips:<\/strong> Office Tab is not a freeware, only evaluation version can be used free in a period.\u00a0But\u00a0after evaluation period, you would need to register it if you want to continue to use. Therefore, the first two common methods provided by MS Excel are used generally.<\/p>\n<p><strong>Related Articles:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.isunshare.com\/excel-password\/protect-and-unprotect-workbook-structure-and-windows.html\" target=\"_blank\" rel=\"noopener noreferrer\">How to\u00a0Protect\/Unprotect Workbook Structure and Windows<\/a><\/li>\n<li><a href=\"https:\/\/www.isunshare.com\/blog\/set-excel-workbook-read-only-to-restrict-changes\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Set Excel Workbook Read Only to Restrict Changes<\/a><\/li>\n<li><a href=\"https:\/\/www.isunshare.com\/blog\/remove-workbook-protection-excel-2010-without-password\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Remove Workbook Protection Excel 2010 without Password<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Renaming workbook or worksheet is usual thing in MS Excel 2016-2003 no matter the workbook or worksheet is&#8230;<\/p>\n","protected":false},"author":1,"featured_media":126195,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-4512","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office-documents"],"_links":{"self":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/4512","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/comments?post=4512"}],"version-history":[{"count":5,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/4512\/revisions"}],"predecessor-version":[{"id":6381,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/4512\/revisions\/6381"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/media\/126195"}],"wp:attachment":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/media?parent=4512"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/categories?post=4512"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/tags?post=4512"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}