Office Settings & Configuration

Enable Disabled Excel Commands by Ungrouping Worksheets

Amos GikundaAmos Gikunda Nov 12, 2026 870 views

Question details

The user needs to restore Excel Data and Formula Auditing commands that are unavailable while working in a workbook.

Enable Disabled Excel Commands When Worksheets Are Grouped
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user is editing a workbook and wants to use commands on the Data or Formulas tabs.
Observed behavior
Some Excel commands are disabled, which can occur when multiple worksheet tabs are grouped or the workbook structure is protected.
Before you start

Check the Excel title bar for the word "[Group]," which indicates that more than one worksheet is selected. Make sure you have permission to change the workbook structure before attempting to remove protection.

Solution 1Recommended

Ungroup the selected Excel worksheets

Use this solution when the workbook title bar shows "[Group]" or multiple worksheet tabs are selected.

Excel limits some commands while worksheets are grouped so that changes are not accidentally applied across multiple sheets.

1
Locate the grouped worksheet tabs

Look at the worksheet tabs at the bottom of the Excel window. Grouped tabs are typically highlighted, and the workbook title bar may display "[Group]."

2
Open the tab context menu

Right-click any selected worksheet tab at the bottom of the workbook.

3
Choose Ungroup Sheets

Select Ungroup Sheets or Ungroup from the context menu. The worksheets will return to individual selection.

4
Try the command again

Open the Data or Formulas tab and select the previously disabled command, such as a Formula Auditing tool.

Ungroup the selected Excel worksheets
Commands can become available immediately: After the sheets are ungrouped, Excel usually restores commands that were disabled because of grouped worksheet selection.
Free Microsoft Office alternative

Work with Excel Workbooks in WPS Office Spreadsheets

If Microsoft Excel settings or workbook restrictions are interrupting your work, WPS Office provides a free, lightweight spreadsheet alternative with a familiar ribbon interface. Open your existing workbook in WPS Spreadsheets and continue working with worksheet tabs, formulas, and common data tools with a seamless transition.

Manage worksheet tabs and organize spreadsheet workbooks in a familiar interface.Open and edit Microsoft Excel .xlsx and .xls files with strong format compatibility.Use a free, lightweight office suite for everyday spreadsheet tasks.Move between Excel and WPS Office files without rebuilding your workbook from scratch.
microsoft office alternative - wps office

Frequently Asked Questions

How can I tell whether Excel worksheets are grouped?

Check the workbook title bar for "[Group]" and look for multiple highlighted sheet tabs at the bottom of the Excel window. Right-click a selected tab and choose Ungroup Sheets to end the grouping.

Why are Data commands disabled when sheets are grouped in Excel?

Excel restricts certain Data and Formula Auditing features when multiple worksheets are selected to prevent an action from changing several sheets at once. Ungroup the sheets before using the command.

Where is the Ungroup Sheets command in Excel?

Right-click any grouped worksheet tab at the bottom of the workbook, then select Ungroup Sheets or Ungroup from the context menu.

What should I do if Excel commands are still disabled after ungrouping sheets?

Go to Review > Unprotect Workbook and check whether workbook structure protection is enabled. You may need the protection password from the workbook owner.