When you hold most official papers up to the light, you’ll see a translucent text, picture, or photo in the backdrop that stands out from the rest of the writing. That is a watermark right there. Watermarks may be used to brand or protect papers. For example, to prevent illegal access, (photo)copying, or dissemination, you may apply a “CONFIDENTIAL” watermark to a document.
Watermarks have long been used on papers, but did you know that watermarks may also be added in Excel? This tutorial will teach you how to apply and utilize watermarks in Excel.
Excel does not have a separate watermark function. It does, however, enable you to add a text or image watermark to your spreadsheet.
How to Add a Watermark in Microsoft Excel
Simply drag and drop your text watermark to move it anywhere on your spreadsheet.
How to Add a Text Watermark in Excel
Here’s how to add a text watermark to your Excel document.
- Open the Excel document into which you wish to add a watermark.
- In the ribbon area, select the Insert tab, then Text, then Header & Footer.
- Now, in the header section, insert your watermark text where the flashing cursor is.
- The font size is set to 11 points by default, making your watermark text invisible to you. Return to the Home tab and enlarge the text size until it is plainly legible.
- You should now be able to see your text watermark inside your document. You will, however, notice that it is at the top of your spreadsheet.
- To relocate it, click the header area, drag the mouse to the beginning of the text, then hit the Enter key repeatedly until it is exactly where you want it.
- Depending on your watermark, it may be overly loud and distracting, conflicting with the spreadsheet’s primary text. You may correct this by using a lighter hue. To make your watermark gray, click the header area, then Font Color, and then gray. You may use whatever hue you like. When finished, click anywhere outside the header area. The modifications to your text watermark are now visible. Your watermark will be added to all pages of your spreadsheet using this way.
- Before printing, you may use the print preview (File > Print) to check how your watermark will look on your page and make any required changes.
- Launch Excel and go to the Insert tab.
- Go to the right and choose Text.
- Go to WordArt and choose a style.
How to Add a Watermark in Excel Using Word Art
- Fill in the Your text here box with your watermark text.
- To add a watermark, click on any cell outside the box.
- To format your text watermark, access the Shape Format tool bar by clicking on it. You have a lot of options here.
- Using the Form Format tool bar, you can add a text box to your watermark, customize its shape and WordArt, add Alt text, rotate, and resize it.
- Right-click on the watermark, go to the bottom of the menu selections, then choose Format Shape for even more specific formatting possibilities.
- To see all of your formatting choices, switch between Shape Options and Text Options.
- When finished, click X to close the Format Shape box.
- Open Excel and the document into which you wish to add a photo watermark.
- Next, choose Insert, Text, and Header & Footer. These buttons may be distributed around the ribbon area from left to right, depending on your configuration.
- If this does not open the Header & Footer window and instead displays a message stating that the current printer is unavailable. Pick another printer, click OK, then select another printer from the list and click OK again.
If you use this approach, you must manually copy and paste your text watermark from page to page, which is inefficient when dealing with huge spreadsheets.
You may also use a photo as a watermark in Excel. As an Excel watermark, you may use your logo, mascot, or any other picture. You may also personalize your photo watermarks.
Related: How to Add a Watermark in Google Docs
How to Add a Picture Watermark in Excel
Now, let’s look at how you may personalize your image watermarks in Excel. A watermark, such as the one seen above, will hide the content of your spreadsheet. Fortunately, Microsoft Excel enables you to format your image watermark. Here’s how it’s done: This has made our paper less cluttered, more branded, and more professional.
Here’s how to add a picture watermark in Microsoft Excel.
- A new Header & Footer window should now appear on the ribbon, next to the Help tab.
- Select your photo source and upload the image by clicking on Picture immediately under the Review tab.
- You have the option of uploading from your PC, searching Bing, or using OneDrive.
- Your image will not show instantly. Instead, look for a &[Picture] item inside the header cell. Click on any part of the document that is not in the header box. The picture with the watermark should now be visible.
- Any portion of the spreadsheet’s header may be selected by clicking on it. When you do, you’ll see a Header or &[Picture] entry.
- Next, go to the ribbon area and choose the Header & Footer option.
- The Format Picture option is now enabled. Just after Picture, click on Format Picture.
This may assist you in implementing a consistent watermark design throughout all of your company documents, whether they are created in Word, Excel, or PowerPoint.
How to Format Your Picture Watermark in Excel
You may remove watermarks from your spreadsheet, whether they are text or images, using Excel. It is simple and quick to remove a watermark. This is how.
- You have various Excel watermark formatting choices to choose from. You may clip, recolor, brighten, darken, or contrast your watermark, as well as adjust and reset its size. You may also change the Alt text. In this example, we will gray out and resize the image watermark. To remove the watermark, choose Format Picture > Picture > Color > Washout > OK. Go to Format Picture > Picture > Size to resize the watermark. To raise or reduce the size, use the up or down arrow. When you’re through formatting your watermark, click OK.
- In the backdrop, our watermark is now smaller and faded off.
- Select the header section of your spreadsheet. This activates your watermark.
- On your keyboard, press the Delete or Backspace key.
- In this example, we’ll gray out and resize the picture watermark.
- To gray out the watermark, go to Format Picture > Picture > Color > Washout > OK.
- To resize the watermark, go to Format Picture > Picture > Size. Use the up or down arrow to increase or decrease size.
- When you’re done formatting your watermark, click OK.
- Our watermark now appears smaller and washed out in the background.
Your watermark will be removed as a result of this. You are free to try something else until you discover one you like.
Including a watermark in your document is an easy method to trademark it and safeguard it from unwanted access. Watermarks may now be added to Excel as text or images.
Related: How to Add a Watermark in PowerPoint
How to Remove a Watermark in Excel
There are various choices and styles to pick from when choosing on the proper watermark for your Excel spreadsheet. So, go ahead and watermark it as you would your Microsoft Word papers.
- Click on the header area of your spreadsheet. This will make your watermark active.
- Press the Delete or Backspace key on your keyboard.
This will remove your watermark. You can go ahead and try something else until you find one that you like.
Related: Different Ways to Watermark Your Videos
Go On and Watermark Your Spreadsheet
Adding a watermark to your document is a sure way to brand and protect it against unauthorized access. You can now add watermarks in Excel, whether as text or image.
When deciding on the right watermark for your Excel spreadsheet, you’ll find that there are several options and styles to choose from. So yes, go ahead and watermark it just like your Microsoft Word documents.
You are looking for information, articles, knowledge about the topic How to Add a Watermark to an Excel Spreadsheet on internet, you do not find the information you need! Here are the best content compiled and compiled by the appsladder.com team, along with other related topics such as: How To.
Related videos about How to Add a Watermark to an Excel Spreadsheet