Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Forecasting and Modeling
      • Alteryx
        • Introduction to Alteryx
      • Power BI
        • Power BI – Beyond the Basics
        • Power BI
      • Qlik Sense
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Sign Up
Home > Microsoft Excel > How to Group Worksheets in Excel? (In 3 Simple Steps)

How to Group Worksheets in Excel? (In 3 Simple Steps)

Note: This guide on how to group worksheets in Excel is suitable for Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019 and Office 365 users.  

Grouping worksheets in Excel is the best way to edit multiple sheets at the same time. It allows you to perform the same tasks on multiple worksheets seamlessly. 

In this guide, I’ll show you how to group worksheets in Excel, its uses, and how to ungroup them. 

I’ll cover: 

  1. Why Group Worksheets?
  2. How to Group Worksheets in Excel? 
  3. How to Group all Worksheets in One Go?
  4. How to Ungroup Worksheets in Excel?

You can watch this short video to easily understand how to group worksheets in Excel.

Related: 

How To Find Duplicates In Excel? The Best Guide

Excel Goal Seek—the Easiest Guide (3 Examples)

Create A Pivot Table In Excel—the Easiest Guide

Why Group Worksheets?

Grouping worksheets saves you a lot of time, especially when you need to perform the same tasks on them. When the worksheets are identically structured, you need not switch between all of them, to enter the same formula or apply the same formatting. It is better to group the worksheets together instead. 

Any change made in any one of the grouped worksheets will reflect in all other worksheets in the group, simultaneously. 

Why group Worksheets in Excel?
Notice that any change made in any one of the grouped sheets will reflect on all sheets in the group

You can use this feature to add new data to multiple worksheets, apply uniform formatting, perform the same calculations, etc. The list is practically endless. Any change that needs to be applied uniformly to all the worksheets can be done after grouping them together. 

How to Group Worksheets in Excel? 

Grouping worksheets in Excel can never get simpler. Just follow these simple steps to do this. 

Step 1: Press and hold the ‘Ctrl’ Button. 

Step 2: While holding the ‘Ctrl’ button, click on the sheet tabs you want to group, one by one. 

How to Group Worksheets in Excel
Press and Hold ‘Ctrl’ while clicking on the sheet tabs

Step 3: Release the ‘Ctrl’ button. 

All the grouped worksheets are highlighted in white
All the grouped worksheets are highlighted in white

Now, the selected sheets are grouped together successfully. Their sheet tabs will have a white background, whereas the other sheet tabs will have a grey background. 

All the edits or changes made in any of the sheets will be applied to all the grouped sheets in one go. 

How to Group all Worksheets?

To group, all worksheets in Excel follow these simple steps: 

Step 1: Right-click on any sheet tab. 

Step 2: Click on the “Select all sheets” option from the menu. 

Select the “Select all sheets” option from the Right-Click menu
Select the “Select all sheets” option from the Right-Click menu

That’s all. Now, all your worksheets are grouped together. You can edit any one of them, to apply the same changes to all of them simultaneously. 

Also Read: 

How To Use Excel Countifs: The Best Guide

Excel Conditional Formatting -the Best Guide (Bonus Video)

The Best Excel Project Management Template In 2021

How to Ungroup Worksheets in Excel?

It is important to ungroup worksheets once you have made the desired changes. You can do this in two ways:

Option 1: Click on any sheet tab outside the group. This will immediately ungroup them. 

Option 2: Right-click on any of the sheet tabs in the group and click on the ‘Ungroup Sheets’ from the menu. 

Click on the Ungroup Sheets option to ungroup all sheets
Click on the Ungroup Sheets option to ungroup all sheets

Suggested Reads: 

Create An Excel Dashboard In 5 Minutes – The Best Guide

Dynamic Dropdown Lists In Excel – Top Data Validation Guide

Predict Future Values Using Excel Forecast Sheet – The Best Guide

FAQs

How do I group two worksheets in Excel on a Mac?

To group worksheets in Excel on Mac, just hold the command key and click on the desired sheet tabs and release the command key.

How do I make multiple worksheets have the same format in Excel?

To apply the same format to multiple worksheets in Excel, group them together by holding the ‘Ctrl’ key and clicking on their sheet tabs. 

Release the ‘Ctrl’ key. 

Make the necessary formatting changes in any one of the grouped worksheets. The same formatting will be applied to all worksheets in the group. 

Let’s Wrap Up

That’s all about how to group worksheets in Excel. If you have any questions about this or any other Excel feature, let us know in the comments. We are always happy to help.

If you need more high-quality Excel guides, please check out our free Excel resources centre.

Simon Sez IT has been teaching Excel for over ten years. For a low, monthly fee you can get access to 100+ IT training courses. Click here for advanced Excel courses with in-depth training modules.

Adam Lacey

Adam Lacey is an Excel enthusiast and online learning expert. He combines these two passions at Simon Sez IT where he wears a number of different hats. When Adam isn't fretting about site traffic or Pivot Tables, you'll find him on the tennis court or in the kitchen cooking up a storm.

30 day vertical banner

Most Popular Posts

  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15
  • How to Create Charts and Graphs in Microsoft Excel 2016

Similar Posts

How to Custom Sort Excel Data? 2 Easy Steps

Managing Your Microsoft Outlook 2010 Calendar

Formatting Text in PowerPoint 2016

The Excel Solver Add-In: The Best Explanation in Just 5 Minutes

How to use Statistical Functions in Excel 2013

Creating a New Calendar in Project 2010

Course Categories

  • Web Development
  • QuickBooks
  • Microsoft
  • Adobe
  • Data Analysis

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebook
© 2022 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)