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.
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
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
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!