Converting table into image

Switching the Excel spreadsheet to another application like, for example, PowerPoint can be an inconvenient job. If it hates you to deal with details, there is a very simple way to do this, that is to convert the final table into an image, and then copy the image to the desired destination. This can be done using the Paste Special option, as well as using the Camera tool, and the following text will explain how to make the most of this option.

Converting a table into an image can be done in two ways. The first way would be to select the completed table and start the copying process using the CTRL + C shortcut. And then, from the Home ribbon, open the Paste Special menu and select the option to paste the table as an image. We can paste the table-image in two ways. The first is that it is a static-fixed image (Picture). The other is that the image is dynamic, that is, it is connected to a particular area (Picture Link). Adding data to the field, e.g. the new row in the table, the image is automatically updated and updated with a new line.

If we often practice converting Camera tool. Before we begin to use it, we need to add it first, which will be easiest to do if we insert it as an optional option in the Quick Access Toolbar. This is most likely to happen if we right-click on the File menu, and then select the Customize Quick Access Toolbar option (this is the Excel shortcut that was discovered by my more beautiful half). When the dialog box opens with the options, you must first select the All Commands command in the combo list Choose commands, and then find the Camera tool in the list below. By clicking the Add button, we add the selected tool to the Quick Access Toolbar.

 How do we use the camera? It’s enough to select a finished data table, click on the icon marked with a camera, and then click on the position in the table where we want to generate the image. Using the camera, we create the slightly described link to the picture (Picture Link). By clicking on the generated image, we will see in the Formula Bar the address of the scope for which the image is linked. If we update the table, adding a new row, so in the Formula Bar we change the scope, we will automatically update the image. This option works exclusively with defined bands – it does not support named ranges, or strutted tables, as the source on which the image is generated.