Enable Disabled Excel Commands by Ungrouping Worksheets
Question details
The user needs to restore Excel Data and Formula Auditing commands that are unavailable while working in a workbook.

- 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.
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.
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.
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]."
Right-click any selected worksheet tab at the bottom of the workbook.
Select Ungroup Sheets or Ungroup from the context menu. The worksheets will return to individual selection.
Open the Data or Formulas tab and select the previously disabled command, such as a Formula Auditing tool.

Remove Excel workbook structure protection
Use this solution if the sheets are not grouped but commands remain unavailable and the workbook structure is protected.
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.

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.




