This article explains how to insert a watermark on an Excel spreadsheet. It includes information on repositioning, removing, and replacing the watermark. These instructions apply to Excel 2019, 2016, 2013, 2010, 2007, Excel 2019 for Mac and Excel 2016 for Mac.
What to Know
- Select the Excel Insert tab. Choose Header & Footer > Picture. Choose the image and select Insert to display a &[Picture] code.Select any cell in the worksheet to exit the Header box and view the watermark image.
How to Insert a Watermark on an Excel Spreadsheet
Excel does not include a true watermark feature, but you can insert an image file into a header or footer to appear as a visible watermark. For visible watermarking, the information is typically text or a logo that identifies the owner or marks the media in some way.
You can add up to three headers in Excel. These headers, which become visible in Page Layout or Print Preview views, can act as watermarks for spreadsheets. Here’s how to add a watermark image.
- Click the Insert tab of the ribbon.
- Click Header & Footer in the Text drop-down menu on the ribbon.
- Click Picture in the Header & Footer Elements group of the Header & Footer Tools tab. The Insert Picture dialog box will open.
- Navigate to the image file that you want to use as your watermark. Click on the file to select and then click the Insert button to add it. The watermark image is not immediately visible but a &[Picture} code should appear in the center header box of the worksheet.
- Click any cell in the worksheet to leave the Header box area.
- The watermark image should now appear on the worksheet.
Removing the Watermark
You can also remove a watermark entirely.
Click the Insert tab of the ribbon.
Click Header & Footer in the Text drop-down menu on the ribbon.
Click Picture in the Header & Footer Elements group of the Header & Footer Tools tab. The Insert Picture dialog box will open.
Navigate to the image file that you want to use as your watermark. Click on the file to select and then click the Insert button to add it. The watermark image is not immediately visible but a &[Picture} code should appear in the center header box of the worksheet.
Click any cell in the worksheet to leave the Header box area.
The watermark image should now appear on the worksheet.
- Go to the Insert tab of the ribbon.
- Click Header & Footer in the Text group of the ribbon. Excel will switch to Page Layout view and the Header & Footer Tools tab will open on the ribbon.
- Click the center header box to select it.
- Press the Delete or Backspace key on the keyboard to remove the &[Picture} code.
- Click any cell in the worksheet to leave the Header box area.
Repositioning the Watermark
If desired, you can move the watermark image to the middle of the worksheet, as seen in the image above.
Go to the Insert tab of the ribbon.
Click Header & Footer in the Text group of the ribbon. Excel will switch to Page Layout view and the Header & Footer Tools tab will open on the ribbon.
Click the center header box to select it.
Press the Delete or Backspace key on the keyboard to remove the &[Picture} code.
- Go to the Insert tab of the ribbon.
- Click Header & Footer in the Text group of the ribbon.
- Click on the center header box to select it. The &[Picture} code for the watermark image in the box should be highlighted.
- Click in front of the &[Picture} code to clear the highlight and to position the insertion point in front of the code.
- Press the Enter key on the keyboard several times to insert blank lines above the image.
- The header box should expand and the &[Picture} code move downwards in the worksheet.
- Click on any cell in the worksheet to leave the Header box area and check on the new position of the watermark image. The watermark image’s location should update
- Add additional blank lines if necessary or use the Backspace key on the keyboard to remove excess blank lines in front of the &[Picture} code
Replacing the Watermark
You can replace an existing watermark with a new image, as well.
Click Header & Footer in the Text group of the ribbon.
Click on the center header box to select it. The &[Picture} code for the watermark image in the box should be highlighted.
Click in front of the &[Picture} code to clear the highlight and to position the insertion point in front of the code.
Press the Enter key on the keyboard several times to insert blank lines above the image.
The header box should expand and the &[Picture} code move downwards in the worksheet.
Click on any cell in the worksheet to leave the Header box area and check on the new position of the watermark image. The watermark image’s location should update
Add additional blank lines if necessary or use the Backspace key on the keyboard to remove excess blank lines in front of the &[Picture} code
- Go to the Insert tab of the ribbon.
- Click Header & Footer in the Text group of the ribbon.
- Click on the center header box to select it. The &[Picture} code for the watermark image in the box should be highlighted
- Click Picture in the Header & Footer Elements group of the Header & Footer Tools tab. A message box will open explaining that only one picture can be inserted into each section of the header.
- Click on the Replace button in the message box to open the Insert Picture dialog box.
- Browse to find the replacement image file.
- Click on the image file to highlight it.
- Click the Insert button to insert the new image and close the dialog box.
- Save the changes to your worksheet.
Click on the center header box to select it. The &[Picture} code for the watermark image in the box should be highlighted
Click Picture in the Header & Footer Elements group of the Header & Footer Tools tab. A message box will open explaining that only one picture can be inserted into each section of the header.
Click on the Replace button in the message box to open the Insert Picture dialog box.
Browse to find the replacement image file.
Click on the image file to highlight it.
Click the Insert button to insert the new image and close the dialog box.
Save the changes to your worksheet.
Get the Latest Tech News Delivered Every Day
