How to Sort on Multiple Fields in Excel 2013

(Optional) If the first field contains duplicates and you want to specify how the records in this field are sorted, click the Add Level button to insert another sort level, select a second field to sort on from the Then By drop-down list, and select either the ascending or descending option from its Order drop-down list to its right.

(Optional) If necessary, repeat, adding as many additional sort levels as required.

blog comments powered by Disqus
Advertisement

Inside Dummies.com