Filter data and fill only filtered data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi

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