Rename All Sheets From A List... In One Step

There are many ways of renaming sheets in Excel.
However if you have a large number of sheets you can rename all of them in one step following a list in the worksheet itself
In this tutorial I show you how to name any number of Sheets in one step by using a List in the worksheet.
You can Download the Exercise File and the code by clicking on the link here below.
www.amazon.ca/clouddrive/shar...
You can read the steps on my blogsite www.See-How.ca
To book a corporate Training visit our website www.OfficeInstructor.ca
For Microsoft Office Specialist Certifications - MOS - and to book an exam visit www.OfficeInstructor.com

[@froidbisebenjamin2285]

What a great clear video! You explain clearly what you do and what it means. That is what is helping many people to understand!

[@elephantsarenuts5161]

No extraneous chat. Short and directly to the point. Well done.

[@Officeinstructor]

Thank you for the motivating comment

[@alanmclean1399]

Fantastically clear explanation and helpful visuals that compliment it perfectly. Really helpful for a novice VBA user like me

[@sparkleboyd6601]

THIS WAS AWESOMEEEEEEEEEEEEEEEEEEEEEEEEEEE! I am so glad I found this video Thank you! I was able to follow your instructions and I renamed 23 tabs in a matter of minutes. Much appreciated! God Bless you!!

[@vigneshkathirkamar3113]

Thanks Nabil for this video. I am beginner in vba and your videos are helping me to learn the concepts slowly. Kudos, keep going 🙌

[@ronyshafiq]

I am from bangladesh. I watch many vedio for this problem.. and finally I can say it's simple and very easier then others. Thanks a lot sir

[@sheritingle7896]

Thank you very much for an easy to follow video. Very thankful to have found your channel. GREAT STUFF!!

[@Officeinstructor]

You're very welcome Sheri

[@kealebogamoletsane977]

An excellent video, explained with much clarity and passion, thanks

[@michaelshultz5584]

Thanks - Enjoy your clear explanation of all the details

[@gregcalvert4645]

Stumbled on your channel. Love it, straight to the point useful videos. Thanks BTW, subscribed after the 3rd video.

[@Officeinstructor]

Thank you Gregory

[@kamelboukerrou6204]

Great concise and step by steps instructions. Thank you very much.

[@Officeinstructor]

Glad you liked it

[@abdulkaderk2169]

As a specialist teacher, I have to deal with multiple classes. I used to name each sheet as per your introduction. Thank you for this valuable and short method. Since I use all the sheets to insert students names, I named Sheet 1 as YEAR LEVELS created number of sheets according to the number of year levels. Thanking you again.

[@Officeinstructor]

I am glad Abdulkader my video helped you in your work situation

[@Luciano_mp]

Amazing, very helpful. Thank you Nabil!

[@Officeinstructor]

Thank you Luciano

[@fiteboss]

Great instructions. Thanks!

[@emgraves2310]

Absolutely AMAZING! Thank you :)

[@efiratcan]

THAT IS perfect... thanks a lot man.

[@mohitjagad]

Thank you Nabil for this amazing tutorial.. Thanks for sharing..👍

[@Officeinstructor]

My pleasure 😊

[@shivaprasaderram8978]

Thank you so much this was helpful

[@suatalturk3639]

great thank you so much, i helped me a lot with a workbook with more than 200 sheets :)

[@Officeinstructor]

Glad I was able to help...

[@kadirdurma]

You are great man!! it was extremely helpfull and thanks for quick codding tutorial.

[@Officeinstructor]

You're welcome!

[@countduckula9977]

Hi Nabil, Thank you for posting this extremely useful video. Your VBA explanation was clear & concise.

[@Officeinstructor]

You are most welcome

[@Officeinstructor]

You are most welcome

[@njg5942]

Worked for me - excellent, thank you.

[@Officeinstructor]

Great to hear!

[@leomason15]

Amazing!

[@joaocalunga2016]

Dear many thanks

[@donm1612]

Very helpful. Thank you!

[@Officeinstructor]

Glad it was helpful!

[@stevennye5075]

well done!

[@sherlock3293]

Thank you very much, Sir!

[@maheshbhardwaj798]

Amazing, you saved my lots of effort hurs.

[@kirandeepchoudhry9232]

Awesome way of explaining

[@Officeinstructor]

Thank you

[@MdKhan-cc1qs]

I do not know abc of VBA. But by this video I am able to rename lot of excel sheets at a single click! Thanks

[@Officeinstructor]

Congratulations on creating your first code

[@shajupaul5338]

Amazing work.

[@Officeinstructor]

Thank you Shaju Paul

[@incognitootingocni4743]

Thanks so much!!!

[@robertmillar2037]

Great work, can you do the VBA for sheet name AND add sheets depending on how many rows contain data?

[@VoiceofEagleRecordingsVER]

Amazing video

[@gmartinez101]

Thank you for sharing this, i have been looking to use this function for a week. It works great

[@milburngrimes5070]

This an excellent video, Nabil. I always wondered how to switch from one sheet to the next in order to change the names, and this is a fabulous workaround! As a language teacher, VBA makes me a bit nervous because I'm always worried about spacing, capitalization, and syntax - the same as I would while teaching composition. How do I learn the rules for VBA spacing, capitalization, indentation, etc? Keep up the fantastic work, Nabeel!

[@Officeinstructor]

Thank you for the nice comment... Did you Subscribe to my Channel? The Best Is Yet To Come

[@karunakardev980]

interesting and timesaving video thanks a lot.....

[@Officeinstructor]

You are welcome

[@mashukanam]

Thank you bro

[@ShaibulHoqueMozumder]

Thank you sir from india

[@taizoondean689]

Thank you

[@ronnie9096]

when using F8 on the fourth row "Sheet" is highlighted as an error. compiler error message is "variable not defined" so when defined sheet as worksheets, it worked thanks for the amazing tutorial.

[@Officeinstructor]

Glad it worked

[@sometrioeng2602]

it is great, sir

[@SanviPatil2019]

Amazing

[@MohAboAbdo]

Thank you so match, Sir.

[@Officeinstructor]

Always welcome

[@subratadutta4562]

Nice one

[@eyestickfpv]

What a fantastic video! Could you provide me and advice how to limit to 30 caracters? I have a list taken from an other cell and it’s more than 30 ( limit for sheet name)

[@user-rc5li9jg1q]

After a few glitches I got it to work. I was trying to put days of the month, which excel automatically turns into a date, that cannot be a sheet name (no / allowed ). A couple of extra steps fixing the list and changing it to text and bingo 35 sheets done and rolled over for another month! I think I watched another of your videos for making a totals page from a range of sheets, so there was a "first", "Last", "totals" and "rename sheets"

[@khemrajrana7322]

Thanks sir for file & u r amazing sir

[@Officeinstructor]

Thank you for the encouragement

[@berthony65]

Good day, Nabil, I am trying to follow along but I do not have the same Excel version you have, which I believe is a problem. Our tool bars are different and I also do not have access to visual basic editor. Is there another way to range the a1 column and sheets? Thanks

[@youssefb3599]

This is a great job. I do not use VB, but the way you show it and the steps are clear to anyone. Thanks a lot for this video. I am always dealing with this issue, and finally found the answer. However, how to deal with multiple excel files for which, let's say, we need to rename sheets using the same group of names? Thanks.

[@Officeinstructor]

Performing an action on multiple files requires looping over workbooks

[@brodiesammy771]

hi works great but if you want to update say 5 name out of 100 as soon as the macro hits a sheet name which is the same as it is trying to change it to it stops and errors out.. how can I fix this

[@karmen1061]

Hi , would like to ask how to save can use this marco for everyday . ?

[@AhmedAbdalalim]

Great

[@satishchaurasia84ya]

Wow nice trick thanks allot

[@Officeinstructor]

Glad you liked it

[@nguyenhoangphuc7555]

thank for you

[@Officeinstructor]

Thank you too

[@1pieceluffy1]

i want to start the renaming on the next sheet, not on the same sheet. What should I modify in the code? Thanks

[@raghavendranl]

Thank you sir, really it is great class for me. Sir, what steps in same situation in Google spreadsheets? Please guide me.

[@abbasalishah7211]

Sir what if we want "name" to be the date... I. E my workbook is named "july, 2021" and want to name sheets by date for every single day. Pls guide

[@syednabeelali4823]

Excellent

[@Officeinstructor]

Thank you so much 😀

[@sandipmakwana6462]

Super and easy

[@Officeinstructor]

Thank you 🙂

[@dimitrz2000]

Thanks very useful , quick question once all the sheets have been renamed , can I come back and delete the macro if a) I dont want to rename more sheets in future b) I want to retain a macro free workbook ?

[@Officeinstructor]

Yes, you can, Vinod

[@poojakhedekar2851]

I am copying multiple sheets in one excel and want rename it.. but due some restrictions I am not supposed to have macro in that main excel sheet.. is there any way that I can have this macro in another workbook and it will rename the sheets in the main excel sheet automatically...

[@epdiaz5813]

This is an AMAZING VIDEO! I spent so much time on other videos and I would always get an error or a bug and could never figure it out. Thank you so much! I want to ask, how do I get the sheets to start renaming beginning from the second sheet, as I don't want Sheet 1 (The list of names) to be renamed as the first name on my list?

[@clentwilliamsii225]

Thanks for the lesson, however I am trying to use this format in a workbook in which the naming sheet is the second sheet in the workbook and will only rename sheets after the naming sheet. Can you help me?

[@Officeinstructor]

Hi Assuming that the first sheet is named "Nabil" and we want to start renaming from the second sheet having the list of names, then I will add a conditional statement that evaluates the sheet name first before renaming, as follows: Sub RenameSheets() Dim i As Integer i = 1 For Each Sheet In Sheets If Sheet.Name "Nabil" Then If Cells(i, 1) "" Then Sheet.Name = Cells(i, 1).Value i = i + 1 End If End If Next Sheet End Sub Good Luck

[@abdelkrimmesaiahmed662]

Great video, but i wondering if I want the sheet where the list of names don't to be named with the code how to do this?

[@joselrivas]

Hi everything work perfect , but I want to star putting name on the second sheet . What can I change in the coding ?

[@marlonhalliday3274]

How do you indent your vb code is there a short cut key!! you use. Thanks

[@Officeinstructor]

Just put your cursor at the beginning of the line and hit TAB as many times as you want

[@albertwilson3396]

I have 12 cells I want to name 12 of the sheets (not all sheets just 12 in the middle of 24. and Cells are spread over 4*3 layout. Cells H5:K8) any thoughts?

[@suhailnbd]

Very nyc

[@Officeinstructor]

Thank you

[@vijaysahal4556]

good 👍👍

[@Officeinstructor]

Thanks

[@ericyeargain6559]

What about if you are wanting to do a Date format? I'm failing with this. If I put in alpha characters only it works, but nothing with a date

[@dbacker]

how do i avoid name is already taken error? I want the name to be replaced even if the sheet name is already the required name.

[@MrLeecavturbo]

i get an error if the cells contain anything other than letter text. i.e a date or number

[@madeleinemoorcroft7601]

I've done exactly what was showed in the video which works perfectly however the other formulas I had in my main sheet now shows BLOCKED what does this mean and how do I get around it?

[@sumitgupta9118]

Can I rename worksheet name as workbook?? For single sheet only?? I have number of files in Excel to rename??

[@jeraldthalaiva85]

Sir, incase u have to change name is automatically rename change or not??

[@ShaibulHoqueMozumder]

How to change one or moreTabs name or worksheets name in upper Case by vba? my worksheets has 100 nos

[@gerardo8229]

What if I want to hyperlink at the same time? Thanks the video it's very helpful

[@Officeinstructor]

You can... watch my other videos about Extracting a List of Sheet names and hyperlinking them

[@sushmitashettigar]

What if present name and changing name of some sheets are same. I am facing this problem getting debug message that try other method present name is same

[@ShaibulHoqueMozumder]

Sir it is unable run in excel 2013 , what we have to do? Plz help

[@sandipmakwana6462]

sir suppose i have list 15 name of sheet so please make vba code to creat sheet as per list if possible

[@sweetmask1690]

Is it working on Google sheet?

[@0106283753]

THANK YOU NABIL AMAZING VEDIOS I WANT TO CONNECT WITH YOU

[@Officeinstructor]

I'm glad you enjoyed my tutorials. You can connect with me by clicking on any of the website links in my tutorials where you'll find my contacts

[@c07072012c]

How can we make it so that it skips sheets with the name already taken and not give an error

[@mohamed.montaser]

if i want to skip the first sheet and start renaming from the second sheet, how to do it?

[@Officeinstructor]

You need to wrap the looping in a conditional statement

[@mohamed.montaser]

@@Officeinstructor i don't get it

[@LindaWhite-jc9rg]

Can you see me the code for this? Many thanks

[@chantallecompte5657]

This only worked for the first 5 names, I have 45 names. My first name starts at A4, my i value is 4, right?

[@Officeinstructor]

any code needs customization according to the work situation. I am just explaining a concept

[@chantallecompte5657]

my first tab changed to 9176?? why?

[@nattroy891]

I don't know if you're still checking comments. I put your code into my VBA exactly as you had it, but when I click 'Run' nothing happens.

[@Officeinstructor]

may be macros are disabled

[@NTECH_e-learning]

how can i rename a group of 10 sheets (middle) in a workbook

[@Officeinstructor]

You need to customize the code

[@ktimilsi]

@@Officeinstructor I came across the same situation. I have close to 200 sheets, and I only want to rename the mid 20 or so sheets. How do I customize the code to get this working?

[@christinacoleman1138]

It keeps throwing an error on "Sheet.Name = Cells(i, 1).Value"

[@eddiemendez4766]

did not work for me. I do not want to rename the tab that has the naming structure or the tab that has the summed up data but instead rename the remaining tabs. for example i have the first tab that will have the collected data represented and then the next subsequent tabs broken down by the day of the month for the entire month.

[@KaelNL]

Why "dim i" and not "dim Sheet"? Seems sloppy. I would prefer to use Option Explicit and declare both variables

[@carlosgranah]

If you are using Option explicit add this Dim Sheet As Object

[@garywenger5209]

I have followed your video several times and have even copied your code for my workbook but it will not work. I have a workbook that is called "Mixed poker rooster" that keeps track of poker players for our bowling league. It consists of a master sheet that tallies weekly deposits. The sheets are named for the day of the week for 35 weeks. IE master, 02-sep-2019, 09-sep-2019, etc. for thirty - five weeks. the statement "Sheet.Name = Cells(i, 1).Value" never gets run. Here is my routine; Sub RenameSheets() Dim i As Integer i = 1 For Each Sheet In Sheets If Cells(i, 1) "" Then Sheet.Name = Cells(i, 1).Value i = i + 1 End If Next Sheet End Sub

[@joaocalunga2016]

Dear many thanks

[@rafaelty6285]

Amazing!

[@Officeinstructor]

Thank you! Cheers!