If you type or move a formula in a table column that already contains data, a calculated column is not automatically created. The formula is the same for each row, but since it's a structured reference, Excel knows internally which row is which.Ĭopying or filling a formula into all cells of a blank table column also creates a calculated column. When you press Enter, the formula is automatically filled into all cells of the column - above as well as below the cell where you entered the formula. To learn more about structured references, see: Using structured references with Excel tables. A regular Excel formula for this would be =SUM(B2:C2), which you would then need to copy or fill down to the rest of the cells in your column The structured reference format is what allows the table to use the same formula for each row. This is called a structured reference formula, which is unique to Excel tables. As a result, Excel built the formula: 1]:]). In this case we entered =sum(, then selected the Qtr 1 and Qtr 2 columns. Type the formula that you want to use, and press Enter. Just click on the arrow for Insert > Insert Table Columns to the Left.
You can also add a table column from the Home tab.
