How To Rename Multiple Worksheets At Once With VBA Code In Excel || Excel Tricks || Rename Sheets

In this tutorial, let us learn how to rename multiple worksheets at once using VBA code in MS Excel.

Best Laptops to use for better speed:

The common way to rename a sheet in excel is by right clicking on any sheet tab and selecting the option called Rename.

But we have to do this manually one by one if we have got multiple sheets to rename.

So now, in this video, let us learn how to automatically rename multiple worksheets at once using the VBA code.

1. Right click on any sheet tab, and click on View code option or press Alt+F11 to go to VBA window.

2. Insert a module and copy, paste the code as mentioned below.

Sub ChangeWorkSheetName()
Dim Rng As Range
Dim WorkRng As Range
On Error Resume Next
newName = Application.InputBox(“Name”, xTitleId, “”, Type:=2)
For i = 1 To Application.Sheets.Count
Application.Sheets(i).Name = newName & i
Next
End Sub

3. Close this window and go back to the Excel window

4. From the view tab of the Menu bar, Select Macro and click on Run. A pop-up window will open up and enter the name that you want to give. Here I am giving it as "dptutorials".

5. click ok.

6. You can that all the sheets getting renamed with the name that has been given.

Our Recommendations
***************************************************************

If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later.

***********************************************

⚡️Tools for YouTube vlogging:
***********************************************
***********************************************

⚡️You Can Connect with Me at:
***********************************************

#dptutorials #Exceltraining #ExcelTricks #ExcelTips #ExcelFreeTraining #ExcelFreeLearning

⚡️Tags: -
excel formulas in English, excel in English, excel tutorial in English,ms excel in english,ms excel tutorial in English, learn excel in English,vlookup in excel in English, learn ms excel in English, excel training, excel tutorial, Microsoft Excel 2007, learn excel,tutorial excel, ms excel tutorial, excel tutorials,ms excel 2007,Microsoft Excel training,learn excel online,learning excel,free excel training,online excel training,advanced excel tutorial,excel tutorial, excel formulas and functions, excel formulas, excel tutorial in Hindi, excel formulas and functions in Hindi, excel tricks, excel in Hindi, excel shortcut keys, excel vlookup, excel formulas in Hindi, excel for beginners, Rename 31 Worksheets,Rename Worksheets,how to rename multiple sheets in excel,How To Rename Multiple Worksheets At Once,Rename Sheets,rename excel sheets,rename excel sheets from list,rename excel sheets vba,rename sheet vba,rename sheet in excel shortcut,rename sheet in excel vba,rename sheet in excel shortcut key,rename sheet shortcut key,rename sheet based on cell value,rename sheet in excel uipath,rename sheets in excel from list,rename sheet name in excel

⚡️Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

[muhammudravat]

I want to rename tabs with dates so the week commencing dates for the full year, how can I do this??

[Zestylime]

What if I need to add a word in front of table names that are already there. For example, I want to have "Table1A", "Table2B", ... but now I have "1A", "2B", ...


Thank you!

[andrelima]

That is great. But how do I rename almost all sheets? Meaning, I have some I don't want to rename. I know I can switch i= 4, 5 but that will name my tabs starting at 5 too

[ndk-arts-n-excel]

If I want to change the same date in all sheets at once, what would be the code?

[coolag]

Can you help me with my task? I need your help to generate the VBA code...

[giancarloforero]

What if I dont want to rename, but instead add a name onto every sheet?

[henriettatan]

I can't seem to see view code: my version is: 16.16. 26 with online update. Could you help? Thx a million

[dougminaker]

I have a list of students' names that I want to populate the tabs with. Is this possible to do? What would be the code?

[eddiemendez]

why are you using the name of a 3rd party tool in your code?

[bingbird]

I guess it's impossible to not have a strong-ass accent that makes it hard to understand the video. I'll send the first person from India that doesn't have a crazy accent a $25 Starbucks gift card. Not hating, just giving constructive feedback that others don't have the guts to give:)