So Excel has the wonderful feature (not sarcastic, I love it) that it will auto-fill formulas in tables. So you create a brand new table with a number of rows, enter "=A1+5" into the very first row and it will auto-fill that formula into every row of my table. Love it, terrific time saver.
But sometimes Excel gets confused about what the "correct" formula is for a table column. It has two effects:
- Incorrect warnings "This cell is inconsistent with the column formula". Even though every single cell in the column is consistent, every one of them has a an annoying little green triangle flag on it.
- Cells not being auto-populated with data when I create a new row. Even though every single cell in the column follows the same formula, when I add a new row it isn't auto-filled and I have to do cumbersome things like unhide the column and copy and paste the formula in.
Is there any way to see what the auto-fill formula for a column is and change it? Sometimes starting from Row 1 and dragging the auto-fill "handle" down every single row is enough to trick Excel into updating the formula it has stored, but the results are inconsistent.
Please note I'm not looking for instructions on how to suppress the consistency warnings -- I like them. I just want to fix the times when Excel has its heart set that the auto-fill formula for a column should be "X" when it ought to be "Y". Thanks in advance!
Bookmarks