Here are a couple of examples where it will make your work easier. When to Use the Excel Camera Tool – Some ExamplesĮxcel Camera Tool comes in handy in many situations. You can have it anywhere in the workbook and it would still work. When you make a change in the data set, it is visible in the image in real time.Īlso, you need not have the data and image in the same worksheet. Change something in the range of cells and the image would automatically update itself. Now you would have an image of the range of cells that you selected. Go to the worksheet and click anywhere.Click on the Excel Camera Tool icon in the Quick Access Toolbar.Select the cell or range of cells for which you want an image.Using the Excel Camera tool is a 3-step process (just like LIGHTS.CAMERA. The real skill is in using it efficiently.

Getting the Camera Tool in the QAT is only half the battle won. So you have the access to the camera tool. Click OK, and it will add the Camera tool icon in the Quick Access Toolbar.With the Camera Option selected, click on the Add button.Scroll down the list below the drop down and select Camera Tool Option (HINT: The icon looks like a camera).In the Choose Commands from the drop-down, select All Commands.It will open the Excel Options dialogue box. Right click on any of the tabs and select Customize Quick Access Toolbar.Here are the steps that will add the Excel Camera Tool t0 the Quick Access Toolbar: You need to take a few steps to dig down into excel features and pull it out. To begin with, Excel Camera Tool is not even available by default in Excel QAT or Ribbon. It’s just another feature with a cool name. Watch Video – Excel Camera Tool and How to Use it!įor all those who think working with Excel is boring, here is your answer to them – Excel Camera Tool.

Tools menu in excel 2016 mac