How to Arrange Furniture in a Small Bedroom
Q&A for How to Use AutoFilter in MS Excel
Coming soon
Search
-
QuestionHow do you know when the autofilter is turned on?Community AnswerDropdown 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.
-
QuestionNot all the variables in my field of data are appearing in my filter selection. How do I correct this?Community AnswerIt'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.
-
QuestionHow can I set Excel 2007 so that upon opening, AutoFilter will have the "select all" box to be unchecked?Community AnswerThis 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.
-
QuestionHow can I set 2 different columns (not next to each other) using the autofilter?Community AnswerThis 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.
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
