How to use filter in Excel 2010 to fill in empty fields (cells)

Hi,
I have a big worksheet in Excel 2010 with many lines (more than 2000) and different fields but I forgot to place some of the cells when I first entered them.
Now, when I use the filter function to try to correct and fill in the empty fields Excel won’t lt me do that adequately.
Does anyone know how to do that?
For instance, I need to fill in the field called DATE (column C), but there are lots of other lines, so I use the filter to choose only the lines with the word “Faxineira” in column B.
A good solution would be to copy column A to column C, but that doesn’t work when I am in the filter mode.
PROBLEM-WITH-FILTERS.png
BrejinskiAsked:
Who is Participating?
 
Rory ArchibaldConnect With a Mentor Commented:
Filter column B as needed. Select column C. Press Alt+; to select only the visible cells, then type = and select the cell in column A of the active row and press Ctrl+Enter instead of just enter.
0
 
Rgonzo1971Commented:
Hi,

If you want all cells which are empty in Col C Click the Arrow in Col C / Text Filters / Equals then Click OK not entering anything

Regards
0
 
BrejinskiAuthor Commented:
Thanks, Rgonzo1971, but I need to filter column B and then fill in column C with the same dates in column A...
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
Rgonzo1971Commented:
Hi

You could use a helper's column with this formula and then paste the resulting column with Paste Values (not normal Paste)

=IF(C1<>"";C1;A1)

Open in new window

Regards
0
 
BrejinskiAuthor Commented:
Hi, rorya, amazing, incredible, unbelievable, fantastic, awesome solution you got there!!! How did you learn all that?
0
 
BrejinskiAuthor Commented:
Thank you all, guys, but rorya did give the best of the best answer.
0
 
Rory ArchibaldCommented:
Misspent youth. :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.