1.In the Data View select the columns that you want to calculate by dragging across their column headers or selecting a cell range. If you select entire columns, the range to calculate is set based on the longest data set in the Data View.

2.Click Data Tools/Design[Columns] > Calculate Values. You can obtain more help in the dialog box that appears.

See Also

DataSet

Data Set Window and Data View

Filling Columns with Values

Applying Formulas to Data Sets