Deleting or modifying rows that are above and below a hidden row in a filtered
Excel 2007 worksheet also deletes or modifies the hidden row
http://support.microsoft.com/kb/928974/en-us

But if you want to be careful, you should be able to select your range, then hit
F5 and select visible cells only.

Watch what happens to the selection.

You should be able to see the difference by the marquee (dancing ants)
surrounding the selected areas.

duketter wrote:

Excel 2007 - This was working in a different spreadsheet, however in this new
spreadsheet I am performing a filter using the autofilter function. Then I
only want to copy and paste what was filtered into a new worksheet in the
workbook. However when I copy and paste it pastes every row, even if it
wasn't filtered. I only want to paste the filtered rows. Any ideas?

Thanks!

--

Dave Peterson