Excel Tables are very useful in managing and analyzing data in tabular format. An Excel Table provides the data in a special structure, which comes with filtering, formatting, and sizing, and can also auto populate formulas dynamically. In this guide, we’re going to show you how to create calculated columns in Excel tables.

 

How to Create Calculated Columns in Excel Tables

Follow the steps below to add calculated columns into your Excel Tables. Since you want to add a formula, you may already have an Excel Table. If you don't have your table yet, please see How to insert an Excel table for more details.

1.      Select a cell inside the column

Begin by selecting a cell inside the column you want to add your formulas. It doesn't matter which row you click on, as long as it is not in the header row.

Tip: You do not need to adjust your table if the new column is adjacent to the table. Excel will expand the table automatically.

2.      Enter the formulas

Enter your formulas and press Enter to populate the entire column with your formula. Excel will automatically match the formatting, aggregate calculations, and add or remove any fields as necessary.

3.      (Optional) Update the header of the new column

If you add a brand new column without setting a header, Excel will give it a generic name like Column1. Simply click on the header cell and type in the header name you want. This step obviously won't be necessary if you're using an existing column for adding formulas.

4.      (Optional) Customization

You can now customize your table however you'd like. For more information, please see Tips for Excel Tables