I’ve been using Excel for (literally) decades and I never knew about this one – kind of understandable since it’s not where you’d immediately think to look.
The scenario I’ve found myself in recently is to be able to copy portions of an Excel worksheet into our intranet as an image – typically where the range is too big to screen capture.
Some applications allow you to Paste Special the copied cells as an image but with our intranet and other applications that’s not always possible.
So to Copy you selection into the clipboard as an image go to the Paste menu (of course!), select As Picture –> Copy as Picture...