By default, a calculated column is automatically created in a Microsoft Excel table when you enter a formula in a table column. A calculated column uses a single formula that adjusts for each row and automatically expands to include additional rows in that column so that the formula is immediately extended to those rows. You only need to enter a formula to have it automatically filled down to create a calculated column—there’s no need to use the Fill or Copy command.
To create a calculated column in a table:
-
Click a cell in an empty column that you want to use as the calculated column.
Tip: You can create an additional table column by simply typing anywhere in the column to the immediate right of the table. It's generally best to start by typing a new table header in the first row of the table.
-
Type the formula you want to use, and press ENTER.
Note: If you type a formula in a cell that already has data, it doesn’t create a calculated column.
In the below example, the SUM formula in cell D2 was automatically filled down all the cells in the calculated column D.
Edit a calculated column
To update a calculated column, click any cell in the calculated column and edit the formula in that cell and press ENTER. Excel will automatically extend the formula to the remaining table column cells.
Delete a calculated column
First click on the column header to select the entire column, then on the Home tab, go to Cells > Delete > Delete Columns, or right-click > Delete Columns.