Using the
Excel 2007 Camera Tool
The Excel 2007 Camera tool lets you
take a picture of a range of
cells
on a worksheet. Before you can use this tool you must first add it to the
Quick
Access
Toolbar
on the Ribbon.
To add the Camera tool to the Quick
Access Toolbar:
 |
Click the Office button
in the upper-left corner of
the Ribbon |
|
|
Click the Excel Options button
|
|
|
Click Customize
|
|
|
In the Choose Commands From
drop-down list, select Commands Not in the Ribbon |
|
|
Select Camera and double-click
to add it to the Quick Access Toolbar |
|
|
Click OK to close the Excel
Options
dialog box |
To use this tool:
|
|
Select a range on your worksheet |
|
|
Click the Camera tool on the Ribbon |
|
|
Click where you want the picture to appear (In
this workbook or even in another workbook) |
A graphic is created of the range you selected.
If you change the original data the picture also changes. You can even
copy or move this picture to the clipboard and paste it into Word or
PowerPoint if you need to. However, if you copy it into another program it
will no longer update when the original is changed.
|
