Thats strange, because when I filter then copy rows in Excel 2007, it only copies the selected rows, not the hidden values.<BR><BR>This is Office 2007 SP1, BTW.

To take a snapshot of a range not formatted as an Excel table using the Linked Picture tool, select the data, press Ctrl+C to copy it, and click "Linked Picture" in the Paste drop-down menu.

Q. What is the difference between a regular paste in Microsoft Excel and Paste Special? A. As an accountant, you know how to copy or cut and paste in Microsoft Excel. On PCs, it’s as simple as Ctrl+C ...

This article will teach you how to transfer data from one spreadsheet to another in Microsoft Excel if your copy and paste function is not working. This article will show you three methods of how to ...