Using the Excel Camera Tool in Office 2011 for Mac - dummies

Using the Excel Camera Tool in Office 2011 for Mac

By Geetesh Bajaj, James Gordon

The Camera tool in Excel 2011 for Mac creates a “picture” of a range of cells. “Picture” is in quotation marks because these pictures aren’t static; they’re dynamic — they change. Pictures are linked to the range you select, and they update when the range changes.

You can use Excel’s Camera command in a variety of ways:

  • Display the calculation results of numbers or charts when the calculations and charts are on hidden worksheets (but not hidden rows or columns), other worksheets, or cell ranges that are off-screen. You can keep your formulas out of sight so unwanted visitors are less likely to tamper with them. Because the result is a linked picture, updated results are displayed automatically.

  • Precisely size and position the picture of the cell range. The Camera command creates an object that you can size and format like a picture. You can position the Camera picture anywhere on a worksheet.

  • Position live snapshots of various ranges from distant places in a workbook. You can make them fit close together on a worksheet.

Customizing to get the Camera tool in Excel 2011 for Mac

Before you can use this magical tool, you have to turn it on.

  1. Choose View→Toolbars→Customize Menus and Toolbars.

  2. Click the Commands tab.

  3. Drag the Camera command to any toolbar (or menu) and click OK.

Using the Camera tool in Excel 2011 for Mac

To use the Camera tool, take these steps:

  1. Drag over a range of cells and then release the mouse button.

    Everything within the selection range becomes part of a Camera picture. Objects (such as graphs or PivotTables) completely within the selection area are included in the resulting Camera picture.

  2. Click the Camera button on the toolbar (or select Camera from the menu if you put the command on a menu).

    The cursor changes to a plus sign (+).

  3. Move the mouse cursor to a new location and then drag the mouse to create a Camera picture.

    The new location can be on the same worksheet, on another worksheet in the same workbook, or a worksheet in another open workbook (which creates a link).

    When using the Camera option, the camera’s linked picture location shouldn’t overlap the original selection range.