{"id":8735,"date":"2017-01-23T00:57:37","date_gmt":"2017-01-23T00:57:37","guid":{"rendered":"http:\/\/www.top-password.com\/blog\/?p=8735"},"modified":"2017-01-23T01:01:23","modified_gmt":"2017-01-23T01:01:23","slug":"rename-one-or-multiple-worksheet-tabs-in-excel","status":"publish","type":"post","link":"https:\/\/www.top-password.com\/blog\/rename-one-or-multiple-worksheet-tabs-in-excel\/","title":{"rendered":"4 Options to Rename One or Multiple Worksheet Tabs in Excel"},"content":{"rendered":"

How can I rename multiple worksheets at one time using VBA code? In Excel, you can assign a unique name to each sheet tab in your workbook so you can easily find the tab you want. In this tutorial we’ll show you 4 simple methods to rename one or multiple worksheet tabs in Excel.<\/p>\n

Note:<\/strong> The name of a worksheet tab can have a maximum of 30 characters only.<\/p>\n

Option 1: Rename worksheet tab with the “Rename” shortcut menu<\/strong><\/p>\n

Right-click on a specific tab you want to rename. You can see many options coming up when you right click. From there, choose the Rename<\/strong> shortcut menu.<\/p>\n

\"worksheet-rename-menu\"<\/p>\n

Type a name that you want to give to the worksheet tab and press Enter. Repeat this procedure for each tab you want to rename.<\/p>\n

\"type-new-name-for-worksheet\"<\/p>\n

Option 2: Rename worksheet tab by double-clicking the tab<\/strong><\/p>\n

Another way to rename a worksheet tab in Excel is by double-clicking on the sheet tab. When you double-click on the worksheet tab at the bottom, the tab name (e.g. Sheet1) is highlighted. After that, you just have to type the new name.<\/p>\n

\"double-click-sheet-to-rename\"<\/p>\n

Option 3: Rename worksheet tab using keyboard shortcut<\/strong><\/p>\n

Select the worksheet tab that you want to rename, then press the keyboard shortcut Alt<\/strong> + O<\/strong> + H<\/strong> + R<\/strong> (Just press these 4 keys on the keyboard one by one in the sequence), type a name and press Enter.<\/p>\n

Option 4: Rename multiple worksheet tabs using VBA code<\/strong><\/p>\n

It could be a time-consuming task if you use the above methods to rename lots of worksheet tabs. To simplify the job, you can rename multiple worksheet tabs using VBA code.<\/p>\n

    \n
  1. After opening your Excel workbook, press the Alt<\/strong> + F11<\/strong> shortcut to open Visual Basic Editor. Right-click on VBAProject on the left pane and choose Insert<\/strong> -> Module<\/strong> to insert a new module.\n<\/li>\n
  2. \nCopy the following VBA code and paste it to the right pane of the VBA editor (“Module1” window). Click the Run<\/strong> menu, and select Run Macro<\/strong>.<\/p>\n

    Sub RenamingSheets()
    \nnmbr = InputBox(\"What's the first number you want to name the sheets?\", \"Renaming Sheets\")
    \nFor ws = 1 To Worksheets.Count
    \nSheets(ws).Name = \"KB\" & nmbr
    \nnmbr = nmbr + 1
    \nNext ws
    \nEnd Sub<\/code><\/p>\n

    \"rename-sheet-with-vba\"\n<\/li>\n

  3. \nAll your worksheet tabs will be quickly renamed with new names like “KB1”. You can change the VBA code to rename worksheet to what you want.<\/p>\n

    \"multiple-sheets-renamed\"<\/p>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    How can I rename multiple worksheets at one time using VBA code? In Excel, you can assign a unique name to each sheet tab in your workbook so you can easily find the tab you want. In this tutorial we’ll show you 4 simple methods to rename one or multiple worksheet tabs in Excel. Note: […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,10],"tags":[3235,3233,3234],"class_list":["post-8735","post","type-post","status-publish","format-standard","hentry","category-others","category-tips-tricks","tag-rename-multiple-sheets-in-excel-vba","tag-rename-multiple-worksheets-in-excel","tag-rename-sheet-in-excel"],"_links":{"self":[{"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/posts\/8735","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/comments?post=8735"}],"version-history":[{"count":8,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/posts\/8735\/revisions"}],"predecessor-version":[{"id":8748,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/posts\/8735\/revisions\/8748"}],"wp:attachment":[{"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/media?parent=8735"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/categories?post=8735"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/tags?post=8735"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}