I have a question re: auto fill with function formulas.  Sometimes, when I've added a column and inserted a formula, when I try to use the auto fill, the answer I receive is the same as the original cell for all other cells.  I check the formula and it changed to pick up the new range of cells but it gives me a wrong answer.  If I click on the cell look at the formula and click again it will then show me the correct answer.  Can you tell me why this happens and how do I correct my problem?  It is very time consuming and makes me question the accuracy of the function/formulas.  Thank you

---

Reply from Richard Rost:

I'm not sure WHY this is happening. Do you have the latest service pack installed for Office? I'd have to see your spreadsheet to tell you exactly what's going on. This is one of the most compelling reasons to use TABLES in Excel though. If all of your data and formulas are uniform, a table will force the formulas in every column to be exactly the same for every row. I cover them in Excel Basic 4, lesson 6 (next class, which I see you've already ordered.)