如果您使用传统方法将背景图像添加到电子表格中；Excel不会打印图像。如果您需要打印带有背景图像的 Excel 电子表格^{(print an Excel spreadsheet with a background image)}。那么本教程将向您展示如何做到这一点。您需要在电子表格中单独添加图片，以便在打印时检测到图片。本教程仅适用于Office 365、2019^{(Office 365)}和 2016 用户。

默认情况下，您可以转到“页面布局^{(Page Layout)}”选项卡并单击“背景^(Background)”选项以将图片添加到背景中。但是，只要您将电子表格仅保存在计算机上，它就可以工作。每当您尝试打印文件时，它会立即删除背景图像。有时，您可能需要将图像粘贴到电子表格的背景中以更好地对其进行自定义或作为水印。

如何在Excel中打印^(Excel)背景图像^{(Background Image)}

要打印带有背景图像的Excel电子表格，请执行以下步骤 -^(Excel)

1. 在Excel^(Excel)中完成对电子表格的编辑。
2. 插入一个覆盖您的数据的形状。
3. ^(Add)从图片^(Picture)或纹理填充部分添加图像。
4. 调整透明度。
5. 打印电子表格。

完成电子表格的编辑后，您可以插入背景图片；因为一旦插入背景图像，编辑电子表格可能会很尴尬。如果您已完成编辑，请转到“插入^{(Insert )}”选项卡并单击“形状^{(Shapes )}”选项。

从这里，选择一个矩形并使用鼠标覆盖包含您的数据的整个区域。如果您有从 A1 到Z100的数据，则必须使用该形状覆盖整个区域。也就是说，背景图片会根据这个选中的区域插入。之后，右键单击形状，然后选择“设置形状格式^{(Format Shape )}”选项。

它将在您的右侧打开一个窗格。展开填充^{(Fill )}菜单并从列表中选择图片或纹理填充^{(Picture or texture fill)}选项。顾名思义，它可以帮助您添加图片或纹理作为背景。要替换默认纹理，请单击图片源^{(Picture source )}选项下的插入^{(Insert )}按钮。

现在您需要选择一个图像。如果您的 PC 中已有图片，请单击“从文件^{(From a File)}”选项。如果您想从网站获取图片，您应该点击在线图片^{(Online Picture )}按钮，然后按照屏幕说明进行操作。

插入图像后，更改透明度级别，使其充当水印。为此，请使用透明度^{(Transparency )}菜单根据您的要求进行调整。

现在，您可以打印电子表格，它不会从背景中删除图像。

希望本教程有所帮助。

How to print the Background Image in Excel

If you usе the traditionаl method to add a background іmage to your spreadsheet; Excel won’t print the image. If you need to print an Excel spreadsheet with a background image. then this tutorial will show you how to do it. You need to add the picture separately in your spreadsheet so that it detects the picture while printing. This tutorial is for Office 365, 2019, and 2016 users only.

By default, you can go to the Page Layout tab and click the Background option to add a picture to the background. However, it works as long as you keep the spreadsheet on your computer only. Whenever you try to print the file, it deletes the background image immediately. Sometimes, you may need to paste an image in the background of the spreadsheet to customize it better or as a watermark.

How to print the Background Image in Excel

To print an Excel spreadsheet with a background image, follow these steps-

1. Finish editing your spreadsheet in Excel.
2. Insert a shape covering your data.
3. Add an image from Picture or texture fill section.
4. Adjust the transparency.
5. Print the spreadsheet.

Once you have finished editing your spreadsheet you can insert the background picture; because once the background image is inserted, it might be awkward to edit the spreadsheet. If you are done with the editing, go to the Insert tab and click on the Shapes option.

From here, choose a rectangle shape and use your mouse to cover the whole area that includes your data. If you have data from A1 to Z100, you must cover the entire area with that shape. In other words, the background image will be inserted according to this selected area. After that, right-click on the shape, and select the Format Shape option.

It will open a pane on your right side. Expand the Fill menu and select Picture or texture fill option from the list. As the name defines, it helps you add a picture or a texture as the background. To replace the default texture, click the Insert button under the Picture source option.

Now you need to choose an image. If you already have the picture in your PC, click on the From a File option. If you want to fetch the image from a website, you should click the Online Picture button, and follow the screen instructions.

After inserting the image, change the transparency level so that it acts as a watermark. For that, use the Transparency menu to adjust it according to your requirements.

Now, you can print the spreadsheet, and it won’t remove the image from the background.

Hope this tutorial helps.

Related posts

• 如何在Windows Terminal中设置Background Image

• 如何添加和打印 Excel 背景图像

• 如何禁用Edge New Tab page的Image Background类型

• 禁用Windows 10中的Desktop Background Image

• 8 Apps以删除Android中的Background From Any Image

• 如何在Excel中使用DEC2Bin将十进制数转换为二进制数

• 如何在Excel中使用CHOOSE function

• 如何在Microsoft Excel中使用HLOOKUP function

• 如何在Excel使用EDATE and EOMONTH Functions

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

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

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

• 如何在Excel中使用DISC function

• 如何在Excel中使用DCOUNT and DCOUNTA Function

• 如何在一页上打印Excel or Google Sheets中所选单元格

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

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

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

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

• 如何在Microsoft Excel worksheet中添加Trendline