View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
 
Posts: 1,766
Default Data entry on filtered rows.

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?