Lisa,

Use Edit / Go To... Special Visible Cells only OK then use Ctrl-Enter

Or add the Visible cells button to your commandbar.

HTH,
Bernie
MS Excel MVP


"Lisa954" wrote in message
...
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?