Snap a range
It’s possible to take a picture of a range in Excel to insert into Word as a picture or to place as 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.
You can now 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.
Use this technique to print data from two Excel sheets on the one sheet of paper, something that’s notoriously difficult to do otherwise – regardless of the fact that it’s a feature we’d all love to have!