Suppose you have data in Col A to D with headings (labels) in row one

If you Choose Data-Filter-Auto Filter
Excel add a drop-down arrow to the cells in the top row, if you click it you
get the options to select the values you want to see.. excel then shows only
those rows which have that value.. this is what is called filtering...

Under certain conditions, when you select the filtered cells, underlying
data gets selected as a whole...

When you press F5 and then press Special you get an option to select VISIBLE
cells only... Mostly it is not required.

Only way you can master these things is by playing around... experiment and
see what happens.


"istella" wrote:



"Sheeloo" wrote:

Thanks. Helping you made my day...

I have added columns like Family, Friend, Work etc. (basically different
Distribution lists) and entered Y against the address belonging to that
group...

When required I filter on the right column, select (visible) Col B, paste in
BCC (not in To field :-))
and send out my mail...


Hi, I'm pretty new at some of the finer points of excel. How do you
"filter" and what do you mean by select (visible) Col B, i.e. how do you
select just the visible (I assume they are the result of the filtering?

Thanks