Use calculated columns in an Excel Online table

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:

  1. 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.

  2. 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.

    Calculated column

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.

See Also

Overview of Excel tables

Use calculated columns in an Excel table for Windows

Use calculated columns in an Excel table for Mac

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×