This post will guide you how to rename multiple worksheets in your current workbook in Excel. How do I rename multiple worksheets at one time in Excel 2013/2016. How to rename one or multiple worksheet tabs in Excel.
Rename Multiple Worksheets
You can rename multiple worksheets manually by the following steps:
#1 select one worksheet that you want to change the sheet tab.
#2 right click on it and select Rename from the popup menu list.
#3 type a new name for the selected worksheet.
You can also use a VBA Macro code to rename multiple worksheet quickly, just do the following steps:
#1 open your excel workbook and then click on “Visual Basic” command under DEVELOPER Tab, or just press “ALT+F11” shortcut.
#2 then the “Visual Basic Editor” window will appear.
#3 click “Insert” ->”Module” to create a new module.
#4 paste the below VBA code into the code window. Then clicking “Save” button.
Sub RenameMultipleWorksheets() cName = Application.InputBox("Please type one new name:", "RenameMultipleWorksheets", "", Type:=2) For i = 1 To Application.Sheets.Count Application.Sheets(i).Name = cName & i Next End Sub
#5 back to the current worksheet, then run the above excel macro. Click Run button.
#6 type one new name in the text box.
#7 let’s see the result.