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

In daily office work, how to add watermarks to Excel tables bothers many people. Unlike Word where you can add watermarks directly, Excel does not provide special functions. To solve this problem, PHP editor Strawberry summarized the following three common watermark adding 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 that needs to be added to the 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.

Advantages: Be able to view the watermark effect in real time in the worksheet editing mode.

Disadvantages: The background image cannot be printed with the Excel sheet and is for visual reference only.

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 mengingati atau menyimpannya, kerana jika anda ingin mengubah suai dan mengedit jadual Excel kemudian, 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!