You are viewing the article How to Insert watermark in Excel at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 2,818 times.
This wikiHow teaches you how to create and add a watermark or logo to an Excel worksheet file. You can use WordArt word art to create a transparent watermark on the sheet background, or insert a logo image to create letterheads at the top of the page.
Steps
Add WordArt to Sheet Background
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/a9/Insert-a-Watermark-in-Excel-Step-1.jpg/v4-728px-Insert-a-Watermark- in-Excel-Step-1.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/a9/Insert-a-Watermark-in-Excel-Step-1.jpg/ v4-728px-Insert-a-Watermark-in-Excel-Step-1.jpg”,”smallWidth”:460,”smallHeight”:349,”bigWidth”:728,”bigHeight”:553,”licensing”:” <div class=”mw-parser-output”></div>”}
Open the Excel file you want to edit. Proceed to open Microsoft Excel on your computer and double-click the file in the list of saved sheets.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/22/Insert-a-Watermark-in-Excel-Step-2.jpg/v4-728px-Insert-a-Watermark- in-Excel-Step-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/22/Insert-a-Watermark-in-Excel-Step-2.jpg/ v4-728px-Insert-a-Watermark-in-Excel-Step-2.jpg”,”smallWidth”:460,”smallHeight”:350,”bigWidth”:728,”bigHeight”:554,”licensing”:” <div class=”mw-parser-output”></div>”}
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.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/37/Insert-a-Watermark-in-Excel-Step-3.jpg/v4-728px-Insert-a-Watermark- in-Excel-Step-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/3/37/Insert-a-Watermark-in-Excel-Step-3.jpg/ v4-728px-Insert-a-Watermark-in-Excel-Step-3.jpg”,”smallWidth”:460,”smallHeight”:341,”bigWidth”:728,”bigHeight”:540,”licensing”:” <div class=”mw-parser-output”></div>”}
Click the WordArt option in the Insert toolbar. This button has an ” A ” icon in italics towards the right. A list of available WordArt styles will appear in the pop-up window.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/52/Insert-a-Watermark-in-Excel-Step-4.jpg/v4-728px-Insert-a-Watermark- in-Excel-Step-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/52/Insert-a-Watermark-in-Excel-Step-4.jpg/ v4-728px-Insert-a-Watermark-in-Excel-Step-4.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:” <div class=”mw-parser-output”></div>”}
Choose a style for the watermark. Click the style that you want to select in the WordArt window that pops up. The new WordArt frame will be inserted into the worksheet.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/0c/Insert-a-Watermark-in-Excel-Step-5.jpg/v4-728px-Insert-a-Watermark- in-Excel-Step-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/0c/Insert-a-Watermark-in-Excel-Step-5.jpg/ v4-728px-Insert-a-Watermark-in-Excel-Step-5.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Edit the content in the WordArt text frame. Click the text in the WordArt frame and enter the text you want to use as the watermark.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/82/Insert-a-Watermark-in-Excel-Step-6.jpg/v4-728px-Insert-a-Watermark- in-Excel-Step-6.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/82/Insert-a-Watermark-in-Excel-Step-6.jpg/ v4-728px-Insert-a-Watermark-in-Excel-Step-6.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Right-click the WordArt frame. Right-click options will open in a pop-up menu.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/3c/Insert-a-Watermark-in-Excel-Step-7.jpg/v4-728px-Insert-a-Watermark- in-Excel-Step-7.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/3/3c/Insert-a-Watermark-in-Excel-Step-7.jpg/ v4-728px-Insert-a-Watermark-in-Excel-Step-7.jpg”,”smallWidth”:460,”smallHeight”:342,”bigWidth”:728,”bigHeight”:541,”licensing”:” <div class=”mw-parser-output”></div>”}
Choose Format Shape from the right-click menu. A menu of text and shape options will open.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/13/Insert-a-Watermark-in-Excel-Step-8.jpg/v4-728px-Insert-a-Watermark- in-Excel-Step-8.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/13/Insert-a-Watermark-in-Excel-Step-8.jpg/ v4-728px-Insert-a-Watermark-in-Excel-Step-8.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:545,”licensing”:” <div class=”mw-parser-output”></div>”}
Select the Spid fill located below the Text fill option. This option allows you to edit the transparency of the art text on the sheet background.
- On Excel 2015 and later, click the Text Options tab at the top of the menu pane to see the Text Fill options.
- On earlier versions, you click the Text Fill option located in the left menu of the Format window. Then click on the Spid tab at the top and choose a color.
- Or you can edit the outline of the text here. No Fill , Spid Fill or Gradient Fill are options for text borders used to change the transparency of the line.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/e0/Insert-a-Watermark-in-Excel-Step-9.jpg/v4-728px-Insert-a-Watermark- in-Excel-Step-9.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/e0/Insert-a-Watermark-in-Excel-Step-9.jpg/ v4-728px-Insert-a-Watermark-in-Excel-Step-9.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Increase the Transparency slider to 70%. Click and drag the Transparency slider to the right so that the WordArt watermark becomes relatively transparent against the sheet background.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/6b/Insert-a-Watermark-in-Excel-Step-10.jpg/v4-728px-Insert-a-Watermark- in-Excel-Step-10.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/6b/Insert-a-Watermark-in-Excel-Step-10.jpg/ v4-728px-Insert-a-Watermark-in-Excel-Step-10.jpg”,”smallWidth”:460,”smallHeight”:343,”bigWidth”:728,”bigHeight”:543,”licensing”:” <div class=”mw-parser-output”></div>”}
Edit the watermark property. 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 sheet.
- 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 bigger or smaller.
Add letterhead logo
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/e1/Insert-a-Watermark-in-Excel-Step-11.jpg/v4-728px-Insert-a-Watermark- in-Excel-Step-11.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/e1/Insert-a-Watermark-in-Excel-Step-11.jpg/ v4-728px-Insert-a-Watermark-in-Excel-Step-11.jpg”,”smallWidth”:460,”smallHeight”:349,”bigWidth”:728,”bigHeight”:553,”licensing”:” <div class=”mw-parser-output”></div>”}
Open the Excel file you want to edit. Proceed to open Microsoft Excel on your computer and double-click the file in the list of saved sheets.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/40/Insert-a-Watermark-in-Excel-Step-12.jpg/v4-728px-Insert-a-Watermark- in-Excel-Step-12.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/40/Insert-a-Watermark-in-Excel-Step-12.jpg/ v4-728px-Insert-a-Watermark-in-Excel-Step-12.jpg”,”smallWidth”:460,”smallHeight”:350,”bigWidth”:728,”bigHeight”:554,”licensing”:” <div class=”mw-parser-output”></div>”}
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.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/6f/Insert-a-Watermark-in-Excel-Step-13.jpg/v4-728px-Insert-a-Watermark- in-Excel-Step-13.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/6f/Insert-a-Watermark-in-Excel-Step-13.jpg/ v4-728px-Insert-a-Watermark-in-Excel-Step-13.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Click the Header & Footer button in the Insert toolbar. A header area will be created at the top and a footer at the bottom of the sheet.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/51/Insert-a-Watermark-in-Excel-Step-14.jpg/v4-728px-Insert-a-Watermark- in-Excel-Step-14.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/51/Insert-a-Watermark-in-Excel-Step-14.jpg/ v4-728px-Insert-a-Watermark-in-Excel-Step-14.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Click the Click to add header area at the top of the sheet. The Design toolbar will appear at the top.
- Depending on the version of Excel, this tag is also called Header & Footer .
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/19/Insert-a-Watermark-in-Excel-Step-15.jpg/v4-728px-Insert-a-Watermark- in-Excel-Step-15.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/19/Insert-a-Watermark-in-Excel-Step-15.jpg/ v4-728px-Insert-a-Watermark-in-Excel-Step-15.jpg”,”smallWidth”:460,”smallHeight”:349,”bigWidth”:728,”bigHeight”:553,”licensing”:” <div class=”mw-parser-output”></div>”}
Click Picture located in the toolbar. This option is located next to the Sheet Name button in the Design tab. A new window will appear allowing you to select an image to insert.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/15/Insert-a-Watermark-in-Excel-Step-16.jpg/v4-728px-Insert-a-Watermark- in-Excel-Step-16.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/15/Insert-a-Watermark-in-Excel-Step-16.jpg/ v4-728px-Insert-a-Watermark-in-Excel-Step-16.jpg”,”smallWidth”:460,”smallHeight”:346,”bigWidth”:728,”bigHeight”:548,”licensing”:” <div class=”mw-parser-output”></div>”}
Click Browse to browse through the entire file on the pop-up window.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/2e/Insert-a-Watermark-in-Excel-Step-17.jpg/v4-728px-Insert-a-Watermark- in-Excel-Step-17.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/2e/Insert-a-Watermark-in-Excel-Step-17.jpg/ v4-728px-Insert-a-Watermark-in-Excel-Step-17.jpg”,”smallWidth”:460,”smallHeight”:349,”bigWidth”:728,”bigHeight”:552,”licensing”:” <div class=”mw-parser-output”></div>”}
Select the icon image you want to insert. Find and click the file located in the pop-up to select it.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/81/Insert-a-Watermark-in-Excel-Step-18.jpg/v4-728px-Insert-a-Watermark- in-Excel-Step-18.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/81/Insert-a-Watermark-in-Excel-Step-18.jpg/ v4-728px-Insert-a-Watermark-in-Excel-Step-18.jpg”,”smallWidth”:460,”smallHeight”:349,”bigWidth”:728,”bigHeight”:552,”licensing”:” <div class=”mw-parser-output”></div>”}
Click the Insert button. The logo will be inserted at the top of the sheet.
- The selected icon will display in the header area at the top of each page.
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 2,818 times.
This wikiHow teaches you how to create and add a watermark or logo to an Excel worksheet file. You can use WordArt word art to create a transparent watermark on the sheet background, or insert a logo image to create letterheads at the top of the page.
Thank you for reading this post How to Insert watermark in Excel at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: