Buzz
Today, Mytour will guide you on how to create and add a watermark or logo to your Excel spreadsheet. You can use WordArt to design a transparent watermark over the worksheet background or insert a logo to create a letterhead at the top of the page.
Steps
Add WordArt to the Worksheet Background
Open the Excel file you want to edit. Launch Microsoft Excel on your computer and double-click the file from your list of saved spreadsheets.
Click on the Insert tab. This button is located between the Home and Page Layout tabs at the top-right corner of the screen. The Insert toolbar will appear at the top of the worksheet.
Click on the WordArt option in the Insert toolbar. This button features a slanted letter "A" to the right. A list of available WordArt styles will appear in a pop-up window.
Select a style for the watermark. Click on the style you prefer from the WordArt pop-up window. A new WordArt text box will be inserted into the worksheet.
Edit the text in the WordArt text box. Click on the text inside the WordArt box and enter the content you want to use as the watermark.
Right-click on the WordArt text box. A context menu with additional options will appear in a pop-up menu.
Select
Format Shape from the right-click menu. A menu with text and shape formatting options will appear.
Choose Solid fill under the Text Fill option. This allows you to adjust the transparency of the WordArt on the worksheet background.
- In Excel 2015 and later, click the Text Options tab at the top of the menu to access Text Fill settings.
- In earlier versions, click Text Fill in the left-hand menu of the Format window. Then, select the Solid tab at the top and choose a color.
- You can also modify the text outline here. Options like No Fill, Solid Fill, or Gradient Fill are available to adjust the transparency of the text outline.
Increase the Transparency slider to 70%. Click and drag the Transparency slider to the right to make the WordArt watermark relatively transparent on the worksheet background.
Adjust the watermark properties. You can modify the size, position, and orientation of the WordArt box to ensure the watermark meets personal or professional requirements.
- Click and drag the WordArt box to move the watermark around the worksheet.
- Click and rotate the circular arrow icon at the top of the box to change the angle and direction of the watermark.
- Double-click the text and adjust the font size in the Home tab to make the watermark larger or smaller.
Add a Letterhead Logo
Open the Excel file you wish to edit. Launch Microsoft Excel on your computer and double-click the file from your list of saved spreadsheets.
Click on the Insert tab located at the top-left corner of the menu bar, next to the Home button.
- In older versions, you may need to click on the View tab instead.
Click on the Header & Footer button in the Insert toolbar. A header section will be created at the top, and a footer section at the bottom of the worksheet.
Click on the Click to add header section at the top of the worksheet. The Design toolbar will appear above.
- Depending on your Excel version, this tab may also be labeled as Header & Footer.
Click on Picture 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.
Click on Browse to search through all available files in the pop-up window.
Select the logo image you want to insert. Locate and click on the file within the pop-up window to make your selection.
Click the Insert button. The logo will be added to the top of the worksheet.
- The selected icon will appear in the header section at the top of each page.
