Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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.

Overview of Excel tables

Use calculated columns in an Excel table for Windows

Use calculated columns in an Excel table for Mac

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!