Tag Archives: Tables

Excel Table AutoFill Formulas not working

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)

Continue reading Excel Table AutoFill Formulas not working

What did I learn today: Repeat Header Rows across columns

Read this article first: Frustration = Feature Guarantee! (Table Row breaking across pages). Here we saw how to ask Word to manage repeating the header automatically across pages.

What I learnt today is that the Repeat Header Rows feature works across columns as well. This is very useful when we have a narrow table shown in multiple columns on the same page.

repeat header rows across columns