Microsoft Office Tutorials and References
In Depth Information
Using Excel’s Camera Tool
Take a moment to walk through this basic demonstration of the Camera tool.
1. Highlight the range that contains the information you want to capture.
In this scenario, B3:F13 is selected to capture the area with the chart.
2. Select the Camera tool icon in the Quick Access toolbar.
You added the Camera tool to the Quick Access toolbar in the preceding section.
3. Click the worksheet in the location where you want to place the picture.
Excel immediately creates a live picture of the entire range, as shown in Figure 4-38.
Figure 4-38: A live picture is created via the Camera tool.
Changing any number in the original range automatically causes the picture to update.
By default, the picture that’s created has a border around it. To remove the border,
right-click the picture and select Format Picture. This opens the Format Picture dialog
box. On the Colors and Lines tab, you see a Line Color drop-down menu. Here you can
select No Color, thereby removing the border. On a similar note, to get a picture without
gridlines, simply remove the gridlines from the source range.
Creating a live picture without the Camera tool
Did you know you can create a live picture without actually using the Camera tool? That’s right.
Excel 2013 made it relatively easy to manually mimic the Camera tool’s functionality.
1. Select the target range and copy it.
2. On the Ribbon, click the Home tab and then click the drop-down control under the Paste
3. In the Other Paste Options group, select the Linked Picture icon.
Of course, the advantage of using the Camera tool is that you can do the same thing with two clicks.