7 Ways to Rename Sheets in Microsoft Excel

[@GRANT1W]

Thank you! I was having a problem doing the, rename closed before saving reverting back to the default. My IT department simply said it was a “known [microsoft] issue”. I’ve been looking for a work around and the navigation option worked for me.

[@ReadySteadyExcel]

Great tips! Can't believe someone has disliked this video already.

[@HowToExcelBlog]

Ha, oh well. It happens and I don't spend too much time worrying about it.

[@ReadySteadyExcel]

@@HowToExcelBlog That's the spirit! 😊....I feel the same when it happens on my channel.

[@FRANKWHITE1996]

Its from sheet name change hater 😅

[@thestitchmenagerie]

I know this is an older video and I am not sure you will see my question, but here goes. I have a workbook with 48 sheets that need to be renamed based on a summary table at the front of the workbook. I tried using Office Scripts to rename the first sheet, but when I looked at the Script details, the name of the sheet was "hardcoded" and I am not sure how to make that more dynamic, nor am I sure how to make the new name dynamic based on the summary table rows. I have to recreate this workbook each year with the list of new investors and I really hate having to double click and type the new sheet names each year. Would love to have the Office Script in the template workbook. Thanks.

[@wayneedmondson1065]

Hi John. Great summary! Here are a couple more: F6, SHIFT+F10, r and also through the VBE Properties window you can retype the Name property (not the "(Name)" property which is the code name) which will change it immediately in the workbook. The fun never ends with EXCEL :)) Thumbs up!!

[@HowToExcelBlog]

Thanks! Will have to add those to the blog post.

[@ks-org]

Very nice sir thanks ❤❤❤❤

[@bluehorizon5672]

As always great info! 👍

[@FRANKWHITE1996]

Thanks for sharing! 👍

[@sabduljabbar5026]

Good afternoon Sir, How to get end date and time if i have start day and time together and to add "n" working hours excluding non working hours. example 1) if start date=02/06/2022 02:00 and to add 4:00 working hours and the working hours are from 08:00 to 18:00 and the non working hours to be excluded are of from 18:00 to 08:00 and the end date should be like 02/06/2022 12:00. what is the formula for this one sir. 2) if start date=02/06/2022 16:00 and to add 4:00 working hours and the working hours are from 08:00 to 18:00 the and the non working hours to be excluded are of from 18:00 to 08:00 and the end date should be like 03/06/2022 10:00. what is the formula for this one sir. In CCC to be completed time also same formula given sir. Can u please help me with the formula sir?