This Tech Tip was submitted by, 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.
Jul 27, 2017 - This topic itemizes all keyboard shortcuts for Excel 2016 for Mac. The settings in some versions of the Mac operating system (OS) and some utility. Copy the image of the screen and save it to a Screen. Open and edit a cell comment.
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:.
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.
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:.