Tables can be a godsend when I have to build large grids where column values are derived from other table columns. Each formula is so clearly referenced. I go the extra mile trying to set formulas so every row in a column gives the proper result using exactly the same formula.
This is all nice and great when Excel works as intended, automatically replicating formulas and formatting for every table column as soon as I start a new row.
But all is not sunny on one of my largest tables. I have columns with matrix formulas, regular formulas, values.
For some unknown reason, some columns won't get populated with formulas when I add a new row...or will not inherit the same formatting (i.e. date or % format) as the cell above.
So first question: how do I tell Excel that every cell in a specific table column should be kept with the same formula and formatting?
To make matters more complex, I have one column where I would like to have unique formulas on each cell (i.e. A1=NOW(); A2=NOW()+7; A3=NOW()+14.....). But on this particular column, Excel insists on keeping consistent formulas, and won't allow me to enter unique ones.
So second question: how do I tell Excel that cells in a specific table column are to be unique, and to stop copying the formula to all cells in the column enter every time I enter a change to a specific cell or create a new record/row?
Bookmarks