Microsoft Office 2016: The Complete Guide (2015)

ADD A WATERMARK IN EXCEL

Insert a “DRAFT” watermark on all printed pages.

Whenever printouts of a worksheet are shared and you want to notify persons that it is not the final copy, and the word “DRAFT” to the background of all printed pages.

Select the link labelled “DRAFT”, after which you should click Save>Save As to save to save the file to your computer. Please be aware that this is the image that will be used for your watermark.

In Excel, click Insert>Header & Footer.

Select [Design]>[Picture]

Select from file the picture that you saved in step 1, and double click it.

Inside the Header &Picture will appear which signifies that the picture is in the Header.

Select anywhere outside the Header box which should result in the “DRAFT” Watermark appearing.

If it is that you want the watermark to be strategically located that is placed at the center, top or bottom of the page. To achieve this, select the Header and make sure the cursor is in front if the “&” in &[Picture] then press Enter until you achieve the desired vertical alignment.

NOTE: As for Excel the watermark is only visible when you are in Page Layout View or Print Preview.

Insert a Company Logo as a Watermark on all Printed Pages.

In Excel, click Insert> Header & Footer.

Click [Design]> [Picture].

Click From File, search for the company logo pic that you want to employ and double-click it.

In the Header &Picture will appear. This signifies that a picture is present in the header.

If it is that you want the watermark to be located that is placed at the centre, top or bottom of the page. To achieve this, select the Header and make sure the cursor is in front if the “&” in & [Picture] then press Enter until you achieve the desired vertical alignment.

NOTE: As for Excel the watermark is only visible when you are in Page Layout View or Print Preview.

Insert a Background On All Printed Pages:

In Excel, select Insert> Header & Footer.

Click [Design]>[Picture]

Select from File and browse the image you prefer to use and double-click it.

In the Header &Picture will be displayed which indicates that a picture is in the header.

Select any region outside the header, to make the watermark visible.

If it is that you want the watermark to be strategically located that is placed at the center, top or bottom of the page. To achieve this, select the Header and make sure the cursor is in front if the “&” in & [Picture] then press Enter until you achieve the desired vertical alignment.

NOTE: As for Excel the watermark is only visible when you are in Page Layout View or Print Preview.

If you find that the watermark makes it difficult to see the typed data, you can lessen this effect by making it more transparent by increasing Brightness and Contrast.

To do this the following procedure is required:

Select the Header and make sure the header is in front of the “&” in “&Picture”.

Under the Header & Footer Tools select Design>Format Picture

On the Picture tab, under image control, select the option [Washout] in the Color-box this causes the brightness to be about 85% and contrast to 15%. This is not written in stone and so can be adjusted to your preference. Just ensure that both values measure up to give 100%. Examples include: 65% and 35% or 75% and 25%.

NOTE: As for Excel the watermark is only visible when you are in Page Layout View or Print Preview.

Looking for Something Else?

If any of the previously mentioned options are not are not what you want, then you can create your own watermark.

Select Insert> [Header, Footer].

Click Design>Picture.

Click from File choose the picture you would like and double-click it.

Click anywhere outside the header box. Your watermark should appear in the background.

To center the watermark between the top and bottom of the page, select the header and make sure the cursor is in front of the “&” in &[Picture]. Then press Enter as many times as it takes to get it vertically aligned the way you want.

To change the brightness and contrast of the picture:

Select the header and make sure the cursor is in front of the “&” in &[Picture].

Under Header & Footer Tools, click Design > Format Picture.

On the Picture tab, under Image control, choose Washout in the Color box—this sets the Brightness level to 85% and Contrast to 15%. You can adjust brightness and contrast however you want. To ensure that the picture looks its best, make sure the two levels add up to 100%; for example, 80% and 20% or 49% and 51%.

To change the size or scale of the picture:

Click the header and make sure the cursor is in front of the “&” in & [Picture].

Under Header & Footer Tools, select Design > Format Picture.

On the Size tab, you are given the ability to manipulate the size of the picture by adjusting values in the Height and Width boxes. You can either tick or don’t the Lock aspect ratio and Relative to original picture size boxes to control scaling.

Want to Correct a #Name? Error in Excel.

As this is very common problem Excel 2016 has found a way to address this re-occurring issue. This will appear when Microsoft is unable to detect names or text in a formula.

Various formula issues will cause the #Name? Error to be shown. These issues include:

A formula denotes a name that does not exist.

To rectify this, ensure that the name you use in the formula actually exist.

Select Formulas>Name Manager.

Validate that the name is listed. If it is not so, close the Dialog Box and then define the name [Formulas>Define Name].

A formula refers to a name that is misspelt.

To correct this, replace the reference with the correctly spelled name:

Select the cell with formula you want to examine for names that are spelled incorrectly.

In the formula, select the name that is wrongly spelled in the formula and select F3.

In the Paste name box, select the name you want to use then click OK.

The name of a function employed in a function that is misspelled.

To fix this, insert the correct function name in a formula:

Select the cell where the misspelled formula is located.

In the formula, select the misspelled function name.

In the Name Box (which is located to the left of the formula bar) select the arrow, and then select the function with the right name.

To have access to all functions select More Functions if needs be.

Assess the argument values and if accurate and consistent, click OK to complete the formula.

A formula that has a text entry that is missing Surrounding Double-quotation Marks (“”). To resolve this enter double quotation marks around the text entry in the formula.

A colon (:) that was omitted in a range reference. Fixing this is simple, just ensure that every formula has a colon.

A reference to another worksheet is not enclosed in single quotation marks. To rectify this place single quotation marks around worksheet references in a formula.

When the Euro Convert Function is employed in a Formula, however the Euro Currency Tools add-in that Excel Has Is Not Enabled.

To correct this, enable the add-in:

Select File>Option.

Select Add-Ins

Inside the Manage list box, choose Excel Add-ins and then Select Go.

Tick the Euro Currency tools box and then select OK.

TIP:- If error checking is enabled in excel you can select this icon which is located beside the cell that has the error. If “Show Calculation steps” is accessible, then select the resolution that is optimal for your data