Setting a transparent color for an image in Excel can be done in a few different ways. One way is to set the transparency of the image itself. Another way is to set the transparency of the background color. And lastly, you can set the transparency of the entire sheet.
To set the transparency of the image itself, first select the image. Then, go to the Format tab on the ribbon. In the Adjust group, click on the Color drop-down arrow and select Set Transparent Color. The cursor will turn into a crosshair. Simply click on the part of the image that you want to be transparent.
Once you have clicked on the desired area, it will become transparent.
To set the transparency of the background color, first select the cells that contain your image. Then, go to the Format tab on the ribbon. In the Cells group, click on Format. A drop-down menu will appear. Select Format Cells. This will open up the Format Cells dialog box.
Format CellsNumber (first) tab, in thenumber category list, click Custom .This opens upthe Type (second) tab.