Greetings again. I'm using VISTA and Excel 2007.

When I'm using "Filter by Selected Cell's Value," the rows containing this
value appear, of course, top to bottom. If I enter something in a blank cell
at the top I can copy the contents of this cell down to the bottom of the
filtered list, of course.

Is it possible to type in something the top cell and then with a mouse click
or whatever, fill in all the empty cells down to the bottom of the list
automatically (without dragging the mouse)? This works fine when I'm not
using a filter, but I can't seem to get it to work after filtering by the
cell's value. Obviously I am doing something wrong. Could you please tell me
how to do this? Thanks.