Fix Excel Sorting Not Working in Windows 11 and Microsoft 365
Question details
The user needs to make Excel sorting commands reorder worksheet data correctly in Windows 11 and Microsoft 365 after Office updates, repair, uninstall, and reinstall did not resolve the problem.
- Product
- Microsoft Excel / Microsoft 365 (also applicable to WPS Office Spreadsheets)
- Device & OS
- Windows 11
- Scenario
- The user opens a workbook in Excel on Windows 11, selects a data range, and applies sorting, but the row order stays the same.
- Observed behavior
- Sort commands such as Data > Sort A to Z, Sort Z to A, and Custom Sort do not change the data order even after Office was updated, repaired, uninstalled, and reinstalled.
Before changing Excel settings, open the affected worksheet and check whether the selected range has a header row, active filters, merged cells, protected sheets, or mixed data types, because these conditions can block or confuse sorting.
Set Workbook Calculation to Automatic and Reapply Sort in Excel
Use this first when sorting appears to do nothing after a Windows or Microsoft 365 update.
Excel may not recalculate or process sort operations correctly when the workbook calculation mode is set to Manual. Switching it back to Automatic resolves many sorting failures that occur after updates.
Click File > Options > Formulas, then under Calculation options select Automatic and click OK.
Select only the rows and columns you want to sort, including the header row if your data has one.
Click Data > Sort, or click Home > Sort & Filter > Custom Sort, choose the column and order, confirm My data has headers is checked, and click OK.
Start Excel in Safe Mode and Disable Add-ins
Use this when sorting still fails after calculation is set to Automatic, because an add-in conflict may block the sort command.
Remove Merged Cells, Protection, Filters, and Mixed Data Types
Use this when sorting is disabled, missing rows, or only partially reorders the data.
Sort Data Reliably with WPS Office Spreadsheets
WPS Office Spreadsheets can open your Excel workbook and sort the selected range directly with a familiar ribbon interface, avoiding the Excel add-in and calculation state conflicts that can block sorting in Microsoft 365.
- 1. Open the workbook in WPS Office Spreadsheets: Launch WPS Office, click Spreadsheets, and open the affected Excel file.
- 2. Select the data range: Highlight the rows and columns you want to sort, including the header row if present.
- 3. Open the sorting dialog: Click Data > Sort or Home > Sort > Custom Sort.
- 4. Configure sort criteria: Choose the sort column, sort order, and check the header row option if needed.
- 5. Apply and save: Click OK to sort the data, then save the file in .xlsx format to keep Excel compatibility.
Frequently Asked Questions
Why does Excel sorting do nothing after a Windows 11 update?
A Windows or Microsoft 365 update can change Excel's calculation mode to Manual. Go to File > Options > Formulas and select Automatic, then retry Data > Sort.
How do I start Excel in Safe Mode on Windows 11?
Press Windows + R, type excel /safe, and press Enter. If sorting works in Safe Mode, disable add-ins from File > Options > Add-ins > Go.
Can merged cells stop Excel from sorting?
Yes. Merged cells within the selected range commonly block sorting. Select the range, click Home > Merge & Center, and unmerge the cells before sorting.
Does a protected sheet prevent sorting in Excel?
Yes. If the sheet is protected, sorting may be disabled. Click Review > Unprotect Sheet and enter the password, then try sorting again.
Can WPS Office Spreadsheets open and sort my Excel file?
Yes. WPS Office Spreadsheets opens .xlsx workbooks and provides Data > Sort or Custom Sort options with full Excel format compatibility.
