excel courses in london - watermark

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel courses in london - Watermark

excel courses in london - Watermark

resolvedResolved · Low Priority · Version Standard

Pauline has attended:
Excel Intermediate course

Watermark

Can you use a watermark on spreadsheets?

RE: watermark

Dear Pauline

Thank you for attending Excel Intermediate course.

Yes Watermarks can be used in Excel. It is known as Washout in Excel 2003 and 2007

If you simply want the picture that you wish you use for Washout on one page then follow these steps please:

Step 1: Insert > Picture > From File...
Step 2: Choose the location and the file that needs to be inserted e.g. Company logo
Step 3: Once the picture has been inserted double click on the picture and choose the picture tab on the top.
Step 4: In the image control section in the colordrop down list change from Automatic to washout
Step 5: Press OK.
Step 6: Drag and drop the picture at the appropriate place.

If you wish to place the picture as wash out in Header or footer so that it will appear on every page of the worksheet then please follow these steps:

Step 1: Go to Print Preview so that you can instantly see the changes you make.
Step 2: Click on the Setup... button at the top
Step 3: Click the Header/Footer tab at the top
Step 4: Click Custom Header or footer depending where you would like to place the picture.
Step 5: Click the Insert picture button on the top (it


 

Excel tip:

Shortcut fill a cell with contents from adjacent cells

Use Control + D to fill a cell with the data from an adjacent cell. This speeds up data entry and is a cool tip to share!


View all Excel hints and tips


Server loaded in 0.07 secs.