Office for Mac Issues

Fix Excel for Mac Sorting That Requires Two Attempts

John WilsonJohn Wilson Nov 20, 2026 868 views

Question details

The user needs Excel for Mac to sort data correctly on the first attempt.

Fix Excel for Mac Sorting That Requires Two Attempts
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.
Before you start

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.

Solution 1Recommended

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.

1
Select a cell

Click a cell in the column you want to sort, inside the data range.

2
Apply the sort

Open the Data tab and click the Ascending or Descending sort command.

3
Check the result

Review the sorted rows. If Excel asks whether to expand the selection, choose Expand the selection to keep related row data together.

Sort the target column from the Data tab
Free Microsoft Office alternative

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.

Sort spreadsheet columns using familiar controlsOpen and save Microsoft Excel XLSX filesUse a free, lightweight office suiteWork with a familiar interface when moving from Microsoft Office
microsoft office alternative - wps office

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.