Table has many benefits. One of them is Table AutoFill Formulas. If you add a formula in any table column, it copies the formula automatically. Further editing of the formula also is automatically copied to all other cells in the column. Sometimes, the AutoFill stops working. How to re-enable this feature? Here are the instructions
(Reading time 3 min)
Tag Archives: Table
Excel Tables 9 – Readable Formulas in Calculated Columns
Readable formulas in Excel tables are so nice, you will curse yourself for not noticing earlier (since 8 years!). Teach this to everyone around you – NOW! Show off 
Continue reading Excel Tables 9 – Readable Formulas in Calculated Columns
Efficiency Test 6: Excel : Copying Formulas
Yes, you have been copying formulas for decades. I know. But you don’t know the most efficient method – most probably! Try it out. Spend just 4 minutes of your time.
Continue reading Efficiency Test 6: Excel : Copying Formulas