How to Insert watermark in Excel

Today's TipsMake will show you how to create and add a watermark or logo to an Excel worksheet file. You can use WordArt text to create a transparent watermark on the worksheet background or insert a logo image to create a letterhead at the top of the page.

Add WordArt to the worksheet background

How to Insert watermark in Excel Picture 1

Open the Excel file you want to edit. Open Microsoft Excel on your computer and double-click the file in the list of saved worksheets.

How to Insert watermark in Excel Picture 2

Click the Insert tab . This button is located between the Home and Page Layout tabs in the upper right corner of the screen. The Insert toolbar opens at the top of the worksheet.

How to Insert watermark in Excel Picture 3

Click the WordArt option in the Insert toolbar. This button has an italicized " A " icon on the right side. A list of available WordArt styles appears in the pop-up window.

How to Insert watermark in Excel Picture 4

Choose a style for the watermark. Click the style you want to choose in the WordArt window that pops up. The new WordArt frame will be inserted into the worksheet.

How to Insert watermark in Excel Picture 5

Edit content in WordArt text frame. Click on the text in the WordArt frame and enter the text you want to use as a watermark.

How to Insert watermark in Excel Picture 6

Right click on the WordArt frame. Right-click options will open in a pop-up menu.

How to Insert watermark in Excel Picture 7

Select Format Shape from the right-click menu. A menu of text and shape options opens.

How to Insert watermark in Excel Picture 8

Select Solid fill below the Text fill option. This option allows you to edit the transparency of the text art on the sheet background.

In Excel 2015 and later, click the Text Options tab at the top of the menu pane to see Text Fill options.

On previous versions, you clicked the Text Fill option in the left menu of the Format window. Then, click the Solid tab at the top and choose a color.

Or you can edit the outline of the text here. No Fill , Solid Fill or Gradient Fill are text border options used to change the transparency of the line.

How to Insert watermark in Excel Picture 9

Increase the Transparency slider to 70%. Click and drag the Transparency slider to the right so that the WordArt watermark becomes relatively transparent on the worksheet background.

How to Insert watermark in Excel Picture 10

Edit watermark properties. You can change the size, position and orientation of the WordArt frame to ensure the watermark fits your personal or work requirements.

Click and drag the WordArt frame to move the watermark around the worksheet.

Click and move the circular arrow icon at the top of the frame to change the angle and direction of the watermark.

Double-click the text and change the font size in the Home tab if you want to make the watermark larger or smaller.

Add letterhead logo

How to Insert watermark in Excel Picture 11

Open the Excel file you want to edit. Open Microsoft Excel on your computer and double-click the file in the list of saved worksheets.

How to Insert watermark in Excel Picture 12

Click the Insert tab in the upper left corner of the menu bar, next to the Home button .

On older versions, you may need to click the View tab .

How to Insert watermark in Excel Picture 13

Click the Header & Footer button in the Insert toolbar. The header area will be created at the top and the footer at the bottom of the worksheet.

How to Insert watermark in Excel Picture 14

Click the Click to add header area at the top of the worksheet. The Design toolbar will appear above.

Depending on the version of Excel, this tag is also called Header & Footer .

How to Insert watermark in Excel Picture 15

Click Picture located in the toolbar. This option is next to the Sheet Name button in the Design tab. A new window will appear allowing you to select an image to insert.

How to Insert watermark in Excel Picture 16