Data entry on filtered rows.

  • Thread starter Thread starter Lisa954
  • Start date Start date
L

Lisa954

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?
 
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
 
Thank you for your response. This is Excel 2007. There is no edit button on
the ribbon bar at the top.
 
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
 
Back
Top