excel courses in london - watermark
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

replyReply Thu 10 Jan 2008, 13:28Delegate Pauline said...

Pauline has attended:
Excel Intermediate course

Watermark

Can you use a watermark on spreadsheets?

For upcoming training course dates see: Pricing & availability

replyReply Mon 14 Jan 2008, 13:18Trainer Rajeev said...

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:

Enter formulae into multiple cells

If a formula is to be used in a series of cells, select the cells first. Now type in your formula and hold the Ctrl key while you press Enter. This enters the formula in each selected cell.

Just be careful with your absolute and relative cell references.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard