If you hold the official files in front of the light, an address will appear on them that is not normally visible. This mark is called Watermark. In the digital world, too, many images and files have their own watermarks to protect a work from being copied and stolen.
In this article, we are going to teach you how to add a watermark in Excel software. Excel is a very useful and popular software from Microsoft that does not have the watermark feature on it by default, but you can have a watermark in Excel by doing a series of things. For example, the watermark we want to put on our Excel file in this article is CONFIDENTIAL.
How to add watermark in Excel?
As mentioned, Excel does not have a watermark feature by default. However, Excel always allows you to add your own watermark text or image to your worksheet.
How to add text in Excel Watermark?
You can add a text watermark to your file by following the steps below in Excel software:
Open the file or file that you created in Excel and want to put a watermark on it.
Navigate to the Ribbon area, click the Insert tab, click Text, and select Header & Footer.
Now enter your watermark entry in the small space that opens.
The font of the text is set to 11pts by default, which makes the watermark text invisible to you.
Go to the Home tab and enlarge your font size to make it clearer.
The watermark text should now be visible to you and you should see it at the top of your Excel spreadsheet.
To set the position of a text watermark on an Excel screen, tap the Header area, hover over the text, and press Enter repeatedly on the keyboard to place the watermark text exactly where you want it.
Depending on your watermark, there may be some inconsistency with the original Excel text. To solve this problem, you can use a lighter color. To make the watermark gray and lighter, click on the Header area, select the Font Color option, and choose the gray color with whatever intensity you like.
When you're done, click anywhere except the header area.
The changes you made to your text watermark are now displayed. Using this method, the watermark will be applied to all your Excel sheets.
You can use the print preview (File> Print) to see how it is displayed on your file and make the necessary changes before printing.
Add a watermark to Excel using Word Art
Open Excel and click on the Insert tab.
Scroll slightly to the right and select Text.
Click on the WordArt option and select the style you want.
Put the watermark you want in the Your text here box.
Click on any of the cells outside the box to set and register your watermark.
To specify the text watermark format, click on the relevant option to open a Shape Format tool page. From this section, you can make various changes to your text watermark.
In this section, you can specify the frame, style and shape of your watermark text. Or change WordArt, add alternative text, rotate it, and resize it.
For more personalization options, right-click on the watermark, go to the top of the options menu, and click Format Shape.
Choose from Shape Options and Text Options to see all formatting options.
Whenever you are done with text watermark personalization, check the x and close the Format Shape box.
Do not forget that to change the position of the text watermark, you can take it and drop it wherever you like. Note, however, that if you choose the WordArt method, you must add the created watermark to all pages by copying and pasting, and like the previous method, the watermark will not be applied to all pages automatically.
How to add a video in Excel Watermak?
Excel also allows you to use an image for a watermark. You can add a logo, symbol and any other image to your Excel file and customize it to your liking.
You can add your own watermark in Excel by following these steps:
Run Excel and open the file and file you want.
Now click on the Insert tab, click Text and then select Header & Footer. You will now see these options at the top.
If this does not open the Header & Footer panel and instead the message Current printer is unavailable. You see Select another printer, click OK, select another printer from the settings and click OK.
Now you should see the Header & Footer panel next to the Help tab.
Right at the bottom of the Review tab, click Picture, select the image you want from your computer, and upload it.
Your image will not be displayed instantly. After uploading the image, you will see a new tab called [Picture] in the header cell. Click on any part of the file, other than the header section, and the watermark image should appear.
Watermark photo changes
The watermark image you have selected will take over your content and you will need to make a series of changes to make it fit properly in your file. Follow the steps below to make changes to your watermark photo:
Click on any part of the page header to see the Header or & [Picture] option.
Now go to the ribbon section and click on the Header & Footer tab.
The Format Picture option now appears exactly after the Picture option. Click on it.
There are several different options for Excel Watermark. For example, you can reset or crop your watermark size, increase or decrease its light and contrast, and…
Here we decided to make our watermark image lighter and resize it as well.
To make the watermark image lighter or lighter, follow this URL: Format Picture> Picture> Color> Washout> OK
To resize the watermark image, go to Format Picture> Picture> Size and use the up and down arrows to resize it.
Click OK after personalizing the image.
Our watermark is now smaller and has less color, which does not cause any problems for viewing Excel content.
How to remove watermark in Excel?
Excel allows you to remove your watermarks from the main pages; Whether text or image. Removing a watermark is quick and easy, and to do it, you just need to follow the steps below.
Click on the header area to activate your watermark.
Press the Delete or Back Space key on your keyboard. Just as easily!
The importance of watermarks
Adding a watermark to your file or Excel file, or any other file and effect in general, will protect your property and prevent it from being misused. Now you can use this tutorial to create a watermark for your Excel and put it on your file.
What do you think about watermarking a work or a file? Did this tutorial work for you? Share your good comments with us .
#excel