Forum Discussion
Sort in alphabetical order; sub total groups
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.