Q: I use the Snipping Tool quite a bit on my Windows 7 computer. A friend told me he uses the Camera in Excel which has more features. Can you explain how to use Excel’s camera feature?
A: Excel allows you to capture "pictures" of your worksheets that you can use in other worksheets. This may sound odd, but it is quite helpful at times. You capture pictures by using the Camera tool. This tool is not available on the various Excel ribbons, so you need to add it to the Quick Access toolbar as follows:
1. Launch Excel.
2. Right-click on the Quick Access toolbar in the upper left of the screen.
3. Choose “Customize Quick Access Toolbar.”
4. Choose “All Commands” from the “Choose commands from…” pull-down.
5. Scroll to find Camera in the left pane of commands, select it, then click the Add button located between the two panes.
6. Click OK.
With the Camera tool in place on the Quick Access toolbar, follow these steps:
1. Select the cells you want to capture as a photo.
2. Click on the Camera tool (the one added to the Quick Access toolbar). The selected cells will be framed in “marching ants.”
3. Click in the cell where you want the top left-hand corner of the picture to appear. This can be on a different sheet or the same sheet of Excel. The picture is then inserted as a graphic.
Now you can manipulate the picture the same as you would any other graphic — stretch it, resize it, crop it, move it, or whatever. The really amazing thing, however, is that the picture is dynamic. This means that if you change the information in the original range (that you selected in Step 1), the information in the picture will change as well.