Sunday, July 1, 2018

Add a watermark in Excel

Add a watermark in Excel

Microsoft Excel doesn't come with a built-in watermark feature. However, there are a couple of ways that you can simulate the look of a watermark. In this topic we'll discuss how to create watermarks with images, like a company logo, and using an image as a worksheet background.

Excel does not support creation of text watermarks. Excel watermarks also do not support processes such as pasting in a block of text from Microsoft Word as a text watermark. You create the text you want for your watermark in a custom graphic in a standard picture file format such as .PNG, .JPG or .BMP, and import it into the Excel worksheet header. You can then use this picture as a watermark as many times as you want in your Excel worksheets.

  1. Use your preferred graphics program, such as Microsoft Paint, to create the picture file with the text you want to use as your watermark.

  2. In Excel, click Insert > Header & Footer. Excel changes to Page Layout View.

    Shows the Header & Footer button on the Insert tab.

  3. The Design tab appears under Header & Footer Tools.

    Excel Design toolbar breakout

  4. The header appears directly above Row 1 of the worksheet, in three sections.

    Shows the header above Row 1.

  5. Click inside the left, center or right section for the header. In the Design ribbon, click Picture.

    Shows the Picture button in the Design ribbon.

  6. In the dialog box, click Browse. Browse to the picture you want to use, and double-click it. In the header, you'll see &[Picture]. This means there's a picture in the header.

    Picture inserted in header

  7. Press the Tab key, or click anywhere outside the header. The company logo watermark appears in the currently displayed worksheet. When you create data on a new page in the same worksheet, the watermark appears on the new page.

    Company logo

    Notes: 

    • You may resize the watermark after you import it into Excel. In Page Layout mode, click the cursor in front of the "&" in &[Picture]. In the Design ribbon, click Format Picture. Use the Size tab to change the size of the watermark image on the worksheet. For other watermark settings, see the section Editing graphics properties for watermarks.

    • You'll see the watermark only when you're in Page Layout view or in Print Preview. The watermark also appears only on the current worksheet. You add a watermark to each worksheet in a workbook.

When you share printouts of a worksheet and want people to know it's not the final copy, you can add the word "DRAFT" to the background on all the printed pages of your worksheet.

Note: You'll see the watermark only when you're in Page Layout view or in Print Preview. The watermark also appears only on the current worksheet. You add a watermark to each worksheet in a workbook.

Draft

  1. Right-click this link (DRAFT), click Save picture as or Save target as..., and save the file to your computer. You can use this sample image for your watermark. )

  2. In Excel, click Insert > Header & Footer. Excel changes to Page Layout View.

    Shows the Header & Footer button on the Insert tab.

  3. The Design tab appears under Header & Footer Tools.

    Excel Design toolbar breakout

  4. The header appears directly above Row 1 of the worksheet, in three sections.

    Shows the header above Row 1.

  5. Click inside the left, center or right section for the header. In the Design ribbon, click Picture.

    Shows the Picture button in the Design ribbon.

  6. In the dialog box, click Browse. Browse to the picture you want to use, and double-click it. In the header, you'll see &[Picture]. This means there's a picture in the header.

    Picture inserted in header

  7. Press the Tab key, or click anywhere outside the header. The new "DRAFT" watermark appears in the currently displayed worksheet. When you create data on a new page in the same worksheet, the watermark appears on the new page. The watermark does not appear in other worksheets in the same workbook. Each worksheet requires its own watermark.

    DRAFT watermark

    Note: You may resize the watermark after you import it into Excel. In Page Layout mode, click the cursor in front of the "&" in &[Picture]. In the Design ribbon, click Format Picture. Use the Size tab to change the size of the watermark image on the worksheet. For other watermark settings, see the section Editing graphics properties for watermarks.

When you want worksheet printouts to reflect your company brand, you can add a company logo graphic as a watermark on all the printed pages of your worksheet.

Company logo

Note: You'll see the watermark only when you're in Page Layout view or in Print Preview. The watermark also appears only on the current worksheet. You add a watermark to each worksheet in a workbook.

  1. In Excel, click Insert > Header & Footer. Excel changes to Page Layout View.

    Shows the Header & Footer button on the Insert tab.

  2. The Design tab appears under Header & Footer Tools.

    Excel Design toolbar breakout

  3. The header appears directly above Row 1 of the worksheet, in three sections.

    Shows the header above Row 1.

  4. Click inside the left, center or right section for the header. In the Design ribbon, click Picture.

    Shows the Picture button in the Design ribbon.

  5. In the dialog box, click Browse. Browse to the picture you want to use, and double-click it. In the header, you'll see &[Picture]. This means there's a picture in the header.

    Picture inserted in header

  6. Press the Tab key, or click anywhere outside the header. The company logo watermark appears in the currently displayed worksheet. When you create data on a new page in the same worksheet, the watermark appears on the new page.

    Company logo

    Note: You may resize the watermark after you import it into Excel. In Page Layout mode, click the cursor in front of the "&" in &[Picture]. In the Design ribbon, click Format Picture. Use the Size tab to change the size of the watermark image on the worksheet. For other watermark settings, see the section Editing graphics properties for watermarks.

When you want people to know that your worksheet contains sensitive information that shouldn't be shared, add the word "CONFIDENTIAL" as a watermark on all the printed pages of your worksheet.

Confidential

Note: You'll see the watermark only when you're in Page Layout view or in Print Preview. The watermark also appears only on the current worksheet. You add a watermark to each worksheet in a workbook.

  1. Right-click this link (CONFIDENTIAL), click Save picture as or Save target as... , and save the file to your computer. This is the image you'll use for your watermark.

  2. In Excel, click Insert > Header & Footer. Excel changes to Page Layout View.

    Shows the Header & Footer button on the Insert tab.

  3. The Design tab appears under Header & Footer Tools.

    Excel Design toolbar breakout

  4. The header appears directly above Row 1 of the worksheet, in three sections.

    Shows the header above Row 1.

  5. Click inside the left, center or right section for the header. In the Design ribbon, click Picture.

    Shows the Picture button in the Design ribbon.

  6. In the dialog box, click Browse. Browse to the picture you want to use, and double-click it. In the header, you'll see &[Picture]. This means there's a picture in the header.

    Picture inserted in header

  7. Press the Tab key, or click anywhere outside the header. The new "CONFIDENTIAL" watermark appears in the currently displayed worksheet. When you create data on a new page in the same worksheet, the watermark appears on the new page.

    CONFIDENTIAL watermark

    Note: You may resize the watermark after you import it into Excel. In Page Layout mode, click the cursor in front of the "&" in &[Picture]. In the Design ribbon, click Format Picture. Use the Size tab to change the size of the watermark image on the worksheet. For other watermark settings, see the section Editing graphics properties for watermarks.

Background picture

You can quickly experiment with backgrounds for your Excel worksheet. Unlike watermarks, backgrounds are viewable in Normal View in your worksheet, and are invisible in Page Layout mode.

  1. Click Page Layout > Background.

  2. In the dialog box, click Browse.

  3. In the file requester, select the file you want to use and click Open.

    The image is automatically tiled on the background of the worksheet. Using this feature, the background is not inserted into the header section of the worksheet, which you do for a watermark.

    Notes: 

    • The background appears only on the current worksheet. If you want to use a watermark in the same worksheet as the background, the watermark appears over the background in your worksheet. Both the background and the watermark are visible (unless the watermark is the same size as the background image).

    • If the results of the background aren't what you want, click Page Layout > Remove Background.

You can change some basic graphics settings for watermarks, consisting of vertical centering for the watermark on the page, setting brightness and contrast, and sizing or scaling the watermark on the worksheet page. None of these settings apply to background graphics.

To define graphic properties for watermarks and backgrounds:

Centering the watermark

  1. In Excel, click Insert > Header & Footer. Excel changes to Page Layout View.

    Shows the Header & Footer button on the Insert tab.

  2. The Design tab appears under Header & Footer Tools.

    Excel Design toolbar breakout

  3. The header appears directly above Row 1 of the worksheet, in three sections. The watermark appears on the worksheet.

    Shows the header above Row 1.

  4. 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 vertically align it the way you want. No adjustments are possible from left to right.

    Place the cursor in the header this way

Setting brightness and contrast for the watermark

  1. In Page Layout view, select the header and make sure the cursor is in front of the "&" in &[Picture].

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

    Format background in Excel

  3. 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 to suit your taste. To keep the picture's optimal balance, make sure the two levels add up to 100%; for example, 80% and 20% or 67% and 33%.

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

Sizing or scaling the watermark

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

    Place the cursor in the header this way

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

    Format background in Excel

  3. On the Size tab, you can change the size of the picture by changing values in the Height and Width boxes. You can check or uncheck the Lock aspect ratio and Relative to original picture size boxes to control scaling.

Note: You'll see the watermark in Excel only when you're in Page Layout view or Print Preview. The watermark also appears only on the current worksheet. You add a watermark to each worksheet in a workbook.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

Change your organization's address, technical contact, and more

Change your organization's address, technical contact, and more

Contributors: Diane Faigel
Last updated 15 November, 2017

You can make changes to your Office 365 company profile, such as your organization name, address, phone, and technical contact. You must be a global admin to update this information.

I forgot the username or password for the account I use with Office.

To change the address or country associated with your bill or subscription, see Change your billing addresses for Office 365 for business.

Edit organization information

To change information on your company's profile page:

  1. Go to the Click here to go to the Office 365 admin center. .

    Go to the Office 365 admin center.

    Go to the Office 365 admin center.

  2. Select your organization's name in the top right corner of the page.

    Click the name of your business in the top right corner of the admin center.

  3. Choose Edit beside your organization's name.

  4. Update your organization's information and choose Save.

    An explanation of each field is provided below.

Field

Description

Name

The name entered here is what users will see on the following pages:

  • Sign-in page: If your users have set up other Microsoft accounts with their business or school email address, they may see the organization name on the sign-in page. This helps them distinguish between their work or school account and their other accounts, so they can identify which one to use when they sign in.

  • Organization profile link and page: The link to your organization's profile displays the organization name.

Address, City, State/Province, Postal code

The address entered here is what you will see on your bill, under Sold To: The Sold To address on your bill is the same as your organization address on your profile page (see Understand my bill for Office 365 for business).

Country or region

This is the country or region where the company is headquartered. The selected country or region determines which services are available to you, the taxes and billing currency for your country or region, and the location of the data center closest to you (see Microsoft Office license restrictions).

Note: Once selected, the country or region cannot be changed. If you want to change the selection, you'll have to cancel your subscription and sign up again. For help with this process, contact customer support.

Phone

This is the primary number for your company. It's usually the number of your company headquarters.

Technical contact

This is the email address for the primary technical person who administers your Office 365 subscription. This is the person who will receive communications about Office 365 service status.

Preferred language

The preferred language determines the language for all communications that are sent from Microsoft to your organization. When you sign up, this setting determines the language used by SharePoint Online, which your users see on your team site. If you change the language preference setting after you sign up, all future communications are sent in the most recent language selected.

Note:  The language used by SharePoint Online can't be changed.

Change your profile and email signature

  • Admin info   
    If you're an admin and want to change your alternate email address for resetting passwords or business email address, go to Settings Settings: update your profile, install software and connect it to the cloud and choose Office 365 under Your app settings.

  • User info   
    If you're a user and want to change your individual language preference, go to Settings Settings: update your profile, install software and connect it to the cloud > Office 365 settings.

For more information, see Change your contact preferences or Change your display language.

  • Email signatures   
    You can change your email signature in Outlook Web App. For more information, see Mail settings.

The short icon for LinkedIn Learning. New to Office 365?
Discover free video courses for Office 365 admins and IT pros, brought to you by LinkedIn Learning.

Print an Excel workbook from the browser

Print an Excel workbook from the browser

You can print an Excel workbook from the browser in two ways:

  • By using the Print command in Internet Explorer

  • By opening the workbook in Excel, and using the Print features there

Note:  This information applies only to an Excel workbook in a SharePoint environment. If you are using Excel Online in OneDrive, see Print a spreadsheet in Excel Online.

What do you want to do?

Print by using the Internet Explorer Print command

Print by opening the workbook and using the Print features in Excel

Print by using the Internet Explorer Print command

When you use the print features in Internet Explorer features, you can print only the information that appears on the screen. This print option does not include data that out of view, worksheets that are not currently displayed or named items that are not currently.

To print a page     

  • On the Internet Explorer command bar, click the Print button.

To preview how a page will look when it is printed    

  • Click the arrow to the right of the Print button, and then click Print Preview.

To change how a page appears on the printed page    

  1. Click the arrow to the right of the Print button, and then click Page Setup.

  2. Change the print settings that you want, such as Portrait or Landscape orientation, print size, margins, etc.

  3. When you finish changing the print settings, click OK.

  4. Click the Print button.

Top of Page

Print by opening the workbook and using the Print features in Excel

Office Excel 2007 and Excel 2010 offer many options and features for printing a workbook, such as printing a selected range of cells, changing print settings and print layout, or printing the complete workbook. When you open a workbook in Excel, you can use all these options.

To print a workbook by opening it in Excel, you must have Office Excel 2007 or Excel 2010 installed on your computer.

Top of Page

Change the information about a project (custom fields)

Change the information about a project (custom fields)

You can change the information about your project, such as the project name, the project owner, and the information in any custom fields that your organization has created to help describe a project.

Note: Some information about projects, such as the project calendar and cost information, can be changed only by using Microsoft Office Project Professional. To make those changes, select the project, and then click Open to open Project Professional. Update the project information, and then click Save on the File menu.

  1. On the Quick Launch, click Projects.

  2. Select the project, and then click Edit Project Properties.

  3. Under Basic Information, type a new project name and new owner.

  4. Your organization may require additional information about your project. Under Project Custom Fields, enter the information that your organization requires.

Why can't I perform some actions in Microsoft Office Project Web Access?

Depending on the permissions settings you used to log on to Project Web Access, you may not be able to see or use certain features. Also, what you see on some pages may differ from what is documented if your server administrator customized Project Web Access and did not customize the Help to match.

The duration of a task changed when I assigned a resource

The duration of a task changed when I assigned a resource

Symptoms

When you assign resources to a task, Microsoft Office Project 2007 calculates how long the task is likely to take to complete using those resources. If you assign multiple resources at the same time, the duration doesn't change from your original estimate. But if you assign additional resources to a task that already has an assignment, Office Project 2007 calculates how much less time it will take with these additional resources. This is known as effort-driven scheduling.

For example, if a task with a four-day duration is assigned to two resources, the duration stays at four days, and each resource is assigned to work on the task for four days. However, if you assign two additional resources, the duration decreases to two days because the duration is expected to be half as long with twice as many resources.

Resolution

Reset the duration to its previous value

  1. Select the task that you want to change.

  2. Click Assign Resources Assign Resources button image .

  3. In the Resource Name column, select the resource that you added to the originally assigned resources, and then click Remove.

Turn off effort-driven scheduling for an individual task

  1. Select the task that you want to change.

  2. Click Task Information Button image , and then click the Advanced tab.

  3. Clear the Effort driven check box.

Turn off effort-driven scheduling for all new tasks

  1. On the Tools menu, click Options.

  2. Click the Schedule tab.

  3. Clear the New tasks are effort driven check box.