Modifying Schedules

You can modify and format schedules to improve readability and to keep them up to date with changes in your project.

To edit schedules, click in a cell. To select a column, click a column index (the alphabetical cells between the title and header).

Schedule modification tools

If you want to... then...
add or change a parameter select a cell, and select a category and parameter on the Parameters panel. Changes in the table body affect the column. Changes in the title affect the cell.
Note: Parameters in the title section are shown in brackets to discern it from manually entered text.
remove a parameter from a title cell select the cell, then click (Clear Cell).
create a parameter to add to the schedule use the Project Parameters dialog. See Creating Project Parameters.
format the unit of measure select a cell, column index, or header then click (Format Unit). Change the units or unit symbol and click OK. See Edit Label Unit Formats.
add a calculated value to a column select a column, then click (Calculated Value). In the Calculated Value dialog, specify the formula or calculation that you want to use.
Note: Because calculated values are not assigned to a category, they cannot be reused. If you want to move the calculated value to a different cell, you must re-enter it.

See Formulas.

add a column to the body

select a cell or column in the schedule body. Click (Insert) on the Columns panel to open the Select Fields dialog, which functions like the Fields tab of the Schedule Properties dialog. Add new schedule fields and adjust their order as needed.

add an empty column to the title select a column to the left of where the column is to be added. Click (Insert) on the Columns panel to add a column to the right.
resize a column select cells, then select (Resize Column) and specify a value in the dialog. Select multiple columns to set them all to one size.
delete a column select cells, then click (Delete Column).
hide and unhide columns select a cell or column header, then click (Hide Columns). Click (Unhide All Columns) to reveal hidden columns.
Note: Hidden columns are not displayed in schedule views or on sheets. Values in hidden columns can be used for filtering, sorting, and grouping of the data in the schedule.
add an empty row to the title

select a row in the header. Click (Above Selected) or (Below Selected) from the (Insert) drop-down menu on the Rows panel.

add a data row to a room schedule, area schedule, key schedule, or sheet list select any cell. Click (Data Row) from the (Insert) drop-down menu on the Rows panel. The new row displays at the bottom of the schedule. Enter values as desired. This function is useful for defining elements before placing them in the model.
resize a row in the title section select one or more rows in the title section, then click (Resize Row) and specify a value in the dialog.
delete a row select cells in one or more rows and click (Delete Row).
merge and unmerge title cells select header cells to be merged and click (Merge). Select merged cells and click (Merge) again to separate merged cells.
insert a graphic in title section cells select one or more cells, then click (Insert Image) and specify the image file. This function is available for the title section in schedules.
edit cell borders select one or more cells, then click (Borders) and specify line weight and cell border.
edit shading select one or more cells in the title section or entire columns in the data section, then click (Shading).
remove cell formatting select cells or columns, then click (Reset). Conditional formatting will remain intact.
override text system families select one or more cells in the title section or entire columns in the data section, click (Font). Adjust font, size, style and color. This function is available to schedule titles, columns, headers, and grouped headers including grouped headers.
horizontally align text in the rows under a column heading

select cells, then select an alignment option from the (Align Horizontal) drop-down.
vertically align text in the rows under a column heading

select cells, then select an alignment option from the (Align Vertical) drop-down.

Related topics