Dear Roger:

I was able to create the Show All and Autofilter icons this time. Thanks.

Just an aside; the adjascent columns within the range I am working on that I
don't wish to filter aren't blank.

I highlighted the entire range of columns I wish to perform the filtering
operation on. Then I did DataFilterAutofilter and saw that it was only
these columns that had the dropdown arrow on them. I clicked the dropdown on
the primary column and applied the filter to it. I see that its arrow turned
blue.

Then I clicked the blue arrow on the primary column, selected "All". This
just seems to have undone the filtering operation, but maintained the
highlighting on the entire range I highlighted originally. It doesn't seem
that the filtering was done on any of the other columns.

I think I should be ok with just applying the filter to one column at a
time, but with the area highlighted as you've suggested. With the All icon
button, I now can undo it quickly and go do the fltering on the auxilliary
columns using the Autofilter icon button, and check for any blank spaces in
the primary column by simple visual inspection, and do this pretty quickly
enough.

This sounds like what you are reccommending when you say, "Just use the
dropdowns on any columns that you wish to filter by". I guess I was just
looking for an even quicker more efficient way to filter all three colums at
once for all rows that had at least one entry greater than zero. If you know
how to do this, please let me know. Otherwise, I am fine for the time being
applying what I've learned from you thus far.

Thanks for your help.

Mick


"Roger Govier" wrote:

Hi Mick

I fear I may have mislead you with my instructions.
It does not matter whether there are any blank columns within your data,
or whether there are columns that you don't wish to filter.
I usually mark the complete range then DataFilterautofilter to be sure
that the filter is available on all columns that I wish to use, even if
some are blank within the range. You can click on any cell within your
data and choose DataFilterAutofilter, but if you have any blank
columns, then it will think the table only applies up to the first blank
column, and will not apply the dropdown to other columns beyond that.

Just use the dropdowns on any columns that you wish to filter by.
When a filter is applied, the small downward pointing arrow on the
filter button, turns Blue, but this can sometimes be difficult to see.
Selecting any of these Blue dropdowns and selecting All, removes the
filter on that column, but would leave it still applied to any others.

The advantage of Show All, is that it will remove all filters that had
been applied in one go, taking you back to the full set of data.
Try again with adding it to your toolbar.
ViewToolbarsCustomiseCommandsCategoriesData
At this point, with Data highlit, you should see Commands in the right
hand pane of the Dialogue box.
Show All is the 5th item down.
Whilst holding your let mouse button down on Show All, drag it to the
toolbar, to a position between a couple of icons that are there, until
the cursor changes to a long black bar, then release the mouse button.
It doesn't seem to like it if you try and drop it in a blank area at the
end of the toolbar, and maybe this has been your problem.

Whilst in this Customise mode, also drag the Autofilter icon to your
toolbar, next to the Show All, then click Close.

Now when you want to apply Autofilter, just click the Autofilter button.
When you have selected a whole range of different filters and have a
smaller subset of your data showing, just click Show All to get back to
the full set, with all of the filter icons still in place.

For more help on Autofilter, take a look at Debra Dalgleish's site
http://www.contextures.com/xlautofilter01.html

--
Regards

Roger Govier


"Motown Mick" wrote in message
...
Dear Roger,

I tried holding down the control key, and selecting the columns I
wanted to
perform the operation on such that they were all highlighted
simultaneously;
I had to do it this way because they are non-adjascent columns.

When I did autofilter, I got an error message that said the command I
chose
could not be performed with multiple sections, and that I had to
select a
single range and try again.

I suppose I could copy all the relevant columns to another location,
arrange
them adjascently, and performe the filtering operation on the bunch of
them
that way. As long as all the pertinent rows matched, it would produce
the
same desired result. If you know of a quicker easier way to perform
this
operation on non-adjascent columns, please kindly share your
knowledge.

It's doesn't matter that much, though, because by clicking "All" on
the
dropdown menu, as you have explained, and playing with the autofilter
function on the other columns, I am able to get the knowledge I am
looking
for in a fairly expedient fashion. What's going on is I have three
columns
in which I am looking for entries greater than zero. There is one
primary
column in which I am looking for entries greater than zero, but I need
to
check and make sure that the other two columns don't have entries
greater
than zero in rows in which the primary column is blank. Performing
the
autofilter on the auxiliary rows, and then checking the primary column
for
blank spaces accomplishes that task fairly efficiently, now that I
know about
"All" on the dropdown menu, thanks to you.

Your instructions on how to create the "Show All" icon on my toolbar
didn't
seem to work for me, but does this just do the same thing as selecting
"All"
on the column dropdown menu as I have been doing?

Mick