How to add watermark to Excel table? 3 methods are recommended!

In daily office work, we often need to add watermarks to Excel tables to indicate document status or copyright information. Although Excel itself does not have a special watermark function, we can still achieve the watermark effect through some methods. This guide will introduce three common ways to add watermarks in Excel to help you easily solve your document watermark needs. PHP editor Banana has conducted in-depth research on these methods to ensure their operability and effectiveness, so that the security of your document information is guaranteed. Read on to learn how to add a watermark to your Excel sheets using these three methods.

Method 1: Add image watermark using header or footer

This is one of the most commonly used methods to easily add image watermark to the entire Excel table.

Steps:

1. Open the Excel document, click the [Insert] tab at the top, then find the [Text] group and click [Header and Footer].

2. Find the [Header and Footer Elements] group in [Header and Footer], select the content you need to add a watermark, such as "Current Date", "File Name", etc., or select "Picture" to import Company logo or customized watermark image.

If the watermark needs to be added to the footer, click [Go to Footer] in the [Navigation] group.

3. After selecting the watermark to be added, Excel will automatically add the selected content or image to the header. You can view the effect in preview mode.

Advantages: Suitable for situations where you need to add the same watermark to every page.

Disadvantages: The watermark cannot be seen directly in the worksheet editing view and needs to be viewed through print preview.

Method 2: Use the text box to insert a text watermark

If you just want to add a simple text watermark to a certain area, such as "Draft" or "Internal use only", you can This is done through text boxes.

Steps:

1. Open the Excel document, click the [Insert] tab, and then click [Text Box].

2. Draw a text box in the form and enter the desired watermark text, such as "Confidential" or "Draft", or the company name.

Then select the text box, right-click and select [Format Shape].

3. After the "Format Shape" interface appears, select [Text Options], and then adjust the text transparency, color, font size and angle.

4. Select the first icon under "Shape Options", then select "No Fill" in Fill and "No Line" in Line to remove the text border and the watermark text setting is completed.

5. Finally, drag the text box to the center of the table or other appropriate location.

Advantages: Flexibly adjust the watermark position, font and size.

Disadvantages: The text box may be obscured by the contents of other cells, affecting editing.

Method 3: Insert a background image as a watermark

Using a background image is also a common watermark method, suitable for situations where a global background is required.

Steps:

1. Open the Excel document and click the [Background] button in the [Page Layout] tab in the top menu bar.

Then select a locally stored image as the background, and then click [Insert] to import the image.

2. The picture will appear as the background of the entire worksheet.

Note: The background image is only visible in the worksheet's display mode, but cannot be printed. If you need to print a watermark, use the header/footer or text box method.

Kelebihan: Dapat melihat kesan tera air dalam masa nyata dalam mod pengeditan lembaran kerja.

Kelemahan: Imej latar belakang tidak boleh dicetak dengan helaian Excel dan adalah untuk rujukan visual sahaja.

Kaedah untuk melindungi tera air:

Selepas menetapkan tera air, kami boleh menetapkan sekatan pengeditan pada Excel supaya keseluruhan jadual dan tera air yang ditambahkan tidak boleh diubah suai atau dipadamkan.

Langkah:

Klik [Semakan] → [Lindungi Lembaran Kerja] dalam bar menu Apabila kotak dialog muncul, masukkan kata laluan yang anda mahu tetapkan, dan kemudian klik [OK].

Dengan cara ini, kandungan jadual Excel hanya boleh diubah suai dengan memasukkan kata laluan.

Perlu diingat bahawa selepas menetapkan kata laluan, ingat untuk mengingatnya atau menyimpannya, kerana jika anda ingin mengubah suai dan mengedit jadual Excel nanti, anda perlu memasukkan kata laluan yang ditetapkan asal.

Jika anda terlupa secara tidak sengaja, anda memerlukan bantuan alat lain. Contohnya, Alat Pemulihan Kata Laluan PepsiNiu Excel boleh terus mengalih keluar "pengeditan terhad" Excel tanpa menggunakan kata laluan.

Pilih modul [Unrestriction] dalam alat, dan kemudian import jadual Excel.

The above is the detailed content of How to add watermark to Excel table? 3 methods are recommended!. For more information, please follow other related articles on the PHP Chinese website!