MAKING EXCEL WORK FOR YOU
piscing elit. Cras gravida sem ut massa. Quisque accumsan porttitor dui. Sed interdum, nisl ut
Excel's Camera tool enables you to select a range of cells and make a live picture that you can place anywhere in your workbook. Since it makes a picture, it does not have to fit into worksheet row/columns, a great help in building dashboard type reports. Since it's a live picture, any changes to the source range are automatically updated in the picture. The Camera tool can significantly increase your Excel dashboard quality quickly and easily.
Adding the tool to your Excel
The Camera Tool button does not show up on any default toolbars, so you'll need to add it yourself. It only takes a few steps, and it is well worth it, so let's add it now
The Quick Access Toolbar is a customisable toolbar in which you can store frequently used commands so that they're always accessible with just one click. You can add commands to the QAT by dragging them directly from the Ribbon or by going through the Customise menu.
Follow these steps to add the Camera tool to the QAT:
Users of Excel 2010 will need to ignore the Button as it is no longer used. Instead press the the File Tab and choose Options then follow the steps for Excel 2007
Using the Camera Tool
Since your picture is live, any changes (data, format, formulas) in source cells will immediately appear in your picture. Also because your copy is a picture, you can move it anywhere you want, it floats over the rows/columns. This let's you be creative, mix and match charts and data pictures more freely than you ever could with just rows and columns.
© Roy Cox 2005 to 2013
Excel’s little known Camera Tool
|The Personal WorkBook|
|Excel Sheets in VBA|
|Excel Macro Recorder|
|Excel Camera Tool|
|Excel Summarise Data|
|Excel CHOOSE Function|