Standardize Attributes and Properties Across Columns

A column might contain attributes (data types, modeling types, numeric formats, and so on) or properties (formulas, notes, list and range checks, and so on) that you want other columns to have. You can use the existing column to standardize the attributes and properties across columns. This includes both adding and deleting attributes and properties.

To apply an existing column’s attributes and properties to multiple columns

1. Select the column or columns containing the desired attributes or properties.

2. Select Cols > Standardize Attributes.

Figure 5.11 Standardizing Attributes across Columns