Filter data and fill only filtered data
 

It is truly amazing what a terrible job microsoft did in putting together
Excel 2007. What a complete disaster.

Here is my problem:
I have filtered data that I want to flag as "Y" for example. If I put the
letter "Y" in an empty column and then drag it down it fills in "Y" in all
cells including those that do not appear because of the filter. How do you
filter data and then fill in only the cells that are filtered. This is just
one of many disasters with the new Excel.

Filter data and fill only filtered data
 

Hi

Include the column where you want to enter the "Y's" within your table,
before applying filtering.

--
Regards
Roger Govier



"Thad Meyers" wrote in message
...
It is truly amazing what a terrible job microsoft did in putting together
Excel 2007. What a complete disaster.

Here is my problem:
I have filtered data that I want to flag as "Y" for example. If I put the
letter "Y" in an empty column and then drag it down it fills in "Y" in all
cells including those that do not appear because of the filter. How do
you
filter data and then fill in only the cells that are filtered. This is
just
one of many disasters with the new Excel.