Hi,
I do not face this problem. I filtered a range with A in the column and
then typed Z in the first cell. Now when I copied and pasted, the values
were pasted on the A's only.
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"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?