How to Make a Picture Transparent in Excel 2019
Question details
The user needs to adjust the transparency of an image inserted into an Excel 2019 spreadsheet, but the standard 'Make Picture Transparent' tool is unavailable or hard to locate.

- Product
- Microsoft Excel 2019
- Device & OS
- not provided
- Scenario
- Editing inserted images to reduce their opacity so that spreadsheet data or gridlines can remain visible underneath.
- Observed behavior
- The direct picture transparency slider found in newer Microsoft 365 releases is missing in Excel 2019, causing confusion on how to achieve the desired image effect.
Confirm your exact version of Microsoft Office, as the direct picture transparency slider was introduced in Microsoft 365 and Office 2021. For Excel 2019 and 2016, you will need to use alternative built-in methods to achieve the same result.
Use the Shape Fill Workaround to Adjust Image Transparency
Since Excel 2019 lacks a direct image transparency slider, you can insert your picture as a background fill for a shape, which allows you to adjust the transparency freely.
This is the most reliable method for adjusting the overall opacity of a photograph or complex image in Excel 2019.
Go to the 'Insert' tab on the Excel ribbon, click on 'Illustrations', then 'Shapes', and select the Rectangle shape. Draw the rectangle on your sheet.
Right-click the newly drawn rectangle and select 'Format Shape' from the context menu to open the right-hand formatting pane.
In the Format Shape pane, expand the 'Fill' section and select 'Picture or texture fill'. Click the 'Insert' button to locate and add your desired image from your computer.
Once the image fills the shape, look directly below the fill options in the same pane. Drag the 'Transparency' slider to your desired percentage to make the picture transparent.
To make it look like a standard image, expand the 'Line' section in the Format Shape pane and select 'No line' to remove the shape's border.

Use the Set Transparent Color Tool for Solid Backgrounds
If you only need to remove a solid color background (like a white background from a logo) rather than making the entire image transparent, you can use this specific color tool.
Use WPS Office to Seamlessly Edit Pictures in Spreadsheets
If you find workarounds in older Excel versions tedious, WPS Office provides straightforward image editing tools built right into its Spreadsheet application. It is free, fast, and fully compatible with your existing Microsoft Excel files.
- 1. Open Your Spreadsheet in WPS: Download and launch WPS Office, then open your existing Excel workbook or create a new one.
- 2. Insert Your Image: Go to the 'Insert' tab and click 'Picture' to place your image onto the spreadsheet.
- 3. Access Picture Tools: Click the inserted image to reveal the 'Picture Tools' tab, then click on 'Picture Properties' to open the editing pane.
- 4. Slide to Adjust Transparency: In the properties pane, locate the transparency slider and drag it to instantly make your picture transparent without needing any shape-fill workarounds.

Frequently Asked Questions
Why is the Make Picture Transparent tool missing in my Excel?
Microsoft introduced the dedicated Picture Transparency slider in Microsoft 365 subscriptions and Office 2021. If you are using Excel 2019, 2016, or older, this feature is not natively available for standalone images, and you must use the Shape Fill workaround instead.
Can I make the white background of a JPEG transparent in Excel 2019?
Yes. Select your image, go to the Picture Format tab, click Color, and select 'Set Transparent Color'. Then, click on the white background of your image to make it transparent. Note that this works best on solid colors.
Will my image transparency be saved if I send the Excel file to someone else?
Yes. Whether you use the shape fill workaround or the Set Transparent Color tool, saving your file in the standard .xlsx format preserves these visual formatting settings for anyone who opens the file.




