Display Project Plan Data Using Views › Manage Views › Apply Formats to Cells in Views

Apply Formats to Cells in Views

Use the Formatting Options dialog to apply formats to a cell in a view.

Follow these steps:

1. Open the Project ribbon.
2. Click Manage Library in the View group.
3. Select the view from the Libraries dialog and click Edit.
4. Select the cell to format and double-click the cell or click Format Cell.
5. Define the following information. The following fields require explanation:

   Note: Settings and options that do not apply to the data in the selected cell are disabled.

   Width

   Defines the numeric value for the width of the column (in pixels). The default width varies with each field name. You can change the column width in the view by dragging a column divider left or right.

   Decimals

   Specifies the number of decimal places for data in the cell.

   Values: 0, 1, or 2

   Alignment

   Specifies the alignment of data in the cell.

   Values: Left, Center, or Right

   Units/Format

   Defines the unit or format for the data in the cell.

   Values: Days, Hours, Percent (of total availability), or As Is

   Note: The As Is option allows you to report mixed units of measure in a view.

   Period Unit

   Defines the period unit for the data in the cell. You can set the default period unit from the Defaults tab on the Options dialog and selecting an option for Unit of Measure.

   Values: Per Day, Percent, or Per Period (for tabulated elements only).

6. Select the options in the Options section. The following options require explanation:

   Protect

   Defines whether to make the field read-only and prevent other users from changing the data. Some cells are always protected.

   Default: Cleared

   Blank if Zero

   Defines whether to make the field appear blank if its value is zero.

   Default: Cleared

   Column Totals

   Defines whether to show the total for all the values in a column in a separate pane. Date totals represent the earliest or latest date in the range, depending on the field. For example, the total for Start date is the earliest date in the range.

   Default: Cleared

   Tabulate

   Defines whether to arrange data in a tabular format.

   Default: Cleared

   Note: The default is cleared unless there is another tabulated field name in the same column.

   WBS Indent

   Defines whether to indent tasks based on the Work Breakdown Structure levels.

   Default: Cleared

7. Click Time Scale to specify how time scales appear in a view.
8. Click OK.

More information:

Manage Views

Insert and Delete Rows in Views

Apply Views to Projects

Remove Field Names or Columns from Views