Forum Discussion

Dodey's avatar
Dodey
Copper Contributor
Nov 16, 2026

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 I have help somewhere. 

We tried update, reparing, uninstal and instal with no results

 

3 Replies

  • SelinaKnow's avatar
    SelinaKnow
    Iron 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.

  • One more thing worth checking that Ryan didn't mention, since a reinstall wouldn't fix it: merged cells. Excel won't sort a column that contains merged cells, and a sort click can just sit there doing nothing, which matches what you're describing. Merged cells are easy to miss too, especially in a header row or a title area above the data.

     

    The quick way to hunt them down in desktop Excel is Home, Find and Select, Find, then Format, Alignment, tick Merge cells, and Find All. That lists every merged cell on the sheet. Unmerge the ones in or above your data range, then try the sort again. If the merged cells are there for layout, like a title across the top, move the title out of the sort range rather than unmerging it.

     

    Given the reinstall didn't help, it's almost certainly something in the sheet itself, so the table, protection and merged-cell checks between Ryan's reply and this one should pin it down.

  • Ryan_C1's avatar
    Ryan_C1
    Brass Contributor

    Since reinstalling hasn’t helped, I’d check the worksheet’s structure and restrictions next. The two buttons may have different reasons for not working.

    First, save a copy of the workbook and try these checks in desktop Excel:

    • Click inside your data. If a Table Design tab appears, the data is an Excel Table. The Data → Subtotal command isn’t available for tables. In the copy, choose Table Design → Convert to Range. This keeps the data and formatting but removes table-specific features.
    • Check Review for an Unprotect Sheet button. If it appears, the sheet is protected, which can restrict sorting and other changes. You’ll need the password if one was set.
    • If several sheet tabs are selected, right-click a selected tab and choose Ungroup Sheets.

    For sorting, select the complete data range, including all related columns, then choose Data → Sort. Select the column you want and choose A to Z. Check “My data has headers” if appropriate. Avoid sorting just one column independently, as that can separate names from their matching numbers.

    For subtotals, first sort by the column that defines your groups. Then choose Data → Subtotal, set “At each change in” to that grouping column, choose Sum, and tick the numeric column to total.

    If sorting still does nothing, type a few unsorted names into a new blank workbook and test there. If that works, the issue is specific to the original workbook rather than the Excel installation.