Excel 2007: I have a huge spreadsheet, and I want to be able to update the
filtered rows with information by typing in the top line and copying down.

When I do this, the entered information is entered on all rows including the
hidden rows. How can I just enter on the filtered rows only?