About Modifying Schedules

Improve readability and keep schedules up to date.

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

On either the Modify Panel Schedule Template tab or the Modify Schedule/Quantities tab (available when you ) you can specify the formatting options, as shown in the following table.

You can edit the cells in a schedule by clicking in them. You can either select a value from a list (if available) or enter text. As you add new values, they become available in that field's list.

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

To enter carriage returns in a text cell, press Shift+Enter. Carriage returns display when you place the schedule on a sheet.

For schedules grouped by type, changes to a type are propagated to all instances of that type within the project.

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.
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.
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.
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. 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 (Above Selected) or (Below Selected) from the (Insert) drop-down menu on the Rows panel. 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, space schedule, or sheet list	select any cell. Click (Insert Data Row) from 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.