Display Columns in a Spreadsheet View

Use this procedure to information as columns in a spreadsheet.

To display additional information as columns in spreadsheet view:

1. In the Project Views folder of Open Plan Explorer, select a project to display in spreadsheet view.
2. Display the Organize Spreadsheet Columns dialog box by taking one of the following actions:
   • Right-click the spreadsheet, and click Organize Columns on the context menu.
   • On the View tab, click Table Layout.
3. For each column you want to display in the spreadsheet, take one of the following actions:
   • Select the fields from the Available fields list and click the right-arrow button. If a field is selected in the Display these fields list, the available field(s) selected will be inserted before that field. You can click multiple fields by selecting the appropriate checkboxes.
   • Double-click the field from the Available fields. This action moves the selected fields to the Display these fields list.
4. You can apply filters to manage the items that you want to be displayed by using the Include group box.
   The filters that can be used are the following:
   • Dates
   • Durations
   • Numerics
   • Text
   • Costs: Fields in the OP data dictionary used in the cost process when in the activity table are displayed.
   • Logical: Filters and calculated fields with logical results are displayed.
   You can simultaneously activate all of the filters by clicking Select All. Click Deselect All to deactivate all of the filters.

   All filters are selected by default.

5. Click OK.

Related Topic

• Spreadsheet View Overview