Remove Picture Background


November 13, 2023 - by

Remove Picture Background

New in Excel 2010, you can easily remove the background from a picture. I can imagine this will lead to a variety of Excel cover sheets with decorative pictures with the backgrounds removed.

Select the picture and choose Remove Background. A new ribbon tab will appear. Your first adjustment is to change the bounding box so it tightly fits around the subject. Making this one adjustment will dramatically improve the results of Background Removal.


Below are two copies of the same picture. The picture on the left is the original. The picture on the right is the picture after clicking Remove Background and tightly adjusting the bounding box to the subject.

The original photo has a hooded photo of a boy in the woods. Remove background keeps just the hooded boy.
Figure 1420. Change the bounding box around the subject.

Given the correct bounding box, the Picture Removal tool does a good job of predicting what to remove. The Background Removal tab of the ribbon includes icons where you can mark areas to keep or remove. This is good for areas that the tool chose to erroneously remove.



When you click the Keep Changes icon, the background will be removed.

Gotcha: If you want to enter values in the cells covered by the now-transparent background, you will usually select the picture instead of the cell. Click outside of the picture and then use the arrow keys to move to the cells under the picture. It is incredibly tempting to just try to click directly on the cell instead.

With the background transparent, you can place the photo above numbers in the gris and only the hooded boy obscures the numbers.
Figure 1421. After the removal.

This article is an excerpt from Power Excel With MrExcel

Title photo by Marc Schulte on Unsplash