Advanced Printer Setup dialog box

Use these options to control a wide range of printing tools, such setting up your printer with a wizard so you can easily print envelopes and two-sided publications, printing color plates separately, and including printer's marks.

Separations tab

Output

Select the settings that determine whether you print a composite or separations, which plates to print, and what resolution to print.

Print colors as     Select one of these options to specify the color model:

• Composite RGB     Select this option to print a composite whose colors are defined by the RGB color model. This is the recommended option for desktop printing.

• Composite Grayscale     Select this option to print a composite whose colors are defined as shades of gray.

• Composite CMYK     Select this option to print a composite whose colors are defined by the CMYK (cyan, magenta, yellow, black) color model.

  • For the CMYK option to be enabled, you must have a color PostScript Level 2 or later printer connected to your computer.

  • If you did not select a color printer in the Print dialog box and you select this option, a message appears to remind you to choose a color printer.

• Separations     Select this option to print a separate plate for each ink that is used in the publication.

  Note: If you select Separations, the Don't print blank plates and the Halftone Screen options are enabled.

  These plates     Select one of these options to define the inks that will be used in the printing process. Depending on the option that you select in this list, the Halftone Screen options will vary.

  Note: This option is enabled only if Separations is selected.

  • All defined inks     Select this option to print a separate plate for every ink that you defined for the publication, whether it is used or not.

  • Used inks only     Select this option to print separate plates for only those inks that are used in the publication.

  • Convert spot to process     Select this option to convert any spot colors used in the publication to their equivalent CMYK values and print these objects as part of the process color separations.

    Don't print blank plates     Select this check box to prevent printing plates for an ink that is used in the publication but not on a particular page. For example, when this check box is selected, Publisher prints only a black ink plate for a page that contains only black text. For pages that contain color photographs, Publisher prints cyan, magenta, yellow, and black ink plates.

Resolution     The options that are displayed vary, depending on your printer. For example, in addition to the (default) option, other resolutions can include 525 x 525, 600 x 600, 1200 x 1200, or 1800 x 1800. Typically, the resolutions in the list are in dots per inch (dpi). They can be in dots per centimeter (dpc), depending on your printer or imagesetter. The available resolutions depend on the printer driver that you are using. Printers have preset resolutions that can't be customized. Some printers allow printing at only one resolution.

Halftone Screen

Select the settings that determine the lines per inch (lpi). The settings vary, depending on which option you selected in the These plates list.

Note: These options are enabled only if Separations is selected.

Use custom settings below     Select this check box to set custom line screen angles and frequencies for process-color and spot-color plates. Depending on whether you selected All defined inks, Used inks only, or Convert spot to process, the Print plate, Frequency, and Angle options vary. Ask your commercial printer if you need to change the default options.

Print plate     Select the check boxes for the ink plates that you want to print.

Frequency     Enter a custom line screen frequency for all screens and halftones on any plate.

Angle     Enter a custom line screen angle for all screens and halftones on any plate.

The default frequency in Publisher is 133 lines per inch (lpi). The default angles in Publisher are the following:

• Black (K): 45 degrees.

• Cyan (C): 105 degrees.

• Magenta (M): 75 degrees.

• Yellow (Y): 90 degrees.

• Spot colors: vary depending on how many are used. Publisher prints the first spot color at 45 degrees. Other spot colors are printed at 105, 75, 30, 60, 90, 135, 15, 165, 120, and 0.

Reset this Tab

Clicking this button resets all the options on this tab to their default settings.

Page Settings tab

Set which printer's marks you want to be used. These marks are printed outside the page and are printed only if the size of the paper is larger than the page size of the publication.

Print output

Select the orientation and imaging of your output. You can see the effects of selecting these options under Sample.

Note: The following options are available with PostScript printers only:

• Flip vertically     Select this check box to print a vertically mirrored image of your publication. This option is most often used when printing to film on an imagesetter, so that the image reads correctly when the emulsion side of the film is down (as when burning a press plate).

• Flip horizontally     Select this check box to print a horizontally mirrored image of your publication. This option is most often used when printing to film on an imagesetter, so that the image reads correctly when the emulsion side of the film is down (as when burning a press plate).

• Negative image     Select this check box to print a negative image of your publication. This option is most often used when printing to film on an imagesetter, so that the image reads positive when burned onto a press plate.

Sample

This box displays an example of how the options that you select affect the pictures and text. For example, if you select Flip horizontally and Negative image, the Sample image displays a white animal running toward the left above text that is right aligned. The background paper will be black.

Bleeds

Choose whether to allow bleeds and display the amount of trim with bleed marks.

Note: The following options are available with PostScript printers only:

• Allow bleeds     Select this check box to let objects that extend past the edge of the page be printed up to 1/8 inch outside the page size. This check box is selected by default.

• Bleed marks     This check box is available only if Allow bleeds is selected. Select this check box to print bleed marks that show the extent of a bleed. Bleed marks are printed 1/8 inch outside the crop marks.

Printer's marks

Choose a variety of different printer's marks. These marks are printed outside the page and can be printed only if the size of the paper is larger than the page size of your publication.

Note: The Job information, Registration marks, and Density bars options are available only if you selected Composite Grayscale, Separations, or Composite CMYK under Output on the Separations tab. They are not available if you select Composite RGB.

• Crop marks     Select this check box to print marks that show where a page will be trimmed to the publication's intended size.

• Job information     Select this check box to print information on each plate about the print job. The job information includes the file name of your publication, the date it was printed, and the page number. If you are printing separations, the job information also includes which color ink the plate is for (cyan, magenta, yellow, black, or a spot color).

• Registration marks     Select this check box to print registration marks that will be used to align (register) the printing of two or more press plates on a single page.

• Density bars     Select this check box to print a density bar that is graded from a 10 percent screen to a 100 percent fill. A commercial printer will use this bar to determine the proper exposure time for plate burning and to test the dot gain on the printed pages.

• Color bars (CMYK and Separation only)     Select this check box to print a color bar that is used by a commercial printer to check how a solid patch of ink is printed on the page. This option is available only if the Separations or Composite CMYK option is selected on the Separations tab.

Mark style     Click an icon to select the mark style.

Graphics and Fonts tab

Select how fonts, picture resolution, and picture cropping and downsampling will be handled during printing.

Fonts

Use only publication fonts     Click this option to restrict your printer to use only the font version that is used in your publication.

Note: There are different versions of the same font. For example, even if you use a regular Times New Roman font, it may not be the exact same font that your desktop printer has built in. If you use the font versions that are provided by Publisher, the publication will be printed more predictably and often at a higher quality than if you allow font substitutions.

Allow printer to substitute fonts     Click this option to use your printer's resident fonts — whether in read-only memory (ROM), random access memory (RAM), or on a hard disk drive — that have the same name as the fonts that are used in your publication. Selecting this option may print your file faster because the file will be smaller, but your publication may look different.

Pictures

Print all pictures at full-resolution     Click this option to print the linked pictures as high-resolution graphics.

Print linked pictures at low-resolution     Click this option to print each linked picture by using the low-resolution placeholder graphic that is stored in the publication.

Do not print any pictures     Click this option to print a box in place of each picture. This option may be useful when you want to print a quick proof of the layout that shows only the positioning of pictures.

Note: This option replaces all inserted pictures, whether linked or embedded, as well as clip art. AutoShapes and border art will always be printed. Pictures that are used as fills in AutoShapes, text boxes, and WordArt will also be printed, as will pictures that are used as page backgrounds.

Crop and downsample pictures

These options are not available for commercial Composite RGB.

Note: To select Composite CMYK, you must have a color PostScript Level 2 or later printer selected in the Print dialog box.

Color and grayscale pictures     Select this check box for print quality, and then enter the dots per inch (dpi) range for the color and grayscale pictures. The default minimum and maximum will differ for each printing method. For example, the default minimum for high-quality printing is 300 dpi, and the default maximum is 450 dpi.

Line art (1 bit)     Select this check box for higher quality printing, and then enter the dots per inch (dpi) range for the line art. The default minimum is 1200 dpi, and the default maximum is 1500 dpi.

Reset this Tab     Click this button to reset all the options on this tab to their default settings.

Printer Setup Wizard tab

Select the options on this tab to set up your printer for manually printing envelopes or two-sided publications. You can select the options under Manual feed duplex to adjust the settings that the wizard collects.

Notes: 

• The first time that you print an envelope or two-sided publication without using the Printer Setup Wizard, a message will appear, asking whether you want to use the wizard to collect the printer's feed settings. If you click Yes, the wizard will set up your printer.

• If you have multiple printers, run the wizard to collect each printer's print settings before you use the printer.

Two-Sided Printing Setup Wizard

Click Two-Sided Printing Setup Wizard to start the six-step wizard that helps you to correctly print two-sided publications. The steps include identifying how your printer accepts paper and running a test to make sure that your publication is printed the way that you expect. After you run the wizard, it will automatically use the printer's settings for all your two-sided (duplex) printing tasks.

Note: 

• You must run the wizard for each new printer that you install before you print a two-sided publication.

• If you have a desktop printer that does not have duplex capabilities, run the Two-Sided Printing Setup Wizard, and then manually print your two-sided publication.

Manual feed duplex

After you run the Two-Sided Printing Setup Wizard, you can adjust the printer settings that were collected by the wizard so that you can manually print a two-sided publication.

Important: Do not change these settings unless you are an advanced user. Changing the settings may cause your print job to fail.

Feed from     

Select an option to indicate whether your printer feeds paper from a tray at the bottom or the top of your printer.

Feed the paper with the     

• Long edge     Select this option if your printer feeds paper along the long edge (landscape orientation).

• Short edge     Select this option if your printer feeds paper along the short edge (portrait orientation).

Paper sheet rotation     

• 0 Deg     Select this option if you can reinsert the paper in the same direction as the first side of the two-sided page.

• 180 Deg     Select this option if you need to rotate the paper horizontally 180 degrees before you reinsert it for two-sided printing.

Front side feeding     

• Face up    Select this option if your printer prints the page face up.

• Face down     Select this option if your printer prints the page face down.

Back side feeding     

• Face down     Select this option if your printer prints the page face down.

• Face up     Select this option if your printer prints the page face up.

Back side print order     

• Reverse     Select this option to print your publication in reverse (the mirror effect).

• Normal     Select this option to print your publication normally.

Envelope Setup Dialog

Click the Envelope Setup Dialog button to display the Envelope Setup dialog box, which you can use to print envelopes.

For more information about the Envelope Setup dialog box, see Envelope Setup dialog box.

Reset this Tab

Clicking this button resets only the Manual feed duplex and Envelope Setup dialog box options. It does not reset the Two-Sided Printing Setup Wizard options.

View and add documents to your project workspace site

Before you add a document to a document library, a workspace site needs to be created for your project. Typically, a workspace site for your project is automatically created when you first publish a project, but if this hasn't happened, ask your server administrator about creating a workspace site for your project. Some workspace sites may need to be manually created by an administrator.

1. On the Quick Launch, click Projects.

2. Select the project for which you want to add a document to its workspace site, click Go To, and then click Documents.

   A new window opens displaying a list of document libraries for the selected project. By default, all projects have a document library called Project Documents. If you can't locate it, it may have been renamed or deleted.

3. To add documents to the document library, click Project Documents.

4. To create a new document for the library, on the New menu, click New Document, and then edit and save the document in the directory indicated in the Save As dialog box. If you save the document to a different folder, it won't be included in the document library until you upload it later.

   When you save a document for the first time, you may be asked to provide additional information to help others work with the document, such as the document owner's name and the status of the document.

   Note: To create a new document, you must have the 2007 Microsoft Office system installed.

5. To upload an existing document, on the Upload menu, click Upload Document.

6. Click Browse to find the file that you want to add, select the file, and then click Open.

7. To replace an existing file with a revised file, in the Upload Document section, select the Overwrite existing file(s)? check box.

   Tip: To upload multiple documents, click Upload Multiple Files.

8. On the next page, select the documents that you want to upload, and then click OK. The document will be added to the document library, and you will return to the Project Documents page.

   On the Project Documents page, you can create additional documents or close the window and return to the Project Center.

Tip: After you add documents to a project workspace site, they can be linked to project issues, risks, and project tasks.

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.

Top of Page

About accessibility features in Business Contact Manager

Business Contact Manager for Outlook includes features that make the software usable for people with special needs and disabilities. Keyboard shortcuts offer access to most of the same features that you could navigate to with a computer mouse, for example. You can also adjust your visual display for improved readability.

The Ribbon, displayed at the top of windows and forms, is part of the Microsoft Fluent user interface, which makes it easier for people to use Microsoft Office programs. For example, the Ribbon offers quick access to many of the most common tasks that users want to complete, without additional menus and dialog boxes.

Keyboard shortcuts

Many features and commands for Business Contact Manager for Outlook are accessible directly from the keyboard, including a shortcut to Business Contact Manager, by pressing CTRL + 9. Switch between tabs on a workspace by pressing ALT + TAB, and press TAB to move from field to field on a form.

In the workspaces and forms, press the ALT key to see your keyboard options on the screen. Using the keyboard shortcuts, you must always select a tab on the Ribbon, even if it is already displayed, to view the additional keyboard shortcuts available in the selected tab. In other words, if the Home tab is displayed on the Ribbon when you first open Business Contact Manager for Outlook, you still must press ALT + H to select the Home tab and display the keyboard shortcuts on that tab.

Keyboard shortcuts in Business Contact Manager for Outlook that require you to press two keys are all sequential. None of them require simultaneous key presses.

For more information, see Keyboard shortcuts in Business Contact Manager.

Visual display features

You can increase the size of text in Business Contact Manager for Outlook forms. You can also change the font and style of text in these forms and views to make them easier to read. If you use the Windows High Contrast setting, e-mail messages that you compose will be shown in Rich Text Format.

Note:  To open Accessibility Options, open your Control Panel, and then, in Category View, double-click Ease of Access.

Choose the languages you want to make available for a site's user interface

As a site collection administrator, you can use the Multiple Language User Interface (MUI) feature to offer individual users the ability to change the display language for their site's or to create sites in different languages than the default SharePoint language. For more information about MUI and multi-language websites, see Introduction to multilingual features.

Important:  MUI changes the display language for the user interface, and variations supports creating multiple versions of content that you can then have translated using machine translation services or localization professionals. There is limited support of MUI for custom user interface (UI) elements. To learn more about variations, see Create a multi-language website.

You must be signed in as a site collection administrator to choose language settings for a site. In addition, the SharePoint Server farm administrator must first deploy language packs on your SharePoint Server. By default, language packs are already deployed and available to Office 365 customers using SharePoint Online.

1. From a site page, click the icon for Settings , and then click Site Settings.

2. On the settings page, in the Site Administration section, click Language Settings.

3. In the Alternate Language section, check the checkbox for the languages you want users to be able to use to display their user interfaces. For example, if the only language pack installed is French, then French is the only alternate language available for you to select.

4. Click OK.

Now your users can change the display language for their personal use of the user interface; see Change your language and region settings.

After you turn on alternate languages for your site, you can create new lists or libraries in one language, then display the site in a different language, and modify the list or library name for that language. The same process works for list and library columns, and for navigation links.

Note: .List items are considered content and not UI, so they will change when you choose an alternate display language.

Make sure the language packs you need are installed

For SharePoint Server or SharePoint Foundation

The list of available languages from which users can select the display language of their user interface is generated by the language packs that are installed on the server computers for your organization's SharePoint installation. These language packs must be installed by a server farm administrator—that is, someone in your IT organization who has the appropriate permission levels to download language packs onto your organization's server computers.

For SharePoint Online

If you're an Office 365 administrator, language packs are already deployed and MUI is enabled by default so that you can read the SharePoint Online Administration Center in your preferred language. If you're a SharePoint Online site administrators you won't get MUI enabled on your site by default. You'll need to select the preferred alternate languages for your site after the site has been created.

What is a site's user interface?

The user interface of your site refers to the elements on your screen that you use to interact with SharePoint, such as the menus, the navigation items, and the recycle bin.

With the MUI feature, you can display the following user interface elements in different languages:

• Web parts

• Site title and description

• SharePoint default menus and actions

• Default columns

• Custom columns (list or site)

• Navigation bar links

• Managed metadata services

Use MUI when you want to create sites, site collections, or Web pages in a language other than the default language for your installation, or, if your site will have users who cannot work in the default language that you plan to use for the site.

Top of Page

Design a form to respond to a workflow status

You can design Microsoft Office InfoPath forms to display specific data that corresponds to the current status of a workflow. You do this by designing a form template to use rules that initiate an action in its forms based on the status of the workflow. This can streamline the processes that people use to fill out forms.

This article describes how to design an expense report form template to automatically display different views of the form template, depending on the status of an associated Approval workflow. For example, before the workflow is started, the form will display an Expenses view that contains a repeating table where users can enter expenses. When the workflow status is In Progress, the form will display an Expense Summary view that shows the total expenses in each category. When the workflow status is Completed, the form will display the Completed view, which includes details on estimated reimbursement times.

To enable forms to respond to workflow statuses, you must perform tasks on the Microsoft Office SharePoint Server 2007 site or Windows SharePoint Services 3.0 site, where the forms are located, and tasks in InfoPath. On the SharePoint site you must create a workflow and a site content type, and in InfoPath you must add a data connection to a form template, create a rule, and publish the form template.

Note: This article uses an example scenario in which a form template is published as a site content type. You can also publish a form template to a shared network location or create a new document library when you publish a form template to a SharePoint site. Find more information about publishing form templates in the See Also section.

In this article

Introduction to using workflows with InfoPath forms

Compatibility considerations

Before you begin

Step 1: Add an Approval workflow to a library

Step 2: Add a data connection to a form template

Step 3: Add a rule to a form template to display a specific view

Step 4: Publish a form template as a site content type

Step 5: Add a content type to a document library

Introduction to using workflows with InfoPath forms

Workflows help people collaborate on documents and manage project tasks by implementing specific business processes on documents and items in a Microsoft Office SharePoint Server 2007 site or Windows SharePoint Services 3.0 site. Workflows help organizations adhere to consistent business processes, and they also improve organizational efficiency and productivity by managing the tasks and steps involved in specific business processes. This lets the people who perform these tasks concentrate on performing the work rather than managing the workflow.

You can enable an InfoPath form to display specific data that corresponds to the current status of a workflow. You do this by designing a form template to use rules that initiate an action in the form based on the status of the workflow. This can streamline the processes that people use to fill out forms. For example, you can enable a form to display a read-only view when the status for a workflow is Complete and, therefore, the data in the form should not be changed.

Workflows must be added to a SharePoint list, library, or content type to make them available for use on InfoPath form templates. The available workflows for a site also vary depending on the type of site and whether custom workflows were created by using Microsoft Office SharePoint Designer 2007.

This article uses the Approval workflow to illustrate how workflows can be used with InfoPath form templates. The Approval workflow routes an InfoPath form that is saved to a library to a group of people for approval. By default, the Approval workflow is associated with the Document content type and is automatically available in document or form libraries.

Each workflow is defined by distinct statuses with descriptive names, such as In Progress. The names for statuses vary according to the type of workflow. For example, an Approval workflow — which is available on servers running Microsoft Office SharePoint Server 2007 — includes a status for In Progress, Canceled, and Completed. The statuses of a Three-state Workflow — which is available in Windows SharePoint Services 3.0 — can be defined by the person who adds the workflow to a library or list, whereas other workflows use standard statuses such as the In Progress status noted previously. Although the descriptive name is visible to the user, workflow statuses are represented programmatically by numeric values. To design a form template to respond to a specific workflow status, you must know the numeric value for the workflow status that you want to use. This is because InfoPath uses the numeric value of the workflow to initiate an action, such as switching views.

As noted earlier, you can enable an InfoPath form template to display specific data that corresponds to the current status of a workflow. Although this article describes how to enable an expense report form template to automatically display a specific view depending on its status in the workflow, you can also customize the workflow by adding additional actions. For example, instead of enabling forms to display a specific view, you can enable them to display a dialog box message that shows instructions. And instead of using an Approval workflow, you can use the Three-state workflow.

Note: If you enable actions other than those described in this article, you may need to perform additional steps to help ensure that your form template works correctly with the workflow that you use.

Top of Page

Compatibility considerations

If you plan to create a browser-compatible form template, keep in mind that the document action bar, which is visible when filling out forms in Microsoft Office documents, including InfoPath forms, is not visible in browser-compatible form templates that users fill out in a Web browser. However, you can still use browser-based forms with workflows. To change the workflow status for such forms, workflow participants can use the document library settings. Find more information about changing workflow settings by using SharePoint sites in the See Also section.

Top of Page

Before you begin

Ensure the following before performing the tasks in this article:

• Contact the farm administrator to confirm that the Approval workflows is installed and enabled for the SharePoint site that you want to use.

• Ensure that you have at least a Design permission level for the SharePoint site. This permission level is necessary to publish a form template and to create a workflow.

• Create a form template with two or more views, and customize each view to display the type of data that is appropriate for each workflow status. For example, for the view that you want to appear when the workflow is completed, you can set the controls in that view to read-only.

• Create a document or form library, and make sure that the library is set up to allow multiple content types.

Top of Page

Step 1: Add an Approval workflow to a library

This scenario focuses on the Approval workflow, but you can use another workflow type if you want. If you use another workflow type, the options for that workflow may differ from those described in this article.

1. Open the library to which you want to add a workflow.

2. On the Settings menu, click the settings for the type of library that you are opening.

   For example, in a document library, click Document Library Settings.

3. Under Permissions and Management, click Workflow settings.

4. Click Add a workflow.

5. On the Add a Workflow page, in the Workflow section, click Approval.

6. In the Name section, type a unique name for the workflow.

   1. In the Task List section, specify a tasks list to use with this workflow.

      Notes: 

      • You can use the default Tasks list or you can create a new one. If you use the default Tasks list, workflow participants will be able to find and view their workflow tasks easily by using the My Tasks view of the Tasks list.

      • If the tasks for this workflow will reveal sensitive or confidential data that you want to keep separate from the general Tasks list, you should create a new tasks list.

      • If your organization will have numerous workflows or if workflows will involve numerous tasks, you should create a new tasks list. In this instance, you might want to create tasks lists for each workflow.

7. In the History List section, select a history list to use with this workflow. The history list displays all of the events that occur during each instance of the workflow.

   You can use the default History list or you can create a new one. If your organization will have numerous workflows, you can create a separate history list for each workflow.

8. To allow the workflow to be started manually, select the Allow this workflow to be manually started by an authenticated user with Edit Items Permissions check box in the Start Options section.

9. To require additional permissions to start the workflow, select the Require Manage Lists Permissions to start the workflow check box.

10. Specify any other options that you want, including when you want the workflow to start, and then click Next.

11. On the Customize Workflow page, specify the options that you want, including how tasks are routed, the default workflow start values, and how the workflow is completed, and then click OK.

    Select options in any of the following sections. You are not required to specify options in every section:

    Workflow Tasks

    To	Do this
    Assign tasks to all participants at once (parallel workflow)	Select All participants simultaneously (parallel).
    Assign tasks to one participant at a time, requiring that one participate complete a task before the next participant receives a task (serial workflow)	Select One participant at a time (serial).
    Allow workflow participants to reassign their tasks to other people	Select the Reassign the task to another person check box.
    Allow workflow participants to request a change to the document or item. The change must be approved before the task is completed.	Select the Request a change before completing the task check box.

    Default Workflow Start Values

    To	Do this
    Specify a default list of participants for all instances of this workflow	Type the names of the participants who you want to include when the workflow starts, or click Approvers and then select people and groups from the directory service. Notes:  Separate names with semicolons. If you set up this workflow as a serial workflow, add the names of the workflow participants in the order in which you want the tasks to be assigned.
    Assign a single task to groups, instead of assigning individual tasks for every group member	Select the Assign a single task to each group entered (Do not expand groups) check box.
    Allow people who start the workflow to change or add participants	Select the Allow changes to the participant list when this workflow is started check box.
    Specify a default message that appears with each task	Type a message or instructions in the text box.
    Specify a due date for parallel workflows	Enter a date under Tasks are due by (parallel).
    Specify how long serial workflow participants have to complete workflow tasks	Under Give each person the following amount of time to finish their task (serial), type a number, and then select Day(s) or Week(s) as the increment of time.
    Specify a list of people who should receive alerts (not task assignments) when the workflow is started	Under Notify Others, type the names of the people you want to be notified, or click CC and select people and groups from the directory service. Note: Separate names with semicolons.

    Complete the Workflow

    To	Do this
    Specify that a parallel workflow is complete when a specific number of participants complete their tasks	Select the Following number of tasks are finished check box, and then type a number.
    Specify that a workflow is complete when the document or item is rejected	Select the Document is rejected check box.
    Specify that a workflow is complete when the document or item is changed	Select the Document is changed check box.

    Post-completion Workflow Activities

    To

    Do this

    Update the approval status for a document or item after the workflow is complete

    Select the Update the approval status (use this workflow to control content approval) check box. Notes:  If you are using the Approval workflow to manage content approval for a library, and you selected the Start this workflow to approve publishing a major version of an item check box on the Add a Workflow page, this check box is selected by default. If you did not select the Start this workflow to approve publishing a major version of an item check box on the Add a Workflow page because you do not want this workflow to be the default content approval workflow for a library, you can select this check box to make this workflow a secondary content approval workflow that specific users can start manually.

Top of Page

Step 2: Add a data connection to a form template

The following procedure explains how to add a secondary data connection that queries the workflow status of the workflow that you added in Step 1. This secondary data connection provides the data that enables rules in the form to switch views according to the status of the workflow.

1. In InfoPath, on the Tools menu, click Data Connections.

2. In the Data Connections dialog box, click Add.

3. In the Data Connection Wizard, click Create a new connection to, click Receive data, and then click Next.

4. On the next page of the wizard, click SharePoint library or list, and then click Next.

5. On the next page of the wizard, type the URL of the SharePoint site.

6. In the Select a list or library list, click the name of the document library where you added the Approval workflow in Step 1, and then click Next.

7. On the next page of the wizard, in the Select fields list, select the check box next to the name of the field that matches the workflow name.

   The name of the field might not match the workflow name exactly. If the field name begins with a special character other than an underscore or a letter, the name of the workflow will be customized in the list.

8. Select the Include data for the active form only check box, and then click Next.

9. Clear the Store a copy of the data in the form template check box, and then click Next.

10. On the next page of the wizard, in the Enter a name for this data connection box, type a descriptive name for this secondary data connection. This name is what appears in the Data source list in the Data source task pane.

11. To run the query automatically, whenever the form is opened by a user, select the Automatically retrieve data when form is opened check box.

12. On the last page of the wizard, click Finish.

13. In the Data Connections dialog box, click Close.

Top of Page

Step 3: Add a rule to a form template to display a specific view

When you design a form template, you can use rules to automatically display a dialog box, set a field's value, query or submit form data to a data connection, switch views, or open or close a form in response to certain events and conditions. The events can include a change to a particular field or group in the data source, the click of a button, the insertion of a repeating section or row in a repeating table, or the opening or submission of a form. The conditions can include calculations, XPath expressions, and user roles. The conditions can also include whether the value of a field is blank, is within a specified range, equals the value of another field, or starts with or contains certain characters.

In this case, you will create a rule to switch views based on the workflow status.

1. On the Tools menu, click Form Options.

2. In the Category list, click Open and Save.

3. Under Open behavior, click Rules.

4. In the Rules for Opening Forms dialog box, click Add.

5. In the Name box, type a name for the rule.

   For example, type Switch Views.

6. To specify a condition when the rule should run, click Set Condition.

7. Under Apply the rule when this condition is true, in the first box, click Select a field or group.

8. In the Data Source list, click the name of the secondary data source that you added in Step 2, and then click OK.

9. Click the name of the field that corresponds to the workflow status.

   You may need to expand the folders in the window until you see the field that you want.

10. In the Condition dialog box, in the second list, click is equal to.

11. In the third list, click Type a number, and then type the value that corresponds to the workflow status.

    For example, for a view that displays when the workflow is completed, type 5.

    Numeric values for workflow statuses in the Approval workflow

    Status	Numeric value
    In Progress	2
    Completed	5
    Canceled	15
    Approved	16
    Rejected	17

    Notes: 

    • The numeric values for statuses in other workflows may differ.

    • The value of the workflow status in InfoPath is read-only. This means that you can't design a form template so that a user can manually change the status of the workflow by entering a value into a control on the form itself.

12. Click OK.

13. In the Rule dialog box, click Add action.

14. Under Action, click Switch views.

15. Under View, click the name of the view that you want to display when the workflow status matches the status for this condition, and then click OK.

    For example, if you typed 2 in step 11, click the name of the view that you want to display when the workflow status is equal to In Progress.

16. In the Rule dialog box, click OK.

17. Repeat steps 4 through 16 to create additional rules to switch appropriate views at each stage in the workflow.

Top of Page

Step 4: Publish a form template as a site content type

When you publish a form template, you can either publish it to a document library or publish it as a site content type that can be used in multiple document libraries across a site collection. Because you already created a document library and assigned a workflow to it, you must publish the form template as a content type. Later, you can associate the form template's site content type to the library that you created.

In addition to publishing a form template as a site content type, you can also publish a form template to a shared network location or create a new document library, when you publish a form template to a SharePoint site. Find more information about publishing form templates in the See Also section.

1. On the File menu, click Save.

2. In the Save As dialog box, browse to the location where you want to save the form template, and then click Save.

3. To open the Design Checker task pane, click Design Checker on the Tools menu.

4. If there are errors listed the Design Checker task pane, fix those errors, and then click Refresh to determine if the errors still exist.

5. On the File menu, click Publish.

6. In the Publishing Wizard, click To a SharePoint server with or without InfoPath Forms Services, and then click Next.

7. On the next page of the wizard, in the Enter the location of your SharePoint or InfoPath Forms Services site box, type the location of the SharePoint site where you want to publish your form template, and then click Next.

8. To allow users to fill out this form by using a Web browser, on the next page of the wizard, select the Enable this form to be filled out by using a browser check box.

9. Click Site Content Type (advanced), and then click Next.

10. On the next page of the wizard, click Create a new content type.

11. In the Base the content type on list, click Form, and then click Next.

12. On the next page of the wizard, type a name and description for the new content type, and then click Next.

13. On the next page of the wizard, in the Specify a location and file name for the form template box, type the location of the SharePoint site, and then click Browse.

14. In the Browse dialog box, browse to the location on the server where you want to publish the form template as a site content type, and then in the File name box, type the name of the form template, and click Save.

15. Click Next.

16. Choose the fields in the form template that you want to appear as columns in the default view of the document library.

    How?

    1. Click Add.

    2. Select the field that you want to add as a column in the document library, and then do one of the following:

       • Type a name for the column in the Column name box.

       • Select the site column in the Site column group list, select a name in the Column name list, and then click OK.

         If you selected a repeating field to display data in the document library, you can define how you want to display the field in the document library by clicking a value in the Function list. You can choose whether to display the first value in the field, the last value in the field, or a count of all of the occurrences of the field, or whether to merge all of the values together.

    3. Click OK.

17. Click Next.

18. On the next page of the wizard, verify that the information shown is correct, and then click Publish.

19. Click Close, and then verify that your form template is a content type on the SharePoint site.

    How?

    1. Open the SharePoint site in a Web browser.

    2. On the Site Actions menu in the upper-right corner of the site, click Site Settings.

    3. In Site Settings, under Galleries, click Site content types.

       Your form template should be listed under InfoPath Content Types in the Site Content Type Gallery.

Top of Page

Step 5: Add a content type to a document library

Content types make it possible for organizations to organize, manage, and handle content more effectively across a site collection. By defining content types for specific kinds of documents, an organization can ensure that each of these groups of content is managed more effectively. You can set up a list or library to contain items of multiple item types or document types by adding content types to the list or library.

Note: To add content types to a list or library, you need at least the Design permission level for that list or library.

Before you begin, make sure that the library is set up to allow multiple content types.

Allow multiple content types

1. On the Settings menu, click Document Library Settings.

2. Under General Settings, click Advanced settings.

3. In the Content Types section, select Yes to allow multiple content types, and then click OK.

1. If the list or library is not already open, click its name on the Quick Launch.

   Note: If the name of your list or library does not appear, click View All Site Content, and then click the name of your list or library.

2. On the Settings menu, click Document Library Settings.

3. Under Content Types, click Add from existing site content types.

4. In the Select site content types from list in the Select Content Types section, select the group of site content types from which you want to select.

5. In the Available Site Content Types list, click the content type that you want, and then click Add to move the selected content type to the Content types to add list.

6. To add additional content types, repeat steps 4 and 5, and then click OK.

Now, when a user creates a new form in this library, the view of the form will display according to the status of the workflow.

Top of Page

Use sections in a PowerPoint 2016 for Mac presentation

By using sections, you can organize many slides into manageable groups. If you are working with many slides or collaborating with other people to create a presentation, you can use sections to quickly change the order of slides or group slides by author.

Note: You can add or change the order of sections in Slide Sorter view, or in the navigation pane in Normal view. However, sections do not appear in Outline view.

Add a section

1. In Normal view, in the navigation pane, click the slide that will be the first slide of the section.

2. On the Home tab, under click Section , and then click Add Section.

3. In the Section Name box, enter a name for the section, and then click Rename.

4. To add more sections, select a new starting slide for the new section and repeat steps 2 and 3.

   

   The names you enter appear as headers above each section, followed by the number of slides in each section in parentheses.

Tip: Click the arrows next to the section names to collapse and expand sections.

Change the order of sections

• In Normal view or Slide Sorter view, drag the section title to where you want it—for example, move the third section before the first section.

Change the name of a section

• In Normal view or Slide Sorter view, double-click the section name and enter a new name in the Section Name box.

Create an outline from a numbered list

Turn a numbered one-level list into a multi-level outline by changing the levels of individual items in the list.

1. Click any numbered line that you want to promote or demote to a different level.

2. Click Home, click the arrow next to Numbering, and then click Change List Level.

   

3. Click the level that you want.

   The line you selected will be promoted or demoted to that level.

4. To complete the outline, repeat steps 1-3 for every listed item that you want to move to a different level.

Excel specifications and limits

Excel 2016-2013 Excel 2010 Excel 2007



Worksheet and workbook specifications and limits

Feature	Maximum limit
Open workbooks	Limited by available memory and system resources
Worksheet size	1,048,576 rows by 16,384 columns
Column width	255 characters
Row height	409 points
Page breaks	1,026 horizontal and vertical
Total number of characters that a cell can contain	32,767 characters
Characters in a header or footer	255
Sheets in a workbook	Limited by available memory (default is 1 sheet)
Colors in a workbook	16 million colors (32 bit with full access to 24 bit color spectrum)
Named views in a workbook	Limited by available memory
Unique cell formats/cell styles	64,000
Fill styles	256
Line weight and styles	256
Unique font types	1,024 global fonts available for use; 512 per workbook
Number formats in a workbook	Between 200 and 250, depending on the language version of Excel that you have installed
Names in a workbook	Limited by available memory
Windows in a workbook	Limited by available memory
Hyperlinks in a worksheet	66,530 hyperlinks
Panes in a window	4
Linked sheets	Limited by available memory
Scenarios	Limited by available memory; a summary report shows only the first 251 scenarios
Changing cells in a scenario	32
Adjustable cells in Solver	200
Custom functions	Limited by available memory
Zoom range	10 percent to 400 percent
Reports	Limited by available memory
Sort references	64 in a single sort; unlimited when using sequential sorts
Undo levels	100
Fields in a data form	32
Workbook parameters	255 parameters per workbook
Items displayed in filter drop-down lists	10,000
Noncontiguous cells that can be selected	2,147,483,648 cells
Maximum limits of memory storage and file size for Data Model workbooks	32-bit environment is subject to 2 gigabytes (GB) of virtual address space, shared by Excel, the workbook, and add-ins that run in the same process. A data model's share of the address space might run up to 500 – 700 megabytes (MB), but could be less if other data models and add-ins are loaded. 64-bit environment imposes no hard limits on file size. Workbook size is limited only by available memory and system resources. Excel 2016 offers the Large Address Aware functionality that lets 32-bit Excel 2016 consume twice the memory when users work on a 64-bit Windows operating system. For more information, see Large Address Aware capability change for Excel. Note:  Adding tables to the Data Model increases the file size. If you don't plan to create complex Data Model relationships using many data sources and data types in your workbook, uncheck the Add this data to the Data Model box when you import or create tables, pivot tables, or data connections. For more information, see Data Model specification and limits.

Calculation specifications and limits

Feature	Maximum limit
Number precision	15 digits
Smallest allowed negative number	-2.2251E-308
Smallest allowed positive number	2.2251E-308
Largest allowed positive number	9.99999999999999E+307
Largest allowed negative number	-9.99999999999999E+307
Largest allowed positive number via formula	1.7976931348623158e+308
Largest allowed negative number via formula	-1.7976931348623158e+308
Length of formula contents	8,192 characters
Internal length of formula	16,384 bytes
Iterations	32,767
Worksheet arrays	Limited by available memory
Selected ranges	2,048
Arguments in a function	255
Nested levels of functions	64
User defined function categories	255
Number of available worksheet functions	341
Size of the operand stack	1,024
Cross-worksheet dependency	64,000 worksheets that can refer to other sheets
Cross-worksheet array formula dependency	Limited by available memory
Area dependency	Limited by available memory
Area dependency per worksheet	Limited by available memory
Dependency on a single cell	4 billion formulas that can depend on a single cell
Linked cell content length from closed workbooks	32,767
Earliest date allowed for calculation	January 1, 1900 (January 1, 1904, if 1904 date system is used)
Latest date allowed for calculation	December 31, 9999
Largest amount of time that can be entered	9999:59:59

Charting specifications and limits

Feature	Maximum limit
Charts linked to a worksheet	Limited by available memory
Worksheets referred to by a chart	255
Data series in one chart	255
Data points in a data series for 2-D charts	Limited by available memory
Data points in a data series for 3-D charts	Limited by available memory
Data points for all data series in one chart	Limited by available memory

PivotTable and PivotChart report specifications and limits

Feature	Maximum limit
PivotTable reports on a sheet	Limited by available memory
Unique items per field	1,048,576
Row or column fields in a PivotTable report	Limited by available memory
Report filters in a PivotTable report	256 (may be limited by available memory)
Value fields in a PivotTable report	256
Calculated item formulas in a PivotTable report	Limited by available memory
Report filters in a PivotChart report	256 (may be limited by available memory)
Value fields in a PivotChart report	256
Calculated item formulas in a PivotChart report	Limited by available memory
Length of the MDX name for a PivotTable item	32,767
Length for a relational PivotTable string	32,767
Items displayed in filter drop-down lists	10,000

Shared workbook specifications and limits

Feature	Maximum limit
Users who can open and share a shared workbook at the same time	256
Personal views in a shared workbook	Limited by available memory
Days that change history is maintained	32,767 (default is 30 days)
Workbooks that can be merged at one time	Limited by available memory
Cells that can be highlighted in a shared workbook	32,767
Colors used to identify changes made by different users when change highlighting is turned on	32 (each user is identified by a separate color; changes made by the current user are highlighted with navy blue)
Excel tables in a shared workbook	0 (zero) Note: A workbook that contains one or more Excel tables cannot be shared.

Worksheet and workbook specifications and limits

Feature	Maximum limit
Open workbooks	Limited by available memory and system resources
Worksheet size	1,048,576 rows by 16,384 columns
Column width	255 characters
Row height	409 points
Page breaks	1,026 horizontal and vertical
Total number of characters that a cell can contain	32,767 characters
Characters in a header or footer	255
Sheets in a workbook	Limited by available memory (default is 3 sheets)
Colors in a workbook	16 million colors (32 bit with full access to 24 bit color spectrum)
Named views in a workbook	Limited by available memory
Unique cell formats/cell styles	64,000
Fill styles	256
Line weight and styles	256
Unique font types	1,024 global fonts available for use; 512 per workbook
Number formats in a workbook	Between 200 and 250, depending on the language version of Excel that you have installed
Names in a workbook	Limited by available memory
Windows in a workbook	Limited by available memory
Hyperlinks in a worksheet	66,530 hyperlinks
Panes in a window	4
Linked sheets	Limited by available memory
Scenarios	Limited by available memory; a summary report shows only the first 251 scenarios
Changing cells in a scenario	32
Adjustable cells in Solver	200
Custom functions	Limited by available memory
Zoom range	10 percent to 400 percent
Reports	Limited by available memory
Sort references	64 in a single sort; unlimited when using sequential sorts
Undo levels	100
Fields in a data form	32
Workbook parameters	255 parameters per workbook
Items displayed in filter drop-down lists	10,000
Noncontiguous cells that can be selected	2,147,483,648 cells

Calculation specifications and limits

Feature	Maximum limit
Number precision	15 digits
Smallest allowed negative number	-2.2251E-308
Smallest allowed positive number	2.2251E-308
Largest allowed positive number	9.99999999999999E+307
Largest allowed negative number	-9.99999999999999E+307
Largest allowed positive number via formula	1.7976931348623158e+308
Largest allowed negative number via formula	-1.7976931348623158e+308
Length of formula contents	8,192 characters
Internal length of formula	16,384 bytes
Iterations	32,767
Worksheet arrays	Limited by available memory
Selected ranges	2,048
Arguments in a function	255
Nested levels of functions	64
User defined function categories	255
Number of available worksheet functions	341
Size of the operand stack	1,024
Cross-worksheet dependency	64,000 worksheets that can refer to other sheets
Cross-worksheet array formula dependency	Limited by available memory
Area dependency	Limited by available memory
Area dependency per worksheet	Limited by available memory
Dependency on a single cell	4 billion formulas that can depend on a single cell
Linked cell content length from closed workbooks	32,767
Earliest date allowed for calculation	January 1, 1900 (January 1, 1904, if 1904 date system is used)
Latest date allowed for calculation	December 31, 9999
Largest amount of time that can be entered	9999:59:59

Charting specifications and limits

Feature	Maximum limit
Charts linked to a worksheet	Limited by available memory
Worksheets referred to by a chart	255
Data series in one chart	255
Data points in a data series for 2-D charts	Limited by available memory
Data points in a data series for 3-D charts	Limited by available memory
Data points for all data series in one chart	Limited by available memory

PivotTable and PivotChart report specifications and limits

Feature	Maximum limit
PivotTable reports on a sheet	Limited by available memory
Unique items per field	1,048,576
Row or column fields in a PivotTable report	Limited by available memory
Report filters in a PivotTable report	256 (may be limited by available memory)
Value fields in a PivotTable report	256
Calculated item formulas in a PivotTable report	Limited by available memory
Report filters in a PivotChart report	256 (may be limited by available memory)
Value fields in a PivotChart report	256
Calculated item formulas in a PivotChart report	Limited by available memory
Length of the MDX name for a PivotTable item	32,767
Length for a relational PivotTable string	32,767
Items displayed in filter drop-down lists	10,000

Shared workbook specifications and limits

Feature	Maximum limit
Users who can open and share a shared workbook at the same time	256
Personal views in a shared workbook	Limited by available memory
Days that change history is maintained	32,767 (default is 30 days)
Workbooks that can be merged at one time	Limited by available memory
Cells that can be highlighted in a shared workbook	32,767
Colors used to identify changes made by different users when change highlighting is turned on	32 (each user is identified by a separate color; changes made by the current user are highlighted with navy blue)
Excel tables in a shared workbook	0 (zero) Note: A workbook that contains one or more Excel tables cannot be shared.

Worksheet and workbook specifications and limits

Feature	Maximum limit
Open workbooks	Limited by available memory and system resources
Worksheet size	1,048,576 rows by 16,384 columns
Column width	255 characters
Row height	409 points
Page breaks	1,026 horizontal and vertical
Total number of characters that a cell can contain	32,767 characters
Characters in a header or footer	255
Sheets in a workbook	Limited by available memory (default is 3 sheets)
Colors in a workbook	16 million colors (32 bit with full access to 24 bit color spectrum)
Named views in a workbook	Limited by available memory
Unique cell formats/cell styles	64,000
Fill styles	256
Line weight and styles	256
Unique font types	1,024 global fonts available for use; 512 per workbook
Number formats in a workbook	Between 200 and 250, depending on the language version of Excel that you have installed
Names in a workbook	Limited by available memory
Windows in a workbook	Limited by available memory
Hyperlinks in a worksheet	66,530 hyperlinks
Panes in a window	4
Linked sheets	Limited by available memory
Scenarios	Limited by available memory; a summary report shows only the first 251 scenarios
Changing cells in a scenario	32
Adjustable cells in Solver	200
Custom functions	Limited by available memory
Zoom range	10 percent to 400 percent
Reports	Limited by available memory
Sort references	64 in a single sort; unlimited when using sequential sorts
Undo levels	100
Fields in a data form	32
Workbook parameters	255 parameters per workbook
Filter drop-down lists	10,000

Calculation specifications and limits

Feature	Maximum limit
Number precision	15 digits
Smallest allowed negative number	-2.2251E-308
Smallest allowed positive number	2.2251E-308
Largest allowed positive number	9.99999999999999E+307
Largest allowed negative number	-9.99999999999999E+307
Largest allowed positive number via formula	1.7976931348623158e+308
Largest allowed negative number via formula	-1.7976931348623158e+308
Length of formula contents	8,192 characters
Internal length of formula	16,384 bytes
Iterations	32,767
Worksheet arrays	Limited by available memory
Selected ranges	2,048
Arguments in a function	255
Nested levels of functions	64
User defined function categories	255
Number of available worksheet functions	341
Size of the operand stack	1,024
Cross-worksheet dependency	64,000 worksheets that can refer to other sheets
Cross-worksheet array formula dependency	Limited by available memory
Area dependency	Limited by available memory
Area dependency per worksheet	Limited by available memory
Dependency on a single cell	4 billion formulas that can depend on a single cell
Linked cell content length from closed workbooks	32,767
Earliest date allowed for calculation	January 1, 1900 (January 1, 1904, if 1904 date system is used)
Latest date allowed for calculation	December 31, 9999
Largest amount of time that can be entered	9999:59:59

Charting specifications and limits

Feature	Maximum limit
Charts linked to a worksheet	Limited by available memory
Worksheets referred to by a chart	255
Data series in one chart	255
Data points in a data series for 2-D charts	32,000
Data points in a data series for 3-D charts	4,000
Data points for all data series in one chart	256,000

PivotTable and PivotChart report specifications and limits

Feature	Maximum limit
PivotTable reports on a sheet	Limited by available memory
Unique items per field	1,048,576
Row or column fields in a PivotTable report	Limited by available memory
Report filters in a PivotTable report	256 (may be limited by available memory)
Value fields in a PivotTable report	256
Calculated item formulas in a PivotTable report	Limited by available memory
Report filters in a PivotChart report	256 (may be limited by available memory)
Value fields in a PivotChart report	256
Calculated item formulas in a PivotChart report	Limited by available memory
Length of the MDX name for a PivotTable item	32,767
Length for a relational PivotTable string	32,767

Shared workbook specifications and limits

Feature	Maximum limit
Users who can open and share a shared workbook at the same time	256
Personal views in a shared workbook	Limited by available memory
Days that change history is maintained	32,767 (default is 30 days)
Workbooks that can be merged at one time	Limited by available memory
Cells that can be highlighted in a shared workbook	32,767
Colors used to identify changes made by different users when change highlighting is turned on	32 (each user is identified by a separate color; changes made by the current user are highlighted with navy blue)
Excel tables in a shared workbook	0 (zero) Note: A workbook that contains one or more Excel tables cannot be shared.

Top of Page