Excel - How To Make Changes To Multiple Excel Sheets - Episode 1983
Microsoft Excel Tutorial - Technique to change all worksheets using Group Mode.
Welcome to another episode of the MrExcel podcast, sponsored by the book "MrExcel XL"! In this episode, we will be discussing how to quickly make copies of sheets using the Group Mode feature in Excel. This is a powerful tool, but it can also be dangerous if not used carefully.
In episode 1981, I showed you how to use CTRL drag to quickly create copies of sheets. However, this violates a business rule that I like to call the "Manager 15 Minute Rule". This rule states that when a manager asks for a task, they usually change their mind within 15 minutes. This means that instead of making one change, we would have to make 12 changes for each month of the year.
To avoid this, we can use the Group Mode feature. Simply select the January sheet, and then shift-click on December to group all the sheets together. This means that any changes made to the January sheet will also be applied to all the other sheets in the group. However, this can be dangerous if we forget that we are in Group Mode.
To avoid making changes to the wrong sheet, I have a simple trick. I always have a sticky note on my wall that says "Bill... You are in Group Mode!" This serves as a reminder to always double check before making any changes.
To exit Group Mode, there are three different methods depending on the selection of sheets. If not all sheets are selected, simply click on a sheet that is not in the group. If all sheets are selected, click on a sheet that is not the active sheet. And if you want to reliably exit Group Mode, right-click on any sheet tab and choose "Ungroup Sheets".
I want to thank Olga K for suggesting the Group Mode feature, as it was one of her ideas that was crowdsourced for the book "MrExcel XL". If you're enjoying these tips, make sure to subscribe to the MrExcel XL playlist and check out the book for even more helpful Excel tips.
Thank you for tuning in to this episode of the MrExcel podcast. We hope you found this tip useful and we'll see you next time for another netcast from MrExcel!
Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/
You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-...
Table of Contents:
(00:00) Changing All Excel Sheets with Group Mode
(00:27) Manager 15-Minute Rule
(01:00) A Powerful but Dangerous Trick
(01:12) Entering Group Mode
(02:22) Making Changes in Group Mode
(03:24) Don't Forget You are in Group Mode!
(03:44) How to Exit Group Mode
(04:27) Bonus Tip: Selecting Specific Sheets in Group Mode
(04:48) Clicking Like really helps the algorithm
#excel #excelgroupmode
This video answers these common search terms:
how to change multiple sheets in excel
how to make changes in all sheets in excel
how to make changes to multiple excel sheets
how to remove group in excel sheet
how to group together two worksheets in excel
how to group together two excel worksheets
video on how to make changes on excel sheets simutaneoulsy
video on how to make changes in excell sheets simulateously
how do i group tabs in excel
how to group sheets in excel
how to group sheets on excels
how do i group sheets in excel
how to group the sheets in excel
how to group worksheet in excel
how to group worksheets in excel workbook
how to group worksheets in excell
how to group worksheets on excel
how to group worksheets together in excel
how to group excel sheets
how to group to worksheets in excel
how to group multiple sheets in excel
how do you group all worksheets in excel
how to group multiple worksheets in excel
how to group together worksheets excel
how do you group and ungroup sheets in excel
how to group add then ungroup worksheets in excel
how to change worksheets in excel
how to ungroup worksheets in excel
how do you ungroup worksheets in excel
After watching episode 1981, you can now make copies of worksheets really fast. When your manager changes the request, you might have to change 12 sheets. This episode introduces you to the powerful but dangerous Group Mode. Also in this episode:
Learned how to make copies of sheets quickly in podcast 1981
Manager 15 minute rule says your manager will change their mind 15 minutes after a request
Select Jan sheet. Shift-click on Dec sheet to begin group mode
Any change to Jan is happening to all sheets in the group
Easy to forget that you are in group mode
Every time I am in group mode, the phone rings
Three ways to exit group mode
Select a sheet not in the group.
If all sheets are grouped, select any sheet other than the active sheet
Right-click sheet tab and choose ungroup sheets
Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...
Смотрите видео Excel - How To Make Changes To Multiple Excel Sheets - Episode 1983 онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь MrExcel.com 10 Август 2016, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 2,688 раз и оно понравилось 43 людям.