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

Apply Formats to Cells in Views

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

To format a cell in a view

1. Select Manage Library from the View group in the Project ribbon.

   The View library dialog opens.

2. Select the view from the library dialog and press Edit.

   The Layout tab on the View Definition dialog box opens.

3. Select a cell to format and click Format Cell.

   The Formatting Options dialog box opens.

4. Define the following:

   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/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 box and selecting an option for Unit of Measure.

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

5. Define the following options in the Options section:

   Protect

   Defines whether to make the field display-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 Work Breakdown Structure levels.

   Default: Cleared

6. To specify how time scales appear in a view, click Time Scale.

   The Time Scale dialog box opens.

7. Click OK.

   The View Definition dialog box closes.

More information:

Create Views

View Definition Dialog Box

About Field Names on Views