In Excel how do I sort with filters applied to two different columns

Question

I want to be able to sort a data set using filters on two different columns- but seem to only be able to apply one at a time. Is there a way to do this?

Answer 1

Hi @Sharon Sakai

Thank you for posting your question in the Microsoft Q&A forum.    

Based on your description, we understand that you intend to apply multiple column filters simultaneously. We are glad to assist you this part.  

You can follow these steps to configure it: 

1. Select all the headers of the table first 
2. Under the Home tab, choose Filter command from the Sort & Filter drop-down in the Editing group of commands. You’ll find the Filter buttons on your table headers. 

Here is the result after applying two filters: 

Note: You may configure two or more filter headers before applying them.  I will be waiting for your response after configuring it. If you need further assistance, please let us know. 

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".     

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.