Autofiltering multiple tables on a spreadsheet

[Paul]

I downloaded a sample to do list spreadsheet from the Microsoft templates
section. It uses autofilter to create the drop down filter for "done" items.
It filters the three orginal tables & headers that came with the template.
That is to say that it retains and shows the headers of even empty tables
which is what I want. I then copied and pasted a fourth table, but the
autofilter really only affects the original three. None of these table are
yet very long (average 24 rows each), but I wish to expand beyond three
tables with headers.

If you can, you can quickly see the template at:

http://office.microsoft.com/en-us/templates/TC010185861033.aspx?CategoryID=CT062640421033

 

[Gord Dibben]

Paul

After you have copied say Table 3 and renamed it Table 4 go to
Data>Filter>Autofilter and uncheck it.

Now select from Table 1 "Done" cell to bottom of Table 4

Data>Filter>Autofilter. Check it on.

Enter a date in Table 4 "Date due" and enter an "a"(no quotes) in the "done"
column next to that date.

You should get a checkmark.

Try your Filter now. Click on the Autofilter arrow and select "non blanks".


Gord Dibben Excel MVP