Filter data and fill only filtered data

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

Roger Govier

Hi

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SumProduct and Sum only Filtered data 3
Filling in another sheet with filtered data 3
Filtered drop down list 2
Using the Autofill, with filtered lists 1
Filter and selection question 1
Filter 1
Link to filtered Data - AUTO 2
Hold conditional formatting when sorting filtered data 1

Top