In earlier versions of Excel, pasting copying AutoFiltered cells into another
workbook/worksheet results only in the displayed cells pasted.

However, performing the same commands results in the entire cells copied to
the new workbook/sheet.

How can this be done in Excel2007?