See all How-To Articles

How to Make a Shape or Picture Transparent in Excel

This tutorial shows how to make a shape or picture transparent in Excel.

 

make a shape or picture transparent initial 1 new

 

Make a Shape Transparent

In Excel, you can make a shape transparent using the Format Shape options.

  1. Select the shape you want to make transparent. Then, right-click it and choose Format Shape.

 

make a shape or picture transparent 1 new1

 

  1. On the right side of the screen, you get the Format Shape menu. Here, set the Transparency to a certain percentage (70%).

 

make a shape or picture transparent 2 new

 

The shape is now more transparent.

Make a Picture Transparent

You can also make a picture transparent using Format Shape.

 

make a shape or picture transparent 3

 

  1. Select a picture, right-click it, and from the drop-down list, choose Format Picture.

 

make a shape or picture transparent 4 new

 

  1. The Format Picture menu appears on the right side of the screen. Click on Picture, then set Transparency to the value you want (70%).

 

make a shape or picture transparent 5 new

 

Picture Transparency Options

There’s another way to make pictures transparent and allows for side-by-side previews of the level of transparency.

Select the picture you want to make transparent. Then in the Ribbon, go to Picture Format > Transparency, and choose transparency from the previewed options.

 

make a shape or picture transparent 6 new