--- title: "Add Excel Formulas Without Saving to SQL" slug: "add-excel-formulas-in-columns-that-are-not-saved-to-the-database" description: "Add calculated columns that are not saved to the database, placed to the right of the last database column, and when they get removed." updated: 2023-09-22T08:15:01Z published: 2023-09-22T08:15:01Z canonical: "sqlspreads.com/add-excel-formulas-in-columns-that-are-not-saved-to-the-database" --- > ## Documentation Index > Fetch the complete documentation index at: https://sqlspreads.com/docs/llms.txt > Use this file to discover all available pages before exploring further. # How to Add Calculation Columns to Excel Tables ## How to Add Calculation Columns to Excel Tables In some cases you would like to add extra columns to the Excel table **that are not saved to the database**. These type of columns can be aggregrations, percentage comparisons or other columns that are calculated based on the entry in the other columns. ![image.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/image%28115%29.png) Calculation columns will have to be added to the right-side of the Excel table, after your last database column. In the cases below, SQL Spreads will re-create the Excel table and then any calculation columns will be removed: - When the key columns are changed - When the pivot-key or pivot-value columns are change in a pivoted setup - When a new table is selected #### Auto-populate formulas in an Excel table column Excel can auto-populate formulas in an Excel table, but there are a few things to keep in mind to get Excel to auto-populate the formulas also into new rows: 1. First, make sure that the number format of the column's cells is **not set to Text**. If the cell's number format is set to **Text**, Excel will not calculate the formula, so select eg **General**: ![image.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/image%28105%29.png) 2. Then, clear all cells in the Table column where you would like to auto-populate the formula: ![image.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/image%28110%29.png) 3. Enter your formula in the first row in the Excel table: ![image.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/image%28108%29.png) 4. Press enter, and the formula should be auto-populated into all rows in the Excel table: ![image.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/image%28109%29.png) 5. Test to add a new row at the bottom of the Excel table and check that the formula is inserted into the new row: ![image.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/image%28112%29.png)