insert watermark in the worksheet in Excel

Q74. In Excel, how can I insert a watermark in my Worksheet?

To do it in Excel, here is the answer:

a) Click on "Header & Footer" under "Insert".

excel insert watermark in the worksheet

b) The display changes to "Page Layout" view automatically as shown below. The "Header & Footer Tools" tab appears. Under it, click on "Picture" with cursor in Header section, .

excel excel insert watermark in the worksheet

c) In the "Insert Picture" dialog box that comes up, navigate to the folder containing the watermark picture, select the picture and click on Insert.

excel excel excel insert watermark in the worksheet

d) Double click on any cell to come out of Header. Watermark picture is now added to worksheet.

excel excel excel excel insert watermark in the worksheet

Note: To come back to "Normal" view from "Page Layout" view, click on "Normal" under "View" as shown below.

excel excel excel excel excel insert watermark in the worksheet

 

You can find similar Excel Questions and Answer hereunder

1) How can I enter a cent symbol in a cell?

2) How can I add a background image to a worksheet?

3) How can I enter a picture in a cell?

4) Is there any way I can see more region of my WorkSheet?

5) How can I add a WorkSheet and name it as required using VBA?

6) How do I add a shape using VBA?

7) How do I add a symbol like Triangle / Inverted Triangle for indicating trends in a cell using VBA?

8) How can I loop through all WorkSheets and get their names using VBA?

9) How to disable ability to insert Rows and Columns in Excel (using VBA)?

10) How can I save a WorkSheet as a new WorkBook using VBA?

11) How can I export a WorkSheet as a PDF using VBA?

12) How can I identify the cells that influence a particular cell to help with debugging of my spreadSheet or understand a spreadSheet that I inherited?

13) How can worksheet functions be accessed in VBA?

14) How can I copy and rename a WorkSheet using VBA?

15) How can I protect / unprotect WorkSheet using VBA?