Office Compatibility Issues

How to Make a Picture Transparent in Excel 2019

Phi Hung VoPhi Hung Vo Nov 2, 2026 869 views

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.

How to Make a Picture Transparent in Excel 2019
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.
Before you start

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.

Solution 1Recommended

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.

1
Insert a Shape

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.

2
Format the Shape

Right-click the newly drawn rectangle and select 'Format Shape' from the context menu to open the right-hand formatting pane.

3
Fill with Picture

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.

4
Adjust Transparency

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.

5
Remove Shape Outline

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 Shape Fill Workaround to Adjust Image Transparency
Pro Tip: You can resize or crop the shape at any time, and the image transparency will remain intact.
Easily Adjust Image Transparency

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. 1. Open Your Spreadsheet in WPS: Download and launch WPS Office, then open your existing Excel workbook or create a new one.
  2. 2. Insert Your Image: Go to the 'Insert' tab and click 'Picture' to place your image onto the spreadsheet.
  3. 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. 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.
Direct picture properties menu for fast and simple transparency adjustmentsFull compatibility with Microsoft Excel (.xlsx, .xls) files and formatsFree, lightweight suite that runs smoothly on Windows, Mac, and mobile
microsoft office alternative - wps office

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.