Q&A for How to Use AutoFilter in MS Excel

Return to Full Article

Coming soon
Search
Add New Question
  • Question
    How do you know when the autofilter is turned on?
    Community Answer
    Community Answer
    Dropdown menus will appear at the top of each column. Those with active filters will display a small filter icon next to the dropdown menu arrow.
    Thanks! We're glad this was helpful.
     Thank you for your feedback.
     If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 0 Helpful 7
  • Question
    Not all the variables in my field of data are appearing in my filter selection. How do I correct this?
    Community Answer
    Community Answer
    It's possible that you have set conflicting filters. Try clearing some of your filters. If you are using a custom filter, check your "and/or" logic.
    Thanks! We're glad this was helpful.
     Thank you for your feedback.
     If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 0 Helpful 4
  • Question
    How can I set Excel 2007 so that upon opening, AutoFilter will have the "select all" box to be unchecked?
    Community Answer
    Community Answer
    This checkbox cannot be deselected by default. If you use Advanced Filter instead of AutoFilter, you can select which ranges you want filtered from the start.
    Thanks! We're glad this was helpful.
     Thank you for your feedback.
     If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 1 Helpful 2
  • Question
    How can I set 2 different columns (not next to each other) using the autofilter?
    Community Answer
    Community Answer
    This cannot be done with AutoFilter since the process is automatic. However, you can use Advanced Filters to manually define ranges which you wish to filter.
    Thanks! We're glad this was helpful.
     Thank you for your feedback.
     If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 2 Helpful 4
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit

Return to Full Article

You Might Also Like

Sort a List in Microsoft Excel
How to
Sort a List in Microsoft Excel
Sort Microsoft Excel Columns Alphabetically
How to
Sort Microsoft Excel Columns Alphabetically
Clear Filters in Excel2 Simple Ways to Clear Filters in Microsoft Excel
Filter by Color in Excel
How to
Filter by Color in Excel
Alphabetize Cells in Excel
How to
Alphabetize Cells in Excel
Sort by Number on Google Sheets on PC or MacThe 3 Easiest Ways to Sort by Number in Google Sheets
Make Tables Using Microsoft ExcelSimple Steps to Make Tables in Excel
Excel How to Remove Blank RowsStep-by-Step Guide to Removing Blank Rows in Excel (or Google Sheets)
Create a Filter View on Google Sheets
How to
Create a Filter View on Google Sheets
Use ExcelNew to Excel? Here's Super Easy Tricks to Get You Started
Sort on Google Sheets on AndroidSorting Data in Google Sheets: Android Mobile Guide
Add Filter to Pivot Table
How to
Add Filter to Pivot Table
Group and Outline Excel Data
How to
Group and Outline Excel Data: Easily Collapse Rows of Info
Make a Spreadsheet in Excel
How to
Make a Spreadsheet in Excel