Microsoft Excel中带有背景的图像可能会让人分心，因此，一劳永逸地删除它是非常有意义的。现在，由于Excel在许多人眼中都是关于数字和计算的，因此许多用户认为基本的图像处理是不可能的。

Excel中如何去除图片背景

但事实并非如此，我们将证明这一点。您会看到，使用Microsoft Excel^{(Microsoft Excel)}完全可以删除任何照片中的背景，如果您问我们，这非常令人印象深刻。

删除背景非常容易，比使用独立的图像编辑器更容易。至少，我们是这么看的。

1 ] 在Microsoft Excel中^{(Microsoft Excel)}插入^{(] Insert)}图片

好的^(Okay)，所以您需要做的第一件事是启动Excel，然后打开一个当前或新文档。从那里，单击“Insert > Illustrations，然后选择“图片”^(Picture)并选择如何将图像添加到文档中。

2]功能区^(Ribbon)上没有图片？

因为这是我们正在谈论的 Microsoft Excel ，所以添加图像的能力不是必需的。^(Excel)因此，您可能会发现功能区上的^(Ribbon)图片^(Picture)选项不可用，但不必担心。

如果是这种情况，请单击File > OptionsExcel中将出现一个新窗口。

单击自定义功能区^{(Customize Ribbon)}。从最右侧单击下拉菜单，如果尚未选择主选项卡，请选择主选项卡。^{(Main Tabs)}

在 Main Tab 部分下方，从选项列表中选择Insert，然后转到左侧并单击Choose commands from下的下拉菜单。从那里，选择Popular Commands，然后选择Insert Picture。

最后，点击Add，插入图片^{(Insert Picture)}功能将立即落入Insert Tab之下。单击“确定^(OK)”按钮完成任务。^(Complete)

您现在可以按照上面的第一步将图片添加到Excel 。

3]从图像中删除背景

将图像添加到Microsoft Excel后，您应该会在左上角看到一个选项，内容为Remove Background。单击^(Click)该按钮，图像上的背景现在应该是紫色的。

最后，单击“保留更改^{(Keep Changes)}”以删除背景并保留前景。

4]标记要保留或删除的区域

根据我们的经验，Excel非常擅长检测许多照片中的背景，因此在大多数情况下，去除背景的任务是自动完成的。但是，如果该工具没有完全检测到背景，那么我们建议使用标记区域^{(Mark Areas)}工具来完成工作。

如果照片上有您想要保留的部分，请选择标记要保留的区域^{(Mark Areas to Keep)}。如果有需要删除的部分，请单击Mark Areas to Remove。

手动突出显示这些区域，然后点击Keep Changes按钮完成操作。

提示^(TIP)：您还可以使用 Word 删除图片的背景^{(You can also remove the Background of a Picture with Word)}。

How to remove picture background in Excel

An image with a background in Microsoft Excel can cause distractions, and as such, it would make perfect sense to remove it once and for all. Now, since Excel is all about numbers and calculations in the eyes of many, a lot of users believe basic image manipulation is not possible.

How to remove picture background in Excel

But that is not the case at all, and we are going to prove it. You see, it is entirely possible to remove a background in any photo by using Microsoft Excel, which is quite impressive if you ask us.

Removing the background is super easy, more so than when a standalone image editor is used. At least, that is how we view it.

1] Insert a picture in Microsoft Excel

Okay, so the first thing you will need to do is fire up Excel and then open a current or new document. From there, click on Insert > Illustrations, then select Picture and choose how to add your image to the document.

2] Picture is not available on the Ribbon?

Because this is Microsoft Excel we’re talking about, the ability to add an image is not essential. Therefore, you may find that the Picture option is not available on the Ribbon but worry not.

If this is the case, click on File > Options, and from there, a new window will appear within Excel.

Click on Customize Ribbon. From far-right, click on the dropdown menu and select Main Tabs if it hasn’t been chosen already.

Below the Main Tab section, select Insert from the list of options, then go over to the left-side and click on the dropdown menu under Choose commands from. From there, choose Popular Commands, then select Insert Picture.

Finally, click on Add, and right away, the Insert Picture function will fall under the Insert Tab. Complete the task by clicking on the OK button.

You can now add your picture to Excel by following the first step above.

3] Remove Background from image

Once the image has been added to Microsoft Excel, you should see an option to the top left that reads, Remove Background. Click on that button, and right away, the background on the image should now have a purple tint.

Finally, click on Keep Changes to remove the background and keep the foreground.

4] Mark areas to keep or remove

From our experience, Excel is very good at detecting the background in many photos, so for the most part, the task of removing background is automatic. However, if the tool does not fully detect the background, then we suggest using the Mark Areas tool to get the job done.

If there is a section on the photo, you want to keep, select Mark Areas to Keep. If there is a section that needs to go, then click on Mark Areas to Remove.

Manually highlight the areas, then hit the Keep Changes button to complete the action.

TIP: You can also remove the Background of a Picture with Word.

Related posts

• 如何在Excel中使用Percentile.Exc function

• 如何使用NETWORKDAYS function在Excel

• 如何计算在Excel的Yes or No entries数

• Excel，Word or PowerPoint上次无法启动

• 如何在Excel中使用Automatic Data Type feature

• 如何在Excel创建和使用Form Controls

• 如何Merge and Unmerge cells在Excel

• 如何在Excel中计算列中的重复值

• 如何在Excel中使用Find and FindB functions

• 如何在Excel中使用INT and LCM Functions

• 如何从Excel document删除Read？

• 如何在Excel formula中锁定单元格以保护它们

• 如何在Microsoft Excel worksheet中添加Trendline

• 如何在Windows 11/10中创建Radar Chart

• 如何在Excel中使用DISC function

• 如何更改Excel worksheet Tab的颜色

• 如何在Excel中停止或关闭Workbook Sharing

• 如何在Excel中使用CHOOSE function

• 如何将一列拆分为Excel中的多列

• 如何在Windows 11/10中创建Tournament Bracket