How To Insert A Watermark in an Excel Spreadsheet?

Posted on

Watermark is an image or text that appears usually behind the main Document or Spreadsheet. For example, Watermarks usually displays the status of the Document or Spreadsheet such as “Confidential”, “Copyright” among others. Watermark can either be text or even images, such as our logo or other pictures. Inserting a Watermark is an easy procedure and has been describe in a previous post of mine, but inserting a Watermark in an Excel Spreadsheet is a bit tricky and will be described in the post below, so just keep on reading.

How To Insert A Watermark on a Spreadsheet in Excel

We must select the Page Layout tab and then we locate the area of the ribbon named Sheet Options as shown in the image below. At the bottom right corner of the Sheet Options area, we select the arrow located there which is name Sheet Page Setup, where we are also notified that we can Check Out The Full Set Of Printing Options For Our Spreadsheet.

How To Insert A Watermark on a Spreadsheet in Excel

Once we select the Sheet Page Setup command, the Page Setup dialog box appears as shown below, where we must activate the Header/Footer tab. In the middle of the Header/Footer tab of the Page Setup dialog box are located the Custom Header button and the Custom Footer button.

  • Header is a section of the Document or Spreadsheet that appears in the top margin.
  • Footer is a section of the Document or Spreadsheet that appears in the bottom margin.
  • Headers and Footers usually contain information such as Page Number, Date and Document Name. For this post though, it will contain a Watermark. Depending on where we want our Watermark inserted, we either select Header of Footer.

How To Insert A Watermark on a Spreadsheet in Excel

In the image below, I have selected the Header area for the Watermark to be inserted. Then we must activate either the Left Section, the Center Section or the Right Section for our Watermark. We then select the icon before the last one which is named Insert Picture as shown below.

How To Insert A Watermark on a Spreadsheet in Excel

Once we select the Insert Picture command, the Insert Pictures dialog box appears as shown below. We have the choices to Insert a Picture either From A File, Bing Image Search and OneDrive.

How To Insert A Watermark on a Spreadsheet in Excel

Once we have selected the Picture that we want, we return to the Header dialog box again as shown below. We notice now in the Center Section the following text: &[Picture].

How To Insert A Watermark on a Spreadsheet in Excel

If we want to Format the picture that we inserted in the Header as a Watermark, we can select the last icon in the Header dialog box, which is named Format Picture as shown below.

Header Dialog Box

Once the Format Picture command is selected, the Format Picture dialog box appears as shown below, where we make all the necessary adjustments that we want. We then press Ok to open all the dialog boxes so we can return to our Spreadsheet.

Format Picture Options

For us to view our Watermark that we had just created, we must Print Preview our Worksheet. For us to accomplish that, we select the File tab, to move to Backstage View and from the drop-down menu at the left we select the category Print as shown below.

  How To Insert A Watermark on a Spreadsheet in Excel

Keep in mind the following:

  • When we make changes to the Picture, they take place immediately and cannot be undone.
  • Before we Print out the Worksheet, we must make sure that the Header or the Footer Margin has enough space for the Picture to be displayed properly.
  • To Delete the Picture in the Header or Footer Section, we must select the &[Picture] text, and then press the Delete button on our Keyboard.

Below you can check out the video describing How To Insert A Watermark in an Excel Spreadsheet?

Don’t Forget To Subscribe To My YouTube Channel.

YouTube Channel

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s