How to Make Picture Background Transparent in Excel (2 Methods)

Get FREE Advanced Excel Exercises with Solutions!

To make an Excel worksheet dynamic, beautiful, and informative, it is sometimes necessary to insert a picture and make its background transparent. If you are looking for special tricks to make the picture background transparent in Excel, you’ve come to the right place. There are two ways to make the picture background transparent in Excel. This article will discuss every step of these methods to make the picture background transparent in Excel. Let’s follow the complete guide to learn all of this.


How to Make Picture Background Transparent in Excel: 2 Easy Methods

In the following section, we will use two effective and tricky methods to make the picture background transparent in Excel. Using the context menu is the first method, and using picture transparency is the other method. In every method, first of all, we will insert a picture, then we will make the picture background transparent. To insert a picture, we can follow three methods such as using the Insert tab, using a drop-down list, and using shape fill. In this article, we demonstrate shapefill to insert a picture in Excel. This section provides extensive details on these methods. You should learn and apply these to improve your thinking capability and Excel knowledge. We use the Microsoft Office 365 version here, but you can utilize any other version according to your preference.


1. Using Context Menu

Here, we will demonstrate how to make a picture background transparent in Excel. Firstly, we will insert a picture in Excel. To accomplish this, we will use the Shape Fill which is a cool way to insert pictures in the cell. In this way, we can easily insert pictures and won’t have to adjust them manually to fit the cell size. Alternatively, you can insert pictures in Excel by using the Insert tab or drop-down menu. Then, we will use the shape format option to make the picture background transparent. Let’s walk through the steps to make a picture background transparent.

Using Context Menu

📌 Steps:

  • First of all, we have to insert a picture in Excel. To do this, go to the Insert tab and select Shapes from the Illustrations option.
  • Then, select Rectangle.

How to Make Picture Background Transparent in Excel

  • Therefore, we will be able to draw the shape in Excel as shown below.

  • Afterward, right-click on the shape.
  • Then, click on Format Shape.

How to Make Picture Background Transparent in Excel

  • Therefore, the Format Picture dialogue box will appear.
  • Next, select Fill & Line option, and click on Picture or texture fill.

  • To insert a picture you have to click on the Insert from Picture source option.

How to Make Picture Background Transparent in Excel

  • At this point, a dialogue box will pop up, you can choose pictures from your saved file or from online by these options. We have pictures on our computer so click on From a File.

  • Now, select the picture in the File name box and click on Insert.

How to Make Picture Background Transparent in Excel

  • You can see, that the image is automatically adjusted to the cell sizes as shown below.

  • The picture must now be placed over the dataset as shown below. Now, we are going to transparent the picture background.

How to Make Picture Background Transparent in Excel

  • To make transparent the picture background, select Transparency, and set the transparency to 80%. Depending on your picture type, you may want to increase or decrease this value.

  • As a consequence, you will be able to make the picture background transparent.

How to Make Picture Background Transparent in Excel

This is how you will be able to make the picture background transparent quickly by using the context menu. In the method, we will discuss another effective to do the same task by using the picture transparency option.

Read More: How to Make Excel Spreadsheet Colorful


2. Utilizing Picture Transparency Option

Now, we will demonstrate how to make a picture background transparent using the picture transparency option. Let’s begin by inserting a picture into Excel. This can be accomplished by inserting pictures in the cell using Shape Fill. Thus, pictures can be easily inserted without having to be adjusted manually. Depending on your preference, you can also insert pictures in Excel using the Insert tab or drop-down list. Then, we will use the picture transparency option to make the picture transparent. Let’s walk through the steps to make a picture background transparent.

Using Picture Transparency Option

📌 Steps:

  • First of all, we have to insert a picture in Excel. To do this, go to the Insert tab and select Shapes from the Illustrations option.
  • Then, select Rectangle.

How to Make Picture Background Transparent in Excel

  • Therefore, we will be able to draw the shape in Excel as shown below.

  • Afterward, right-click on the shape.
  • Then, click on Format Shape.

How to Make Picture Background Transparent in Excel

  • Therefore, the Format Picture dialogue box will appear.
  • Next, select the Fill & Line option, and click on Picture or texture fill.

  • Now, to insert a picture you have to click on the Insert from Picture source option.

How to Make Picture Background Transparent in Excel

  • At this point, a dialogue box will pop up, you can choose pictures from your saved file or from online by these options. We have pictures on our computer so click on From a File.

  • Now, select the picture in the File name box and click on Insert.

How to Make Picture Background Transparent in Excel

  • You can see, that the image is automatically adjusted to the cell sizes as shown below.

  • The picture must now be placed over the dataset as shown below. Now, we are going to transparent the picture background.

How to Make Picture Background Transparent in Excel

  • Next, to make transparent the picture background, go to the Picture Format tab, select Transparency, and from the drop-down menu, select your desired format. Depending on your picture type, you may change your format.

  • As a consequence, you will be able to make the picture background transparent.

How to Make Picture Background Transparent in Excel


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article. It contains all the datasets in different spreadsheets for a clear understanding. Try yourself while you go through the step-by-step process.


Conclusion

That’s the end of today’s session. I strongly believe that from now you may be able to make the picture background transparent in Excel. If you have any queries or recommendations, please share them in the comments section below.


Related Articles


<< Go Back to Excel Background | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Saquib Ahmad Shuvo
Saquib Ahmad Shuvo

Saquib Ahmad Bhuiyan, holding a BSc degree in Naval Architecture & Marine Engineering from Bangladesh University of Engineering and Technology, skillfully integrates engineering expertise with a passion for Excel. He provides solutions to complex issues as an Excel & VBA Content Developer for ExcelDemy Forum. He demonstrates an enthusiastic mindset and adeptness in managing critical situations with finesse, showcasing his commitment to excellence. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel, Rhinoceros,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo