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.
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.
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.
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.
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.
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.
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.
Don’t Forget To Subscribe To My YouTube Channel.
This entry was posted in Word 365 ProPlus English and tagged backstage view, Bing Image Search, Center Section, Check Out The Full Set Of Printing Options For Our Spreadsheet, Date, Document, Footers, Format, From A File, Headers, How To, How To Insert A Watermark in an Excel Spreadsheet?, Insert Picture, Know How, Left Section, Margins, Microsoft Excel, Microsoft Office, Microsoft Outlook, Microsoft PowerPoint, Microsoft Word, My YouTube Channel, Name, Office Smart, Office System, OfficeSmart, OneDrive, Page Layout, Page Number, philippospan, Picture, Print, Right Section, Sheet Options, Sheet Page Setup, Smart Office, smartoffice, Spreadsheet, Subscribe, Tip & Tricks, Watermark.