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

Word Best Practices Video

Another video in the word best practices series. For Microsoft Channel 9. Have a look. This video shows what EVERYONE should know about Word. So please share it with everyone you work with as well as your loved ones. This is the best gift you can give a child: Knowledge!

Word Best Practices Video

Word Best Practices

View at http://bit.ly/nitinch9word, 35 minutes. View in FULL SCREEN mode at high resolution for maximum learning. Includes links to detailed articles and sample files.

Knowledge Pack: Word Tables

A collection of articles covering nuances and usage scenarios of Word Tables.

The curious case of Column Widths in Word tables
Using Formulas in Word tables
Efficiency Test 2: Word
Efficiency Test 4: Word and Efficiency Test 4 : Word : Solution
Create complex tables in seconds
Frustration = Feature Guarantee! (Table Row breaking across pages)
Reorder Word table rows instantly
How to convert multiple column data to a simple list
Building Blocks in Word – The ultimate reuse engine
How to sort a comma separated list in alphabetical order
Table going outside the page? Three click solution.