In an interlinked dataset, sorting by any headings or columns changes the entire order of the entries. To allow sorting by individual headings, users can make multiple sortable headings in Excel.
Let’s say we have Product Sales data for a particular date with multiple headings. Now, we want to make each heading sortable.
In this article, we demonstrate enabling Filter feature and multi-level Sorting to do or make multiple sortable headings in Excel.
Download Excel Workbook
2 Easy Ways to Make Multiple Sortable Headings in Excel
The Excel Filter feature offers in-built Sort options whether the data is ranges or tables. Applying the Sort command in one header cancels the previous execution. However, enabling Filter for each heading makes the headings into multiple non-simultaneous sortable headings. On the contrary, multiple-level sorting allows successive sorting of the assigned headers depending on their Sort On options. Follow the below sections to learn more.
Method 1: Enabling Filter Feature to Allow Multiple Sortable Headings in Excel
Though Filter allows single header sorting at a time, enabling it makes all the individual headings sortable. Users can sort under each heading depending on their requirements.
Step 1: Highlight the entire range then go to Data > Sort & Filter section > Click on Filter or Home > Editing section > Select Sort & Filter > Click Filter. Also, you can insert an Excel Table to enable the Filter command.
🔺 Excel displays the Filter Icon beside each heading.
🔺 Click on the Filter Icon and to execute Ascending (A-Z) or Descending (Z-A) sorting for each heading within the range or table.
You can use the Sort by Color option in case your data contains Conditional Formatting to display entries in colors, or you can simply color format them.
Method 2: Using Multi-level Sorting to Sort Multiple Headings
Step 1: Select the entire range. Afterward, move to Data > Sort & Filter > Click Sort or Home > Sort & Filter (in the Editing section) > Click Custom Sort.
Step 2: The Sort window opens up. In the window, tick My data has headers. As the data has 4 headings, add 3 additional levels by clicking on Add Level.
Step 3: After adding an additional 3 levels,
➤ Select the most important heading as Sort by and the least important as Then by.
➤ Choose any cell property (i.e., Cell Values, Cell Color, etc.) as Sort On.
➤ Specify the sorting order offered in the drop-down options.
➤ Finally, click OK.
🔺 Excel sorts the multiple headings into a multi-level succession from the most important headings to the least important ones, as shown in the picture below.
This article demonstrates the methods to make multiple sortable headings in Excel. Users can choose any of the methods to go with depending on their outcome requirements. We hope this article offers you the necessary insights for achieving multiple sort-ability headers.
Have a quick visit to our amazing website and check out our recent articles on Excel. Happy Excelling.
- Dealing with Tables with Changing Headers in Power Query
- How to Repeat Column Headings on Each Page in Excel (3 Ways)
- Hide Row and Column Headings in Excel (2 Suitable Ways)
- Make First Row as Header in Excel (4 Simple Methods)
- How to Make a Row Header in Excel (4 Easy Ways)
- Create a Double Row Header in Excel (3 Easy Ways)
- How to Promote a Row to a Column Header in Excel (2 Ways)