Sorting helps you quickly organize your data to find information faster. You can sort by a single column or apply multiple levels of sorting for more complex data sets.
Do it with AI insteadSelect your data range
Click and drag to select the cells or the entire table you want to sort.
Open the Sort dialog
Go to the 'Data' tab on the ribbon and click the 'Sort' button.
Configure sort levels
In the dialog, select the 'Column' to sort by, the 'Sort On' criteria, and the 'Order'. Click 'Add Level' to include additional columns for multi-level sorting.
Apply the sort
Click 'OK' to apply the sorting rules to your data.
Yes, in the 'Sort' dialog, change the 'Sort On' dropdown to 'Cell Color' or 'Font Color'.