If you are working with data models that are interlinked and spans across various worksheets, it becomes difficult to keep track of the changes that occur when you change a particular cell. You can also use Excel Camera tool to create micro charts, which is a resized version of any regular chart. When you are creating an Excel Dashboard, often, it becomes difficult to fit different charts and/or tables on a single page.Įxcel camera tool can be helpful here as you can easily take a picture of the chart or the data table and place it on the dashboard. 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.
#Excel 2016 quick access toolbar too wide update#
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.
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.
#Excel 2016 quick access toolbar too wide how to#
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.
0 kommentar(er)
