Computing column values

Add one or more computed columns to an Add-In for Excel table. Computed columns include Add-In for Excel data protection and formatting and allow you to enter a custom formula in one cell in the column, and automatically apply it to all other cells in the column.

How it works

Computed columns use native Excel calculated column functionality and are added to the end of the table as Computed numericSuffix. You can use Add-In for Excel commands on computed columns.

Tip

Use the ACL Add-In panel to adjust where the column appears and how it is named.

Add a computed column

  1. Click the ACL Add-in tab and select Computed Column > Add Computed Column.
  2. In a cell in the computed column, or in the formula bar, enter the formula that you want to use to compute the column values.

Delete a computed column

Note

You cannot undo deleting a computed column. The column is removed and cannot be recovered.

  1. Select a cell in the computed column and do one of the following:
    • Select Computed Column > Delete Computed Column.
    • In the ACL Add-In panel, click Delete column .
  2. In the Delete Column dialog box, enter a Reason for the deletion and click Yes.

    The reason for deletion is recorded in the Add-In for Excel table history.