Excel - How To Make Changes To Multiple Excel Sheets - Episode 1983
3,030 views · Published 10 August 2016 · 6:03 · Indexed 27 October 2026
Channel: MrExcel.com · 2016 · Education
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-on-youtube/ 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/1153811/
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920