Adding a watermark in Excel can be achieved in three ways. First, use the header footer to insert text watermark, enter the header footer editing mode to enter text and set the format, which is suitable for printing output; second, use cell filling to simulate the watermark effect, and set the text style and layout by inserting the text box to make it float above the table to present a watermark vision; third, insert a background picture with a watermark, and set the created transparent PNG picture as a worksheet background, which is suitable for fixed templates, but has poor flexibility.

Adding a watermark in Excel is not as direct as Word, but it can still be achieved through some workarounds. If you want to display background text such as "draft" and "confidential" when printing or sharing a form, the following methods can help you.

Insert text watermark using header footer

A common method of Excel is to insert text as a watermark through the header or footer . While it's not a background watermark in the true sense, it works well in the print preview.

• Open the Excel file and click Insert > Header and Footer on the top menu
• After entering the header/footer editing mode, enter the text you want to display in the middle or bottom area, such as "Internal Information"
• You can set the font to gray, bold and properly resize to make it look more like a watermark
• After exiting edit mode, you can see the effect in the page layout view or print preview

This method is suitable for scenarios where printouts are required, but does not appear in the body of the worksheet.

Simulate watermark effect with cell filling

If you want the watermark to be displayed in the background of the worksheet content (a visual effect similar to Word), you can use the " Insert Text Box Picture Fill " method to simulate it.

The operation steps are as follows:

• Click Insert > Text Box in the menu
• Drag the drawing of a large text box in the worksheet, covering the entire table area
• Enter the text you want to use as a watermark, such as "Draft"
• Set the font color to light gray and the font size is larger (recommended 60~80)
• Right-click the text box and select "Set Shape Format"
• Check "Always place text on top" and rotate the text box at a certain angle to increase the watermark feeling
• Finally, set the text box to "no fill", only the text is retained

This way, the text will float above the table, looking like a watermark. However, it should be noted that this method will affect some printing settings, and it is recommended to use it formally after testing.

Insert a background image with watermark (suitable for fixed templates)

If you often use fixed watermark styles, you can also make the watermark into a transparent picture and insert it as a background.

• First use image processing software to create a transparent PNG picture with watermark
• Back to Excel, click "Page Layout" > "Background"
• Select the picture you prepared and it will cover the entire worksheet as the background
• Note: This background image cannot be resized with the cell, and it does not support fine adjustment of the printing settings.

This method is suitable for internal fixed templates, which are simple and convenient, but not flexible enough.

The above three methods can be used in different scenarios. If it is only for printing, it is recommended to use the header and footer; if you want to see the watermark on the screen, you can use the text box to simulate it; and if you make a template, the background image is the most troublesome choice. Basically these methods are all. Although there is no one-click addition function, it is not complicated to operate. The key is to choose the right method.

The above is the detailed content of How to add a watermark in Excel. For more information, please follow other related articles on the PHP Chinese website!