How to use Camera tool in Excel

Excel 2016
When you work with some Excel elements such as tables, charts, you spend a lot of time positioning them and formatting them. Here will find the feature that Excel proposes to help you create a perfect presentation of your data.

The Camera tool isn't included in the standard ribbons of Excel for Microsoft 365, but you can add it:

To create a new picture from your table or chart, do the following:

   1.   Select data that you want to show in the screenshot.

For example:

Selected data for Camera in Excel 365

   2.   Click on the Camera button.

   3.   Select the area where you want to paste the screenshot.

   4.   Position the screenshot where you want:

Camera for selected data in Excel 365

You can change the screenshot parameters and positioning it when you prefer. When you change something in the source table, it will be changed in the screenshot too:

Camera for selected formatted data in Excel 365

Note: We strongly recommend to avoid using the Camera Tool for charts. Sure, it works, but Excel still generate errors when we try to change anything in the source chart.

To create a screenshot from the chart, you need to position it in some cells and create a screenshot from cells. You can change width of gridlines or even turn off gridlines in Excel.

For example:

- The selected cells:

Selected chart for Camera in Excel 365

- The screenshot:

Camera for chart Excel 365

Be careful, if you change the position of that chart, the screenshot will be changed regarding to the cells data, not to the chart!

Camera for changed chart Excel 365

See also this tip in French: Comment utiliser l'outil Appareil photo dans Excel.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more