How to sort multiple columns in excel without mixing data

Must-read Windows coverage

Sorts are a simple task in Microsoft Excel if all you need is an ascending or descending sort.

Excel is smart enough that it can interpret the data range.

Excel sort multiple columns alphabetically

Not all sorts are so easy. Fortunately, Excel offers two types of custom sorts: by irregular terms and by multiple columns. The recent article, How to create a custom sort when a regular sort won’t do in Excel, shows you how to create a unique list of sorting elements, such as Monday, Tuesday and so on, or Small, Medium and Large.

In this article, I’ll show you how to sort by multiple columns. For instance, you might want to sort a sales sheet by personnel and then region. The end result groups the personnel and then further groups each of those groups by region.

SEE: Excel tips every user should master (TechRepublic)

There are two ways to initiate a custom sort:

• On the Home tab, click Sort in the Editing group and click Custom Sort.
• On the Data tab, click Sort in the Sort & Filter group.

Please use whichever you pre

how to sort multiple columns in excel pivot table

how to sort multiple columns in excel by number