Need a copy of part of an Excel worksheet? Too easy!
You can take a picture of a range in Excel and, for example, insert into Word as a picture or place it an image in another area on a workbook. To do this, first select the area to snap and hold Shift as you open the Edit menu. Choose Copy Picture, select As shown on screen or As shown when printed and click Ok.
Now go ahead and paste the image wherever you desire. This Shift + Edit menu option also works for copying a clip art or other type of image inserted into an Excel workbook.
ah yes, the good ole days of Functional UI Design, before Ribbonageddon.
dare say you know this, but this functionality is now buried 2 dropdowns under Paste!! Paste->As Picture->Copy as Picture. ummm… wat