Buzz
Elevate your Excel sheets by adding subtle watermarks, not just for visual appeal but also as a copyright stamp to protect your text. Follow the steps below courtesy of Mytour.
1. Imprint Text in Excel
Open the Insert ribbon on the toolbar.
Next, click on the Header & Footer icon in the Text group of this ribbon.
This will activate Header & Footer Tools mode. Here, you can input submerged text in the left, center, or right boxes, choosing based on where you want the watermark text relative to the margins.
After entering the text, select the entire text and modify the formatting, including font size, style, and font color.
Opt for a slightly muted text color to avoid overshadowing the prominence of the statistical table content.
Once adjustments are made, click elsewhere to witness the displayed image of the text.
However, in its normal state, the text display will be positioned near the top of the sheet. You need to move it down, ideally to a suitable location in the middle of the spreadsheet content.
To achieve this, click on the text box, place the mouse cursor just before it, and press Enter to shift the text down to the desired location below.
As a result, you'll have submerged text exactly where you want it, akin to the illustration below.
2. Insert Submerged Images, Blurred Images
If you wish to add a blurred background image without text, follow the initial steps mentioned earlier. However, in the Header box, instead of entering text, click on the Picture icon within the Header & Footer Elements group.
You can choose from three options for inserting images: upload from your computer using From a file, select an online image from Bing using Bing Image Search, or pick an image from your cloud data using OneDrive – Personal.
After selecting an image, the data box will display the code line &[Picture]. Click elsewhere to see the displayed image.
For images with inherent transparency, minimal adjustments are needed. However, if it's an original image like the one below, you'll notice its bold colors can hinder data readability.
Hence, additional formatting for the image is necessary.
To tweak the image format, click on the Header box with the code &[Picture]. Open the Design ribbon within Header & Footer Tools.
Click on the Format Picture icon in the Header & Footer Elements group.
The function window Format Picture will appear; on the Size tab of this function window, you can adjust the following items:
- Size and rotate: Adjust the size and rotation of the image. With Height as the image's height, Width as the image's width, and Rotation as the image's rotation degree.
- Scale: Modify the image size as a percentage, with Lock aspect ratio for maintaining the frame ratio, and Relative to original picture size for relative sizing to the original image.
In the Picture tab of this function window, you can fine-tune the following items:
- Crop from: Allows you to trim the image along the left Left, right Right, top Top, and bottom Bottom directions.
- Image control: Assists you in adjusting the color and brightness of the image, with Brightness for intensity and Contrast for sharpness.
Alternatively, you can choose predefined combinations of Brightness and Contrast under Color. For a subtle and blurred image effect, opt for Washout in Color.
Finally, click OK to confirm the settings.
The tutorial on Embedding Subtle Images in Excel, Adding a Watermark in Excel by Mytour concludes here. We hope that through this article, our readers can grasp the technique of embedding images in Excel. Wishing you all successful implementations.
