Excel can take photos of itself, it’s a fun technique for applying a portion of a worksheet back into the worksheet as an image or into some other application.

To do this, make a selection around the area you’re interested in and hold Shift as you click to open the Edit menu. There’s a new option called Copy Picture which, if you click it, you can then select how to copy the picture – as shown on the screen or when printed etc.. Make your choice and then you can paste the image into any application.

To paste it back into an Excel workbook, Shift + click on the Edit menu and you can paste it back in by choosing Paste Picture.

You can do some funky things with this. Take a copy of a portion of a worksheet using this technique and then select a bar in a bar chart. Choose Edit, Paste and you’ll paste the image in as your new bar chart fill.

Helen Bradley