Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • INDEX function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel ROW Function
  • To count total rows in a range in Excel
  • Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions
  • How to retrieve first match between two ranges in Excel

Data Analysis Examples

  • How To Create Frequency Distribution in Excel
  • Chart Axes in Excel
  • Remove Duplicates Example in Excel
  • How To Remove Duplicates In Excel Column Or Row?
  • Randomize/ Shuffle List in Excel

Data Validation Examples

  • Excel Data validation allow uppercase only
  • Excel Data validation with conditional list
  • Excel Data validation must contain specific text
  • Excel Data validation number multiple 100
  • Excel Data validation must not contain

Group and Ungroup Worksheets in Excel

by

You can group worksheets in Excel if you want to edit multiple worksheets at the same time. Our workbook contains 3 similar worksheets (North, Mid and South) and a blank fourth worksheet.

1. To group worksheets, hold down CTRL and click the sheet tabs of the sheets you want to group.

Worked Example:   Things you find in Excel Status Bar

2. Release CTRL.

Now you can edit multiple worksheets at the same time.

3. For example, on the North sheet, change the value of cell B2 to $1000 and delete row 4.

Worked Example:   Prevent invalid data entering in specific cells

4. Go to the other two worksheets and you’ll see that these worksheets have been edited as well.

Worked Example:   Embed Excel worksheet in Word document

5. To ungroup, right click one of the sheet tabs and click Ungroup Sheets or click any sheet tab outside the group. For example, the sheet tab of Sheet4.

Post navigation

Previous Post:

View Multiple Worksheets at Once in Excel

Next Post:

Everything about Charts in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • Remove leading and trailing spaces from text in one or more cells in Excel
  • Excel MAX, MATCH and ADDRESS function illustration
  • TEXT function: Description, Usage, Syntax, Examples and Explanation
  • Remove text by matching in a cell in Excel
  • How to count specific characters in a range in Excel
  • Convert Excel time to decimal hours in Excel
  • How to calculate next day of week in Excel
  • Get day name from date in Excel
  • HOUR function: Description, Usage, Syntax, Examples and Explanation
  • Display Date is workday in Excel
  • How to calculate annuity for interest rate in excel
  • Calculate interest for given period in Excel
  • Calculate payment for a loan in Excel
  • RATE function: Description, Usage, Syntax, Examples and Explanation
  • How to Calculate Tax Rates in Excel
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles