这是有关如何在Microsoft Excel中添加水印的教程。虽然Excel不提供任何直接选项来将水印插入工作簿,但您仍然可以为Excel工作表添加水印。为此,您需要执行一些步骤。在本指南中,我将讨论在Excel中添加水印的两种方法。让我们开始吧!
如何在 Excel 中添加水印
在Microsoft Excel(Microsoft Excel)中插入水印有两种方法,包括:
- 使用图片文件添加水印(Watermark)
- 创建并添加水印
让我们详细讨论这些方法!
1]使用图片文件添加(Add)水印(Watermark)
您可以使用自己的图片向Excel工作簿添加水印。它可以是图章、您的徽标图像或任何您想用来为Excel文件添加水印的图像。让我们看看使用这种方法插入水印的步骤。
首先,打开您的工作簿并转到“插入(Insert)”选项卡。从这里,单击 Text > Header & Footer选项。
现在,一个页眉(Header)和页脚(Footer)选项卡将出现在Excel功能区上。转到它并单击图片(Picture)选项。
接下来,从您的 PC、Bing Image Search或 OneDrive 存储浏览并导入水印图像。
这将在标题中添加一个&[Picture]代码。(&[Picture])只需(Simply)单击工作表上的任意位置,您的水印图像就会出现在工作簿中。
现在,如果要将水印图像放在工作簿的中心,只需将光标放在&[Picture]代码之前,然后反复按Enter键。(Enter)
现在,单击工作表,您将看到您的水印出现在Excel工作簿的中心附近。
2]在Excel中(Excel)创建(Create)然后添加水印(Watermark)
您还可以在Excel(Excel)中创建新的水印图像,然后将其添加到工作簿中。假设您想添加一个印章作为水印,例如Confidential、Draft、Approved或其他任何内容。您可以使用艺术字(WordArt)功能并创建自己的水印,您可以将其插入Excel 工作(Excel)表中。让我们看一步一步的过程。
首先,转到“插入( Insert)”选项卡,然后单击“文本(Text)”下拉按钮。现在,单击艺术字(WordArt)下拉按钮并选择所需的艺术字(WordArt)以添加到Excel工作表中。
之后,单击艺术字(WordArt)以输入和自定义您的文本。您可以在新行中重复相同的文本以强调它。
完成后,右键单击艺术字(WordArt)框,然后从上下文菜单中按另存为图片(Save as Picture)选项并将图片保存在 PC 上的任何位置。您可以从PNG(PNG)、JPG、SVG、GIF、TIFF和BMP中选择所需的图像格式。
现在,转到Insert选项卡并添加Text > Header & Footer。然后,从页眉(Header)和页脚(Footer)选项卡中,单击图片(Picture)选项以添加水印图像。
浏览您刚刚创建的水印图像并将其从您的 PC 中导入。然后它将作为水印添加到标题中。
如何在Excel(Excel)中格式化水印图像
如果要格式化水印图像,请选择图像并转到页眉(Header)和页脚(Footer)选项卡。现在,单击“格式化图片”(Format Picture)选项以打开各种水印自定义选项。这些是选项:
- 您可以调整(resize)水印图像的大小。
- 它可以让您裁剪(crop)水印图像。
- 您还可以对水印图像应用一些着色效果。(colouring effects)比如不想过分强调水印,可以使用Washout效果。同样,您可以调整图像的亮度和对比度。
- 它还提供了一个选项来压缩( compress)水印图像。
自定义上述选项后,单击确定按钮,您的水印图像将被格式化。
因此,您可以在Microsoft Excel(Microsoft Excel)中添加水印。
阅读下一篇(Read next):自动保存在 Office Excel、Word 或 PowerPoint 中不起作用(AutoSave not working in Office Excel, Word or PowerPoint)。
How to Add a Watermark in Excel
Here is a tutorial on how to add a watermark in Microsoft Excel. While Excel doеsn’t providе any direct option tо insert watermаrks into your workbooks, you can still watermark an Excel sheet. There are some steps you need to perform in order to do so. In this guide, I am going to discuss two ways to add a watermark in Excel. Let’s get started!
How to Add a Watermark in Excel
There are two methods to insert a watermark in Microsoft Excel including:
- Add a Watermark using a picture file
- Create and then add a watermark
Let’s discuss these methods in detail!
1] Add a Watermark using a picture file
You can add a watermark to an Excel workbook using your own picture. It can be a stamp, your logo image, or any image that you want to use to watermark an Excel file. Let’s check out the steps for inserting a watermark using this method.
Firstly, open your workbook and go to the Insert tab. From here, click on the Text > Header & Footer option.
Now, a Header & Footer tab will appear on the Excel ribbon. Go to it and click on the Picture option.
Next, browse and import the watermark image from your PC, Bing Image Search, or your OneDrive storage.
This will add an &[Picture] code to the header. Simply click anywhere on the sheet and your watermark image will appear in the workbook.
Now, if you want to put the watermark image at the centre of the workbook, simply place the cursor before &[Picture] code and press Enter button repeatedly.
Now, click on the sheet and you will see your watermark appearing at about the centre of your Excel workbook.
2] Create and then add a Watermark in Excel
You can also create a new watermark image in Excel and then add it to the workbook. Let’s say you want to add a stamp as a watermark like Confidential, Draft, Approved, or anything else. You can use the WordArt feature and create your own watermark which you can insert into an Excel sheet. Let’s see a step by step procedure to do so.
First, go to the Insert tab and click on the Text drop-down button. Now, click on the WordArt drop-down button and choose the desired WordArt to add to the Excel sheet.
After that, click on the WordArt to enter and customize your text. You can repeat the same text in new lines to emphasize it.
When done, right-click on the WordArt box and from the context menu, press the Save as Picture option and save the picture at any location on your PC. You can choose the desired image format from PNG, JPG, SVG, GIF, TIFF, and BMP.
Now, go to the Insert tab and add Text > Header & Footer. And then, from the Header & Footer tab, click on the Picture option to add a watermark image.
Browse the watermark image that you just created and import it from your PC. It will then be added to the header as a watermark.
How to format watermark imagein Excel
If you want to format your watermark image, select the image and go to the Header & Footer tab. Now, click on the Format Picture option to open up various watermark customization options. These are the options:
- You can resize the watermark image.
- It lets you crop a watermark image.
- You can also apply a few colouring effects to the watermark image. For example, if you don’t want to emphasize the watermark too much, you can use the Washout effect. Similarly, you can adjust the brightness and contrast of the image.
- It also provides an option to compress the watermark image.
After customizing the above options, click on the OK button and your watermark image will be formatted.
Thus you can add a watermark in Microsoft Excel.
Read next: AutoSave not working in Office Excel, Word or PowerPoint.