Excel will sort your data in the specified order. As shown in the screenshot below, our table is arranged alphabetically exactly as it should: first byRegion, and then byName: Tip.If the items you want to sort contain both text and numbers, check outHow to sort mixed numbers and text i...