How to Add a Watermark in Excel (with Pictures)

Table of contents:

2024 Author: Samantha Chapman | [email protected]. Last modified: 2024-01-15 13:47

This wikiHow article teaches you how to create and add a watermark or logo to an Excel sheet, using WordArt to create a transparent watermark in the background of your document, or inserting your logo image as a header at the top of the page.

Steps

Method 1 of 2: Add a Background with WordArt

Step 1. Open the Excel document you want to edit

Start Microsoft Excel on your computer and double click on the document from the list of saved sheets.

Step 2. Select the Insert tab

It is located between the tabs Home And Page layout in the upper left corner of the screen and allows you to display the relevant toolbar at the top of the document.

Step 3. Select the WordArt option from the Insert menu toolbar

The button looks like an icon with a " TO"in italics and is on the right side of the screen; clicking on it will open a pop-up window where you will see the list of available WordArt styles.

Step 4. Select a style for your watermark

In the WordArd pop-up window, click on the style you prefer to insert a new box into the document.

Step 5. Edit the text in the WordArt box

Click on the sample text in the box to edit it and enter what you want to use for your watermark.

Step 6. Right click on the WordArt box

This will display the right click options in a pop-up menu.

Step 7. Select Format Shape after activating the right click menu to display the shape and text options

Step 8. Select Solid Fill from the options under Text Fill to change the transparency of your WordArt on the sheet background

If you are using Excel 2015 or later, click on the tab Text options at the top of the menu to view the Text Fill options.
For older versions, click on the option Text fill on the left menu in the Layout window, then select the tab Solid at the top and choose a color.
In addition, from here you can change the outline of the text: you can select No Filling, Solid Fill or Gradient for the outline and change its transparency separately.

Step 9. Increase the Transparency bar to 70%

Click and drag the Transparency bar to the right to make the WordArt watermark relatively invisible in the background of the document.

Step 10. Edit the watermark properties

You can change the size, position and orientation of the WordArt box to suit your personal or professional needs.

Click and drag the WordArt box to place it on the sheet.
Click and move the circular arrow icon at the top of the box to change its pitch and angle.
Double click on the text to change the font size from the card Home to make the watermark bigger or smaller.

Method 2 of 2: Add a Header Logo

Step 1. Open the Excel document you want to edit on your computer

Start Microsoft Excel and find the document from the list of saved sheets.

Step 2. Click on the Insert tab

The button is located next to the tab Home in the upper left corner of the menu bar.

For older versions, you will need to click on the tab View.

Step 3. Click the Header and Footer option to create a header area at the top and a footer area at the bottom of the sheet

You will find this option by clicking on the button with the icon in the shape of TO in italics on the Insert toolbar.

Step 4. Select the area Click to add a header

This section is located at the top of the sheet and allows you to display the menu toolbar Drawing up.

Depending on the version you are using, the card may be called Header and footer.

Step 5. Click Image on the toolbar

It is located next to the button Sheet name and will allow you to select an image to insert.

Step 6. Click Explore

This will display all your files in a pop-up window.

Step 7. Select the logo image you want to insert

Find the file in the pop-up window and click on it to select it.

Step 8. Click the Insert button

This way the logo will be added at the top of the sheet.

3 Ways to Put a Watermark on Photos

When posting photos online, they are rarely protected, which means they can be used by anyone with access to them. Photos may be copyrighted, but a trick often used by photographers is to add a watermark - or watermark - to their images. Traditionally, watermark is a variation in paper thickness that can only be seen under certain conditions.

How to Add a Header Row in Excel

Microsoft Excel provides several methods for creating a header row, each designed to perform a specific task, based on the user's needs. For example, you can freeze the scrolling of a specific row so that it always remains visible on the screen, even when scrolling through the rest of the worksheet.

How to Add a Filter in Excel 2007: 8 Steps

The filter is a simple and reliable way to locate and manage data in a spreadsheet. In Excel 2007, you can filter data using the AutoFilter feature, which displays only data that meets the specified criteria. Filtered data can be copied, edited and printed without having to move it to a new spreadsheet.

How to Add a Dropdown Menu in Excel 2007

Adding a drop-down menu to your Excel 2007 spreadsheet can speed up data entry and give users a list of items to choose from, instead of having to type in information time and time again. When you add a drop-down menu to a spreadsheet cell, the cell will show a down arrow.

How to Add New Tabs in Excel: 6 Steps

If you want to use a separate tab for each month in a dedicated revenue file or want to create a new tab to insert instructions at the beginning of a complex spreadsheet, this article will teach you how. Steps Step 1. Open Microsoft Excel Step 2.