How to Create a Table in Excel 2007
Applying a Table Style to an Excel 2007 Table
Comparing Two Excel 2007 Worksheets Side by Side

Adding the Excel Camera Tool to the Quick Access Toolbar

The Excel Camera tool enables you to take a live picture of a range of cells that updates dynamically while the data in that range updates. Although Microsoft doesn't include the Excel Camera tool in the mainstream Ribbon, it's quite useful when you want to build Excel dashboards and reports. Before you can use the Camera tool, you need to add it to your Quick Access Toolbar (QAT).

The Quick Access Toolbar is a customizable 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 Customize menu.

Follow these steps to add the Camera tool to the QAT:

1. Click the Office icon in the upper-left corner of Excel.

2. Select the Excel Options button to activate the Excel Options dialog box.

3. Click the Customize button.

4. In the Choose Commands From drop-down list, select Commands Not in the Ribbon.

5. Scroll down the alphabetical list of commands and find Camera; double-click to add it to QAT.

6. Click OK to close the Excel Options dialog box.

When you've taken these steps, you'll see the Camera tool icon in your Quick Access Toolbar. Not surprisingly, the icon for the Camera tool looks like a camera.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Creating Custom AutoFilters for Numbers in Excel 2007
Editing Records in an Excel 2007 Table
Annotating with Text Boxes in Excel 2007
Automatically Fix Typos and Add Text with Excel 2007's AutoCorrect Feature
How to Use Excel 2007’s Research Task Pane