• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Group Sheets in Excel

June 21, 2021 by Andrew Childress
Group sheets in Excel

Sometimes, it’s useful to perform the same tasks on multiple worksheets. Let’s learn how to group sheets in Microsoft Excel.

Sometimes, it’s useful to perform the same tasks on multiple worksheets. Instead of repeating the same steps, you can group worksheets together, and then make edits just once. This is easy to do, and it only takes a few clicks. Let’s learn how to group sheets in Excel.

How to Group Sheets in Microsoft Excel

Imagine that you have an Excel workbook that contains several worksheets. These are identified by the tabs at the bottom containing the sheet names. Grouping sheets together is useful if you want to make identical edits on multiple sheets at the same time. It’s a very useful time-saving technique.

To group sheets together, you have multiple options. For any, begin by clicking on the first sheet that you want to group together. Then, your next step will vary depending on if you use Excel on Windows or Mac.

On Mac, hold down the Command key on your keyboard. Then, keeping the key pressed down, click on the names of the other sheets that you want to group together. When you’re finished, release the Command key.

Group sheets in Excel

You’ll see that all of your selected sheets are now grouped together. To do the same on Windows, simply hold down Control as you click on the sheet names.

Want to select multiple sheets in a row? Save time by clicking on the first sheet, and then hold down Shift on your keyboard. Then, click on the last sheet that you want to group together. Excel will automatically group the full range. This saves you from having to click on each sheet name individually.

Group multiple sheets in Excel

Once you’ve finished your bulk edits, you may want to ungroup your sheets. To do that, simply right-click on any of the grouped sheet tabs. Then, from the menu, click on Ungroup Sheets.

How to group sheets in Excel

They will return to their normal, ungrouped status.

As you can see, it’s easy to group sheets in Excel. This helps you make edits to multiple sheets all at once.

Category: Basics, Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Add a column in ExcelAdd a Column in Excel
Next Post:Calculate Percentage in ExcelCalculate percentages in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top