Fill in rows with Information from Drop Down list
 

Win. XP, Excel 2003. I have a worksheet that has several thousand rows. I
have filters set on two columns (one for attorneys, the other for practice
groups). I need to choose the practice group for each matter that an
attorney has worked on. For example, Atty A has worked on 20 matters. I
want to choose Practice1 for all 20 matters. I know I can pick the practice
once, use the drag to fill in the rest of the column, but when working on
several hundred at a time, this can become tiresome.

Does anyone know of a quicker way to fill in the practice for multiple rows
at once? Hope this makes sense.