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

excel courses in london - watermark

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

excel courses in london - Watermark

ResolvedVersion 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:

Create your own custom list on Excel 2010!

If you know how to use the auto-fill option on Excel then why not create your own customs lists?

The auto fill feature saves you time by allowing you to enter one of the list entries into a cell and then use your mouse to automatically drag the rest of the list into the cells below, above or to either side of the initial cell. When using your mouse to perform this task you will see a thin black cross appear at the bottom right hand side of the cell. Click, hold and drag to make the list appear.

Default lists include weekdays and months. To create your own list in Excel 2010 do the following;

>File
>Options
>Advanced
>Scroll right to the bottom of the page and you will see a buttom "edit custom lists", click this button
>enter your list in the list entries
>click add

Now try it out. Good luck.
>

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.3 secs.