Create a calculated column or row from scratch

You can create a column or row, containing Microsoft Excel calculations, from scratch.

Procedure

  1. Insert a blank column or row.
  2. Create the calculation in the first cell that applies to the inserted column or row.

    You must create the formula for the calculation in the cell closest to cell A1 (the upper left most cell) of the inserted group.

  3. After you have created the calculation for a single cell, from the toolbar, click Use Server formats to remove custom formatting.

Results

The calculation is propagated to all the inserted cells.
Tip: You can apply conditional formatting to the calculated column or row. Select the column or row. Click Home and then click Conditional formatting. Use the conditional formatting menu to choose the styles for the cells.