The command in Excel 2007 to do this is oddly located on the Paste menu in the Ribbon.
Now you will get a dialog asking you how you want to copy the picture.
Copy a Group of Cells in Excel 2007 to the Clipboard as an Image
If you want to share a small part of your Excel worksheet but don't want to send an Excel file, you can copy part of the worksheet to the clipboard as a picture instead.
