Skip to playerSkip to main content
  • 4 months ago
What does the camera do in Excel. Let me demonstrate. At the end of the video, you'll be able to answer the question on how do I use a camera in Excel chart and what is the camera tool used for?

Here the steps outline on the video.

Insert Camera Tool In Quick Access Toolbar
1) Customize quick access toolbar
2) All commands
3) Camera
4) Add
5) OK

Create Live Link Object
1) Go to the dataset you want to copy.
2) Select cells
3) Click on Camera icon
4) Go to the destination sheet
5) Click on the location you want to paste


What does the camera do in Excel?,How do I use the camera in Excel chart?,What is a camera tool?,

Transcript
00:00The XL camera tool is a feature that's used to create a live link and a snapshot
00:03of a selected range of cell or graphic object. Let me demonstrate. Let's say if
00:08you want to copy this as a live link, what you do is that first of all you're
00:11going to have to insert the camera tool on your toolbar here. Right click here,
00:15customize access toolbar. In here you're going to select all commands and then
00:21you're going to go and look for a tool called camera. You're going to add and
00:24this will add that to your quick tool here. Now the camera is available here.
00:29So what you do next is you select the cell that you want to make a snapshot of
00:32and then you go to your tool here and click on the camera. Now you got this
00:37snapshot here. Go to the destination sheet and then select any cell and now the
00:42object is copied over. Now if you make changes on your original sheet here to
00:46say 22, you can see that the changes propagate to your destination worksheet as
00:51well.
Comments

Recommended