Creating a filter in Excel 2007

Posted on 2007-08-01
Last Modified: 2012-05-05
I have a very simple Excel 2007 spreadsheet which includes 4 columns in total. The last column contains a value - that by this value I would like to create a filter.

When I create a filter, it will only show my the headers of these columns, and not the actual data.

What am I doing wrong?

Question by:nahumba
    LVL 20

    Expert Comment

    On your fourth column, if you click the drop-down on your filter, have you checked "Select All"?

    Author Comment

    Yep, it doesn't work. I'm probably doing something wrong.

    I'm not so strong when it comes to Excel...  What are the basic concepts of creating a filter?
    Where can I read about it?

    LVL 7

    Accepted Solution


    This may depend on if you are using the AutoFilter or AdvancedFilter.
    AutoFilter:  Ensure when you select the Autofilter you have the search column(s) selected and use the proper operation, for example if you are searching for a partial match, say a few letters in a word / sentence, use "contains" not "equal to". If you are trying to match a date, make sure the data / cells actually contain / formatted for date values (ocassionally you see what looks like a date but is actually text).

    take a look here at the tutorials on Auto/Advanced Filters (under "A" index). They are very good and should help you through this issue.


    LVL 20

    Assisted Solution

    Also, turn off all AutoFilters or AdvancedFilters, just to make sure you're starting from scratch.

    Highlight all of column D (click on the column letter itself).

    Select Data, then Filter (from the ribbon).

    It should be set automatically.

    Author Comment

    Thank you!

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    In case Office 2010 has not been deployed in your environment, this article may be quite useful. In our office, we wanted a way to deploy Microsoft Office Professional Plus 2010 through an automated batch file via logon script. This article is docum…
    Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
    Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now