Insert/Hide/Move Column

Online Help > Insert/Hide/Move Column

What does the “Insert Column” functionality do?

The “Insert Column” functionality allows you to add a column to your project.

What does the “Hide Column” functionality do?

The “Hide Column” functionality allows you to hide a column in your project.

What does the “Move Column” functionality do?

The “Move Column” functionality allows you to move a column in your project.

When I hide a column, how can I unhide it?

To insert a column, click on the Format menu – Insert Column or select Insert column from contextual menu.

How to change the width of an existing column precisely?

To change the width of an existing column precisely you must double click on the column, then change the width input by clicking the up and down arrows.

How do I change the relationship between tasks from the Gantt Chart?

To change the relationship between tasks from the Gantt Chart, apply the Gantt Chart View, double click on a link from the right-side chart portion of the view. In the Task Dependency dialog select the desired relationship and click OK.

How to center the name of a column?

To center the name of a column double click on the column, then click on Align Title - Center.

When I hide a column, do I erase all its data?

When you hide a column, you do not lose its data. The hide option is designed to customize the sheet view and avoid overcrowding.

How can I move a column in front of another?

To Move a column, click on the column name cell from the table header to select the entire column, hold down the column, drag it and release it in front of the column where you want to place it.

How do I update the column definition?

On editable views, columns can be updated by double clicking on the column header in the grid and changing the column definition (field name, title, title and data alignment or column width). ​

There is a WBS numbering issue.

​Please download and install the latest app from this link: Download Project Plan 365

How to adjust column width?

To quickly adjust the width of any column in order to fit the longest item in the column, double-click the right border of the column title. The column width is automatically sized to fit the widest text in any cell.

In which views is allowed to insert column?

To hide a column is allowed in a sheet view, either a task type view (i.e. Gantt Chart, Tracking Gantt or Task Sheet) or resource type view (i.e. Resource Sheet).

How do I Hide a column?

To Hide a column, select from grid the desired column, then click on menu FormatHide Column or select Hide column from contextual menu.

In which views is allowed to Hide a column?

To hide a column is allowed in a sheet view, either a task type view (i.e. Gantt Chart, Tracking Gantt or Task Sheet) or resource type view (i.e. Resource Sheet).

Do you have a work availability field?

To see the Work column, go to Format - Insert Column - In the Field Name box select column Work and click OK. The work availability column will appear in the grid. If you want to see the working hours per day, please look at the Resource Calendar. To do this, go to menu Project-Change Working Time and select the desired calendar.

How do I wrap text in a field?

If you want the text to wrap to multiple lines if the column is too narrow to display it on one line, double-click on the header of the column and select the Header Text Wrapping checkbox and press OK.

How to flag a task?

To flag a task, you can insert a custom field of type Flag. Go to menu Format - Insert Column. Select a field from Flag1-20 insert a Title and click on the OK button.

How do I freeze column?

We are sorry, but this feature is not available at this point.

How do I see the successor?

To see the successor for a task, insert the Successors field in Gantt Chart view. Go to menu Format - Insert Column. Select the Successors field and click on the OK button.

How do I find when tasks were added?

To see when the tasks were added you can insert the Created column in Gantt Chart view.

How do I center the text?

To center the text, double click on the header of the column and in Column Definition dialog, Align Data to Center.

How do I see the overall duration of tasks including predecessors?

To see the overall duration of tasks and predecessors, in Gantt Chart view insert the Duration and Predecessors column. To achieve this, go to menu Format - Insert Column.

How do I insert the Duration Variance column?

In order to Insert the Duration Variance column, go to the Format menu and select Insert Column option. From "Field Name" select "Duration Variance" and then press OK in the dialog.

How to insert the Resource Initials field?

In order to insert the Resource Initials column, go to the Format menu - Insert Column. From "Field Name" select Resource Initials and then press "OK" in "Column Definition" dialog.

When I change the size (width) of the columns, the text and the height of the lines don't automatically adjust, so I can’t see all the text of all lines.

The height of a grid row is given by the height of the Task Name cell. If you want to make the other cells bigger you can either make the width of the Task Name cell smaller (automatically making the height bigger) or manually adjusting the height of the desired rows.

What does the “Help” button inside the “Column Definition” dialog do?

The “Help” button inside the “Column Definition” dialog redirects us to the “Insert/Hide/Move Column” article in our Online Help page.

How do I hide multiple random columns?

In order to hide multiple random columns, click on a column header, hold down  the CTRL key and then click on the header of the column that you want to hide. Once they are selected, right click on a selected column and from contextual menu select “Hide Column” option.

How do I hide multiple adjacent columns?

In order to hide multiple adjacent columns, click on a column header, hold down SHIFT key and then click on the last column you want to hide. Once they are selected, right click on a selected column and from contextual menu select “Hide Column” option.

Step by step on how to insert a column:

Method 1:

1. In a sheet view, select the column (field) to the right of where you want to insert the new column.

2. Go to Format menu and click Insert Column.

3. Specify the Field name, Title, Title alignment, Data alignment, and Width of the column.

4. To wrap the column heading text to the next line, select the Header Text Wrapping check box.

Method 2:

1. Right-click on a column name in the table header and selecting Insert Column option from the displayed contextual menu.

2. The newly added column will be inserted in the sheet to the left of the selected column.

Note: To quickly adjust the width of any column in a sheet view or the Gantt Chart to fit the longest item in the column, double-click the right border of the column title. The column width is automatically sized to fit the widest text in any cell.

Step by step on how to hide a column:

Method 1:

1. In a sheet view, select the column (field) to the right of where you want to insert the new column.

2. Go to Format menu and click Hide Column.

Note: When you remove a column (field) from a table, you hide that column. Hiding a column does not remove information from your project file.

Method 2:

1. Right-click on a column name in the table header and selecting Hide Column option from the displayed contextual menu.

2. The selected column will be removed.

Step by step on how to move a column:

1. Click on the column name cell from the table header to select the entire column. The mouse will change its icon when is hovered over the column name from the table header.

2. Hold down the column, drag it and release it in front of the column where you want to place it. The vertical dividing line that appears as bolded (look at the blue arrow in the below print screen) indicates the position where will be placed the moved column.

Note: In case is needed, immediately after you insert, hide or move a column, you can use Undo or Redo options to go one step backward or forward relative to your recent changes.

Contact
Chat