This tip courtesy of Richard Tallent (a regular reader, hopefully).
When you hold down the Shift key, the options under the Edit menu change. One hidden option is the Copy Picture menu item. To use it, select a range that you want to take a picture of. Hold down the Shift key and choose Copy Picture from the Edit menu. You’ll get a dialog that looks like this
Now a copy of your range, as a picture, is in the clipboard ready to paste. In this example, I copied a small range and pasted it as a picture a little lower and to the right.
Notice how it copies the gridlines too. If you don’t want gridlines, you can turn them off when you copy (Tools>Options>View) and turn them back on when you’re done.
Thanks, Richard, for a great tip. Keep ’em coming.