Excel Guides

Setting a Transparent Color for an Image in Excel

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.

Setting the Transparency of the Image Itself

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.

Setting the Transparency of the Background Color

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.
Under Type(second), enter oneofthe following codes in thenumber format code text box.
For no fill type ;;; (three semicolons) and then press ENTER.
For white fill type ;;;white and then press ENTER.
For black fill type ;;;black and then press ENTER.
For gray fill type ;;;gray and then press ENTER.
For red fill type ;;;red and then press ENTER.
For green fill type ;;;green and then press ENTER.
For blue fill type ;;;blue and then press ENTER.
After youhaveentered oneofthe codes above in thenumber format code text box under Type(second), click OKtoapply itto your selectionand close dialog box.
Nowyouwillsee that your selectionhas a new background color with noshading or borders around it because we used three semicolons (;;;;). Ifyouwant to add shading or borders around your selectionwith this new background color, simply go backto themenu barand choose Format > Cells > Bordersor Format > Cells > Shadingas usual.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.