If in Excel 2007 you copy a range to the clipboard and paste into Word as a picture you get the worksheet gridlines displayed, which may well not be what you want.
This issue was raised at Smurf on Spreadsheets and has a fairly simple solution.
In their efforts to make all the Excel functionality intuitive and easy to access, Microsoft have placed a “Copy as Picture” command three levels down under the “Paste” button on the Home Tab. The “Copy as Picture” command brings up a dialog box, which has the options “as shown on screen” and “as shown whan printed”, and an image copied as “as shown when printed” does not have the grid-lines.
If you want to save the image as a separate file the easiest way to get a high quality emf (extended meta-file) image, without loss of image quality, seems to be to paste it into Powerpoint, and save it to a file from there.
Does anyone know a better way?
24th Oct 09: See comments below for a link to a “Classic Menu” addin, available for trial or purchase.