Forum Discussion
Dodey
Nov 16, 2026Copper Contributor
Sort in alphabetical order; sub total groups
Sort in alphabetical order : button is active but not responding to command, also i'm trying to sub total groups of number and button stays grey unavailable. Microsoft support can't do anything. May...
SelinaKnow
Nov 17, 2026Iron Contributor
Check the range for merged cells before trying Sort again. A merged cell crossing rows can stop an otherwise active sort command, and reinstalling Excel will not change that. On a copy of the sheet, unmerge the data area, select the whole range, and retry Data > Sort.