{"id":4531,"date":"2016-12-26T09:43:45","date_gmt":"2016-12-26T09:43:45","guid":{"rendered":"http:\/\/www.isunshare.com\/blog\/?p=4531"},"modified":"2023-04-13T08:31:22","modified_gmt":"2023-04-13T08:31:22","slug":"rename-multiple-worksheets-manually-or-automatically","status":"publish","type":"post","link":"https:\/\/www.isunshare.com\/blog\/rename-multiple-worksheets-manually-or-automatically\/","title":{"rendered":"3 Ways to Rename Multiple Worksheets Manually or Automatically in Excel"},"content":{"rendered":"<div class=\"ads-google\"><ins class=\"adsbygoogle\" style=\"display: block; text-align: center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-3976761739610001\" data-ad-slot=\"8881155354\"><\/ins><br \/>\n<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script><\/div>\n<p>If you have lots of worksheets needed to be renamed now, how will you do? Rename them manually one by one with &#8220;Rename&#8221; command in Excel or automatically with VBA code or other programs? Just see three ways talked about in this post, you will have your best choice.<\/p>\n<ul>\n<li><a href=\"#way1\">Way 1: Rename multiple worksheets with &#8220;Rename&#8221; command<\/a><\/li>\n<li><a href=\"#way2\">Way 2: Rename multiple worksheets at once with VBA code<\/a><\/li>\n<li><a href=\"#way3\">Way 3: Rename multiple worksheets automatically with Kutools for Excel<\/a><\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/worksheets-needed-to-be-renamed.png\" rel=\"attachment wp-att-4537\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"247\" class=\"alignnone wp-image-4537 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/worksheets-needed-to-be-renamed.png\" alt=\"worksheet needed to be renamed\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/worksheets-needed-to-be-renamed.png 700w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/worksheets-needed-to-be-renamed-300x106.png 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<h2 id=\"way1\">Way 1: Rename multiple worksheets manually with &#8220;Rename&#8221; command<\/h2>\n<p>This is the most common way that everyone should know to rename worksheet tab in Excel. We can give a totally different name for one worksheet from another. But we have to do this manually one by one.<\/p>\n<p><strong>1.<\/strong> Open the excel workbook that includes worksheets you need to rename.<\/p>\n<p><strong>2.<\/strong> Right click the sheet tab and select &#8220;<strong>Rename<\/strong>&#8221; option.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/rename-worksheet-with-rename-command.png\" rel=\"attachment wp-att-4539\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"293\" class=\"alignnone wp-image-4539 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/rename-worksheet-with-rename-command.png\" alt=\"rename worksheet with rename command\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/rename-worksheet-with-rename-command.png 700w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/rename-worksheet-with-rename-command-300x126.png 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p><strong>3.<\/strong> Enter a new name for the worksheet and press <strong>Ctrl + S<\/strong> to save changes to workbook.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/enter-new-name-for-worksheet.png\" rel=\"attachment wp-att-4540\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"293\" class=\"alignnone wp-image-4540 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/enter-new-name-for-worksheet.png\" alt=\"enter new name for worksheet one by one\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/enter-new-name-for-worksheet.png 700w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/enter-new-name-for-worksheet-300x126.png 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<h2 id=\"way2\">Way 2: Rename multiple worksheets at once with VBA code<\/h2>\n<p>This is general but a little difficult way to automatically <a href=\"https:\/\/www.isunshare.com\/blog\/rename-multiple-worksheets-manually-or-automatically\/\" target=\"_blank\" rel=\"noopener noreferrer\">rename multiple worksheets<\/a> by the same at once.<\/p>\n<p><strong>Step 1:<\/strong> Press <strong>Alt + F11<\/strong> to open <strong>Microsoft Visual Basic for Applications<\/strong> and insert a module.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/run-vba-and-enter-code.png\" rel=\"attachment wp-att-4541\"><img loading=\"lazy\" decoding=\"async\" width=\"630\" height=\"301\" class=\"alignnone wp-image-4541 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/run-vba-and-enter-code.png\" alt=\"run VBA and enter VBA code\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/run-vba-and-enter-code.png 630w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/run-vba-and-enter-code-300x143.png 300w\" sizes=\"auto, (max-width: 630px) 100vw, 630px\" \/><\/a><\/p>\n<p><strong>Step 2:<\/strong> Copy and paste following codes into the <strong>Module<\/strong>.<\/p>\n<p><em><span style=\"color: #999999;\">Sub ChangeWorkSheetName()<\/span><\/em><\/p>\n<p><em><span style=\"color: #999999;\">&#8216;Updateby20140624<\/span><\/em><\/p>\n<p><em><span style=\"color: #999999;\">Dim Rng\u00a0As Range<\/span><\/em><\/p>\n<p><em><span style=\"color: #999999;\">Dim WorkRng\u00a0As Range<\/span><\/em><\/p>\n<p><em><span style=\"color: #999999;\">On Error Resume Next<\/span><\/em><\/p>\n<p><em><span style=\"color: #999999;\">xTitleId =\u00a0&#8220;KutoolsforExcel&#8221;<\/span><\/em><\/p>\n<p><em><span style=\"color: #999999;\">newName = Application.InputBox(&#8220;Name&#8221;, xTitleId,\u00a0&#8220;&#8221;, Type:=2)<\/span><\/em><\/p>\n<p><em><span style=\"color: #999999;\">For i = 1\u00a0To Application.Sheets.Count<\/span><\/em><\/p>\n<p><em><span style=\"color: #999999;\">Application.Sheets(i).Name = newName &amp; i<\/span><\/em><\/p>\n<p><em><span style=\"color: #999999;\">Next<\/span><\/em><\/p>\n<p><em><span style=\"color: #999999;\">End Sub<\/span><\/em><\/p>\n<p><strong>Step 3:<\/strong> Press <strong>F5<\/strong> to run the VBA code and enter the name you want in the pop-up dialog.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/confirm-to-run-code-to-rename-worksheets.png\" rel=\"attachment wp-att-4542\"><img loading=\"lazy\" decoding=\"async\" width=\"445\" height=\"340\" class=\"alignnone wp-image-4542 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/confirm-to-run-code-to-rename-worksheets.png\" alt=\"confirm to run code to rename multiple worksheets\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/confirm-to-run-code-to-rename-worksheets.png 445w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/confirm-to-run-code-to-rename-worksheets-300x229.png 300w\" sizes=\"auto, (max-width: 445px) 100vw, 445px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/enter-same-part-in-sheet-name.png\" rel=\"attachment wp-att-4543\"><img loading=\"lazy\" decoding=\"async\" width=\"280\" height=\"122\" class=\"alignnone wp-image-4543 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/enter-same-part-in-sheet-name.png\" alt=\"enter same part in new worksheet name\" \/><\/a><\/p>\n<p><strong>Step 4:<\/strong> Click OK and you can see all the sheets are renamed with characters you typed.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/successfully-rename-multiple-worksheets-with-vba-code.png\" rel=\"attachment wp-att-4544\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"256\" class=\"alignnone wp-image-4544 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/successfully-rename-multiple-worksheets-with-vba-code.png\" alt=\"successfully rename multiple worksheets with VBA code\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/successfully-rename-multiple-worksheets-with-vba-code.png 700w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/successfully-rename-multiple-worksheets-with-vba-code-300x110.png 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2 id=\"way3\">Way 3: Rename multiple worksheets easily with Kutools for Excel<\/h2>\n<p>It is one of the most effective ways I know that can easily rename multiple worksheets fast in few seconds. But at first, you should get <strong>Kutools for Excel<\/strong> and install it.<\/p>\n<p><strong>Step 1:<\/strong> Click <strong>Enterprise &gt; Worksheet &gt; Rename Multiple Worksheets<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/choose-to-rename-multiple-worksheets.png\" rel=\"attachment wp-att-4545\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"260\" class=\"alignnone wp-image-4545 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/choose-to-rename-multiple-worksheets.png\" alt=\"choose to rename multiple worksheets with Kutools for Excel\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/choose-to-rename-multiple-worksheets.png 700w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/choose-to-rename-multiple-worksheets-300x111.png 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p><strong>Step 2:<\/strong> Specify the settings in <strong>Rename Multiple Worksheets<\/strong> dialog box.<\/p>\n<ol>\n<li>Select the worksheets you want to rename from the Worksheets list.<\/li>\n<li>Input the specific value into the &#8220;<strong>From an input box<\/strong>&#8220;.<\/li>\n<li>Select one type which you want to rename the worksheets under <strong>Rename Options<\/strong>.<\/li>\n<\/ol>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/specify-worksheet-name-settings.png\" rel=\"attachment wp-att-4546\"><img loading=\"lazy\" decoding=\"async\" width=\"456\" height=\"361\" class=\"alignnone wp-image-4546 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/specify-worksheet-name-settings.png\" alt=\"specify worksheet new name settings\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/specify-worksheet-name-settings.png 456w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/specify-worksheet-name-settings-300x238.png 300w\" sizes=\"auto, (max-width: 456px) 100vw, 456px\" \/><\/a><\/p>\n<p><strong>Step 3:<\/strong> Click <strong>OK<\/strong> to rename selected worksheets with specified settings.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/successfully-rename-worksheets-with-kutools.png\" rel=\"attachment wp-att-4547\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"259\" class=\"alignnone wp-image-4547 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/successfully-rename-worksheets-with-kutools.png\" alt=\"successfully rename multiple worksheets with Kutools for Excel\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/successfully-rename-worksheets-with-kutools.png 700w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/successfully-rename-worksheets-with-kutools-300x111.png 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p><strong>Related Articles:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.isunshare.com\/blog\/rename-multiple-workbooks-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">2 Ways to Rename Multiple Workbooks in Excel<\/a><\/li>\n<li><a href=\"https:\/\/www.isunshare.com\/excel-password\/how-to-protect-multiple-sheets-in-excel-2010-workbook.html\" target=\"_blank\" rel=\"noopener noreferrer\">How to Protect Multiple Sheets in Excel 2010 Workbook<\/a><\/li>\n<li><a href=\"https:\/\/www.isunshare.com\/excel-password\/unprotect-xls-xlsx-worksheet-without-password.html\" target=\"_blank\" rel=\"noopener noreferrer\">2 Ways to Unprotect Excel Worksheet without Password<\/a><\/li>\n<li><a href=\"https:\/\/www.isunshare.com\/excel-password\/remove-and-bypass-excel-sheet-protection-password.html\" target=\"_blank\" rel=\"noopener noreferrer\">Remove and Bypass Excel Sheet Protection Password<\/a><\/li>\n<\/ul>\n<div class=\"ads-google\"><ins class=\"adsbygoogle\" style=\"display: block; text-align: center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-3976761739610001\" data-ad-slot=\"5625464292\"><\/ins><br \/>\n<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script><\/div>\n","protected":false},"excerpt":{"rendered":"<p>If you have lots of worksheets needed to be renamed now, how will you do? Rename them manually&#8230;<\/p>\n","protected":false},"author":1,"featured_media":126196,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[230],"class_list":["post-4531","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office-documents","tag-excel"],"_links":{"self":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/4531","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=4531"}],"version-history":[{"count":5,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/4531\/revisions"}],"predecessor-version":[{"id":126197,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/4531\/revisions\/126197"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/media\/126196"}],"wp:attachment":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/media?parent=4531"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/categories?post=4531"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/tags?post=4531"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}