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

paste data over hidden cells that are filtered 1
Referncing Rows of Filtered Data 8
Copy/paste data across filtered rows 1
Drag and fill on a filtered data sheet. 6
Copying Filtered Data in Excel 2007 5
Excel 2007 overwriting Hidden Rows 1
Problem with Pasting into Filtered Fields 2
Delete only Filetered rows in excel 2007 not hidden rows or header 0

Top