Using the Camera Function in Excel

This Tech Tip was submitted by Angela Henderson, Associate Vice Chancellor for Institutional Research, Planning, and Assessment, Keiser University

The camera tool allows you to take a snapshot of any selected range of data, table, or graph, and paste it as a linked picture in Excel. The pasted snapshot can be formatted and resized using picture tools and will update automatically with any changes made to the original data source. Linked data ranges can also be copied and pasted into Word and PowerPoint documents, though with less flexibility.

Enabling the camera function in Excel 2010:

  • From the File tab, select Options, and then select Quick Access Toolbar. 
  • In the Customize the Quick Access Toolbar screen, under Choose commands from, select Commands Not in the Ribbon and scroll down to find the camera option.
  • Select Camera from the list and click Add to move the camera icon to the Customize Quick Access Toolbar box and click OK.
  • The camera icon now appears in the Quick Access Toolbar at the top of the screen.

             

Enabling the camera function in Excel 2007: 

  • Click the Office icon in the upper left corner in Excel. 
  • Select the Excel Options button to activate the Excel Options dialog box.
  • Click the Customize button.
  • In the Choose Commands From drop-down list, select Commands Not in the Ribbon.
  • Scroll down the alphabetical list of commands and find Camera, and double-click to add it to Quick Access Toolbar.
  • Click OK to close the Excel Options dialog box. 

Using the Camera function: 

  • Select the data range for which you wish to take a snapshot and left-click the camera icon. This copies the selected range as an image.
  • To paste the image, left-click the area where you would like the snapshot placed.
  • To format the image, left-click on the pasted image and select the Picture Tools tab at the top of the screen.  From this menu you can apply picture styles, colors, borders, or effects to the snapshot image of the data.  

Alternately, you can right-click the image and select Format Picture to access most picture formatting options.

                       

Creating linked snapshots without using the camera icon:

  • Select the data range.
  • Copy the selected range.
  • Right-click on the desired paste location in Excel.
  • Select Paste Special from the menu.

       

  • Select the Linked Picture option from Other Paste Options.
  • To format, left-click on the pasted image and select the Picture Tools tab at the top of the screen. Alternately, you can right-click the image and select Format Picture to access most picture formatting options.

Linked ranges can also be pasted into Word and PowerPoint, however, there is less flexibility.

Pasting a linked Excel data range into Word:
  • In Excel, select the data range for which you wish to take a snapshot and left click the camera icon.
  • To paste the range, click on the desired location in the Word document.
  • Right-click and select the Link and Keep Source Formatting option from the Paste Options.

         

  • The range shown in the Word document is now linked to the original Excel document. 
  • If changes to the original range are made in Excel, the Word version can be updated by selecting the item, right-clicking, and selecting Update Link. 

       

Pasting a linked Excel data range into PowerPoint:

  • In Excel, select the data range for which you wish to take a snapshot and left-click the camera icon.
  • In the PowerPoint document menu, select the arrow below Paste and select Paste Special.

         

  • In the Paste Special window, select Paste Link as Microsoft Excel Worksheet Object.
  • Click OK. 
  • The range shown in the PowerPoint document is now linked to the original Excel document and will update automatically when changes are made to the original Excel document.   

        

 

 

 Comments

 
To add a comment, Sign In
Total Comments: 6
 
Marlene posted on 5/8/2013 10:16 AM
Never knew about the camera option in Excel before...very interesting!
Jessica posted on 5/8/2013 5:11 PM
Thank you for the informative tech tip!
Bruce posted on 5/8/2013 8:00 PM
One more feature to play with!!! Wonder if it works as well as the integrated Apple suite?
Kristina posted on 5/9/2013 1:44 PM
Thanks for providing easy step by step directions to a creative tip.
Gary posted on 5/9/2013 1:55 PM
This feature has been in my Excel bag of tricks for a long time, and it's very useful for certain types of reports - great tip!
Eric posted on 5/10/2013 12:14 PM
Thank you for sharing this, Angela! I used it today and it is an excellent time-saver!