Fix Excel for Mac Sorting That Requires Two Attempts
Question details
The user needs Excel for Mac to sort data correctly on the first attempt.

- Product
- Microsoft Excel for Mac 16.16.9
- Device & OS
- Mac running macOS Mojave
- Scenario
- The user sorts a column in an Excel workbook.
- Observed behavior
- The data may appear to require two sorting attempts before it is sorted correctly.
Identify the column you want to sort and check that the rows belong to one contiguous data range. Note whether the behavior occurs in one workbook or in several workbooks.
Sort the target column from the Data tab
Use Excel's standard sort commands to test whether the data sorts correctly on the first attempt.
Click a cell in the column you want to sort, inside the data range.
Open the Data tab and click the Ascending or Descending sort command.
Review the sorted rows. If Excel asks whether to expand the selection, choose Expand the selection to keep related row data together.

Test the data in a new Excel workbook
Use a new workbook to check whether the sorting behavior is specific to the original file.
Isolate macOS and user-profile causes
Test Safe Mode and another macOS account if sorting still requires two attempts or affects multiple workbooks.
Sort spreadsheet data with WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for opening and sorting spreadsheets. Its Microsoft Office format compatibility helps you move existing files into a familiar workflow.

Frequently Asked Questions
Why does Excel for Mac seem to require sorting twice?
The cause may be specific to the workbook, the macOS user profile, startup software, or the Excel installation. Test a new workbook and compare sorting in Safe Mode and another user account.
How do I sort a column without separating its rows?
Select a cell in the data range, then use the Ascending or Descending command on the Data tab. If Excel prompts you, choose Expand the selection so related row data stays together.
What does it mean if sorting works in a new workbook?
That suggests the behavior may be specific to the original file. Copy the relevant cells into a new workbook, test the sort, and check formulas and formatting before using the copy.
How do I check for Excel for Mac updates?
In Excel, choose Help > Check for Updates and follow the available update prompts. The updates offered depend on your Excel version and macOS compatibility.




