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
This short video provides solutions to the most common irritants while editing Microsoft Word Tables. It covers issues like table going outside the page, optimizing width of columns based upon the content, making all rows to be of the same height, preventing rows from breaking across pages, automatically making first row(s) as headers.
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.
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
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.
Finally, here is a proven set of best practices to make your Excel usage simpler, faster and more accurate.
Continue reading Excel Tables 12 – Standard Operating Procedure
Like column names, table names can also be used in formulas. Read the previous article to understand the context.
Continue reading Excel Tables 10 – Everything is in a name
Yes. It is not only formulas which get copied when you extend a table. Everything gets copied. Read on to find out about Automatic copying and how much time you are wasting by not knowing this!
Continue reading Excel Tables 8 – Automatic copying of everything!
Simple one. But deserves a separate article so that the world takes notice!
Continue reading Excel Tables 7 – Freeze “Pain”killer