Spreadsheet or timeline view customization

When you view the Workflow tab in spreadsheet view mode or timeline view mode, you can make choices about the information that you want to see.

To customize the view, click Layout ( Grid with pencil Protractor, ruler, pencil ).

Options on the Project Workflow Tab Layout dialog

The Project Workflow Tab Layout dialog displays the following options:

Table 1. Options on the Project Workflow Tab Layout dialog
Option	Description
Spreadsheet Layout	To hide the options in the Spreadsheet Layout section on this dialog, click the icon next to the section title. To view a hidden section, click again.
Columns to Display	A list of check boxes that corresponds to the columns you can include in spreadsheet view mode. Click a link above the list to select a preset group of columns to display: all: default setting; all boxes checked (all columns display). targets: hides Status, % Complete, and Actual date columns. actuals: hides Target Dates/Effort and Member/Reviewer roles columns. all dates: displays all columns that are related to target and actual dates. responsibility: displays columns that are related to who is assigned to complete the tasks. Alternatively, you can check individual columns to include them or clear columns to remove them.
First Column Width	Defines the width for the first column, which displays task names and dependencies. You can set a different first column width for spreadsheet view mode and for timeline view mode. Select: Remember Last Setting: When you view the workflow spreadsheet, you can adjust the first column width to see more or less of the task names. Exactly: Select to enter a number that sets the column to an exact width in pixels.
Timeline Layout	To hide the options in the Timeline Layout section, click the icon next to the section title. To view a hidden section, click again.
Time Scale	The increment of time that is used for measurement. Select Weeks or Months. The default setting is Weeks.
Bars Represent	The bars in the timeline view indicate durations. You can choose to display Actual/Forecast dates, Target dates, or both. The default is to display both.
Bar Captions	By default, the bars do not have captions. Select an option to display task information as bar captions. For example, you can have task names or milestone types display as the captions.
First Column Width	Defines the width for the first column, which displays task names and dependencies. You can set a different first column width for spreadsheet view mode and for timeline view mode. Select: Remember Last Setting: When you view the workflow spreadsheet, you can adjust the first column width to see more or less of the task names. Exactly: Select to enter a number that sets the column to an exact width in pixels.
Make these the default settings for this project workflow tab	Check this box to make your selections the default for the Workflow tab. This option ensures that your display settings for this tab do not change until you make another change and check this box. Note: Your settings become the defaults for all users for this workflow, until someone changes the defaults.
Use these settings for current workflow only	Check this box to apply your selections to the current workflow only. This option ensures that your display settings for this workflow do not change until you make another change and check this box. Clear this box to make your selections the default for the Workflow tab. Your settings become the defaults for all users for this workflow until someone changes the defaults.