Excel water mark tutorial

Excel Watermark Tutorial con’t

Insert a Watermark in Excel
Insert a Watermark in Excel. © Ted French
Repositioning the Watermark

If desired, the watermark image can be moved downward to the middle of the worksheet as seen in the image above.

This is done by adding blank lines in front of the &[Picture} code using the Enter key on the keyboard.

To reposition the watermark:

If necessary, click on the Header & Footer icon on the Insert tab to enter Page Layout view
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
To check on the new position of the watermark image, click on any cell in the worksheet to leave the Header box area
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

To replace the original watermark with a new image:

If necessary, click on the Header & Footer icon on the Insert tab to enter Page Layout view
Click on the center header box to select it
The &[Picture} code for the watermark image in the box should be highlighted
Click on the picture icon
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
In the dialog box browse to find the replacement image file
Click on the image file to highlight it
Click on the Insert button to insert the new image and close the dialog box
Removing the Watermark

To remove a watermark entirely:

If necessary, click on the Header & Footer icon on the Insert tab to enter Page Layout view
Click on the center header box to select it
Press the Delete or Backspace key on the keyboard to remove the &[Picture} code
Click on any cell in the worksheet to leave the Header box area
The watermark image should be removed from the worksheet
Viewing the Watermark in Print Preview

Since headers and footers are not visible in Normal view in Excel you must switch views in order to see a watermark.

In addition to Page Layout view where the watermark image was added, the watermark can also be seen in Print Preview:

Note: You must have a printer installed on your computer to use Print Preview.

Switching to Print Preview

Click on the File tab of the ribbon
Click on Print in the menu
Your worksheet and watermark should appear in the preview panel on the right of the screen
Switching to Print Preview in Excel 2007

Click on the Office Button
Choose Print > Print Preview from the drop down menu
The Print Preview screen will open displaying the worksheet and watermark

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s