Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Grouping and Ungrouping Worksheets | Working with Worksheets and Workbooks
Excel Essentials
course content

Course Content

Excel Essentials

Excel Essentials

1. Introduction to Excel
IntroductionGetting Acquainted with ExcelExcel InterfaceEntering DataChallenge
2. Entering and Formatting Data
Formatting CellsFormatting TextFormatting NumbersChallenge
3. Basic Formulas and Functions
Introduction to Formulas and FunctionsUsing Cell ReferencesUnderstanding RangesCommon FunctionsApplication of INSERT FUNCTIONChallenge
4. Advanced Formulas and Functions
Displaying and Highlighting FormulasIF Logical Test and Relational OperatorsNested IF StatementsCompound Logical Tests with AND, ORUsing Auditing ToolsConditional FormattingChallenge
5. Data Management and Analysis
Sorting DataFiltering Data Using AutoFilterClearing and Reapplying FiltersRules and SearchCreating and Managing TablesTable Styles and Quick Formatting OptionsUsing Table ToolsChallenge
6. Visualizing Data with Charts and Graphs
Types of ChartsCreating a Basic ChartCustomizing Chart ElementsChanging Chart Styles and ColorsAdding and Removing Chart ElementsEditing Data in ChartsAdding Trendlines to ChartsChallenge
7. Working with Worksheets and Workbooks
Add, Delete, Rename, and Rearrange WorksheetsGrouping and Ungrouping WorksheetsUsing the Format PainterInserting and Deleting Columns, Rows, and CellsHiding and Unhiding Columns and RowsSaving WorkbooksOpening and Closing WorkbooksProtecting Workbooks with PasswordsUsing TemplatesChallengeSummary

Grouping and Ungrouping Worksheets

In this chapter, we take worksheet management to the next level by learning how to group and ungroup worksheets.

Grouping worksheets allows you to make changes to multiple sheets simultaneously, saving you a ton of time.

This technique is invaluable when dealing with large datasets or when you need consistency across your workbooks.

Key Points

  • Group adjacent sheets by clicking the first tab, holding Shift, and clicking the last tab;
  • Group non-adjacent sheets by holding Ctrl and clicking each tab;
  • Right-click any grouped worksheet tab and select Ungroup Sheets;
  • Make edits to grouped sheets to apply changes across all selected sheets.

Task

  • Click the tab of the first worksheet to group. Hold down the Shift key and click the tab of the last worksheet to group adjacent sheets.
  • Hold down the Ctrl key and click the tabs of Section 5 and 7 to group them.
  • Make changes to the grouped worksheets.
  • Right-click a grouped tab and select Ungroup Sheets to ungroup them.

Task

  • Click the tab of the first worksheet to group. Hold down the Shift key and click the tab of the last worksheet to group adjacent sheets.
  • Hold down the Ctrl key and click the tabs of Section 5 and 7 to group them.
  • Make changes to the grouped worksheets.
  • Right-click a grouped tab and select Ungroup Sheets to ungroup them.

Mark tasks as Completed

Everything was clear?

Section 7. Chapter 2

Choose your plan

Grouping and Ungrouping Worksheets

In this chapter, we take worksheet management to the next level by learning how to group and ungroup worksheets.

Grouping worksheets allows you to make changes to multiple sheets simultaneously, saving you a ton of time.

This technique is invaluable when dealing with large datasets or when you need consistency across your workbooks.

Key Points

  • Group adjacent sheets by clicking the first tab, holding Shift, and clicking the last tab;
  • Group non-adjacent sheets by holding Ctrl and clicking each tab;
  • Right-click any grouped worksheet tab and select Ungroup Sheets;
  • Make edits to grouped sheets to apply changes across all selected sheets.

Task

  • Click the tab of the first worksheet to group. Hold down the Shift key and click the tab of the last worksheet to group adjacent sheets.
  • Hold down the Ctrl key and click the tabs of Section 5 and 7 to group them.
  • Make changes to the grouped worksheets.
  • Right-click a grouped tab and select Ungroup Sheets to ungroup them.

Task

  • Click the tab of the first worksheet to group. Hold down the Shift key and click the tab of the last worksheet to group adjacent sheets.
  • Hold down the Ctrl key and click the tabs of Section 5 and 7 to group them.
  • Make changes to the grouped worksheets.
  • Right-click a grouped tab and select Ungroup Sheets to ungroup them.

Mark tasks as Completed

Everything was clear?

Section 7. Chapter 2

Choose your plan

Grouping and Ungrouping Worksheets

In this chapter, we take worksheet management to the next level by learning how to group and ungroup worksheets.

Grouping worksheets allows you to make changes to multiple sheets simultaneously, saving you a ton of time.

This technique is invaluable when dealing with large datasets or when you need consistency across your workbooks.

Key Points

  • Group adjacent sheets by clicking the first tab, holding Shift, and clicking the last tab;
  • Group non-adjacent sheets by holding Ctrl and clicking each tab;
  • Right-click any grouped worksheet tab and select Ungroup Sheets;
  • Make edits to grouped sheets to apply changes across all selected sheets.

Task

  • Click the tab of the first worksheet to group. Hold down the Shift key and click the tab of the last worksheet to group adjacent sheets.
  • Hold down the Ctrl key and click the tabs of Section 5 and 7 to group them.
  • Make changes to the grouped worksheets.
  • Right-click a grouped tab and select Ungroup Sheets to ungroup them.

Task

  • Click the tab of the first worksheet to group. Hold down the Shift key and click the tab of the last worksheet to group adjacent sheets.
  • Hold down the Ctrl key and click the tabs of Section 5 and 7 to group them.
  • Make changes to the grouped worksheets.
  • Right-click a grouped tab and select Ungroup Sheets to ungroup them.

Everything was clear?

In this chapter, we take worksheet management to the next level by learning how to group and ungroup worksheets.

Grouping worksheets allows you to make changes to multiple sheets simultaneously, saving you a ton of time.

This technique is invaluable when dealing with large datasets or when you need consistency across your workbooks.

Key Points

  • Group adjacent sheets by clicking the first tab, holding Shift, and clicking the last tab;
  • Group non-adjacent sheets by holding Ctrl and clicking each tab;
  • Right-click any grouped worksheet tab and select Ungroup Sheets;
  • Make edits to grouped sheets to apply changes across all selected sheets.

Task

  • Click the tab of the first worksheet to group. Hold down the Shift key and click the tab of the last worksheet to group adjacent sheets.
  • Hold down the Ctrl key and click the tabs of Section 5 and 7 to group them.
  • Make changes to the grouped worksheets.
  • Right-click a grouped tab and select Ungroup Sheets to ungroup them.

Section 7. Chapter 2
Switch to desktop for real-world practiceContinue from where you are using one of the options below
We're sorry to hear that something went wrong. What happened?
some-alt