You can modify and format schedules to improve readability and to keep them up to date with changes in your project.
Note: Graphical column schedules are a unique type of visual schedule that cannot be modified like standard schedules.
On either the Modify Panel Schedule Template tab or the Modify Schedule/Quantities tab (available when you open a schedule) you can specify the formatting options, as shown in the following table.
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 Create 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 Note: Inserting columns in panel schedule templates is different. Please review their specific tools for more information.
|
| 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. Note: Inserting columns in panel schedule templates is different. Please review their specific tools for more information.
|
| 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 Note: Inserting rows in panel schedule templates is different. Please review their specific tools for more information.
|
| 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. Non-parameter cells in panel schedules will allow graphics. |
| 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. Any cell can be edited in panel schedules. |
| 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. |
(Below Selected) from the Related topics