Data entry on filtered rows.

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?
 
B

Bernie Deitrick

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
 
L

Lisa954

Thank you for your response. This is Excel 2007. There is no edit button on
the ribbon bar at the top.
 
A

Ashish Mathur

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Integrating information from Word to Excel (not mail merge) 1
Split form 0
Solution to tricky problem of showing exactly Top N rows in Pivottable 0
Cell data entering slow! 0
Alternate Row Shading with Filter 1
Adding a big matrix in Word 2013 5

Top