# Excel Tables 7 – Freeze “Pain”killer

Simple one. But deserves a separate article so that the world takes notice!

# Excel Tables 6 – Miraculous Formula Auto-Copy

Most probably, you have been missing this Auto-copy feature for the last 8 years. Take 3 minutes to find out how it can simplify your life and increase accuracy.

# Excel Tables 5 – Good Data Checklist

Now it is time to spell out exactly what to look for when creating good raw data (or repairing bad input data). Use this as a checklist to quickly classify data into GOOD or BAD (requires clean-up).

# Excel Tables 4 – Merged Cells and Cross Tab – The Data Villains

Because of these two villains, millions of people waste their life struggling in Excel. Read on to find out how to handle them and eliminate them from your life.

# Excel Tables 3 – Handling manual formatting while creating tables

Existing formatting is not removed by Table Auto-Formatting. Here is how to handle the situation.

# Excel Tables 2 – Converting regular data to Tables

Select regular data and choose Insert – Tables or Press CTRL T. Agreed. But there is more to it. Read on to find out the nuances…

# Excel Tables 1 – What and Why?

This is a series about Excel Tables. I have covered this topic in the past but now we need more details. So let us start at the beginning. What are Excel Tables and why do we need them…

# Knowledge Pack – Excel Tables

Excel Table seems like a trivial feature. But if used correctly, it transforms and improves the way you use Excel dramatically. Here is a set of articles (the entire knowledge pack) which explain the concept and importance of Excel tables. Many practical usage scenarios are also explained in detail.

## Articles about Excel Tables

All you wanted to know about Tables. In a concise series of articles. Below is the Knowledge Pack.

1. What are Excel Tables and Why should you use them?
2. Converting regular data to Excel Tables
3. Handling manual formatting while creating tables
4. Merged Cells and Cross Tab – The Data Villains
5. Good Data Checklist – Prerequisite to creating Excel Tables
6. Miraculous Formula Auto-Copy with Excel Tables
7. Excel Tables Formula Auto-copy not working
8. Freeze “Pain”killer
9. Automatic copying of everything!
10. Unbelievable simplicity – Calculated Columns (Readable Formulas)
11. Everything is in a name
12. Auto Update Dependent Formulas and References
13. Standard Operating Procedure for using tables across the organization

# Using links to OneNote content

If you use OneNote extensively, it will soon have lots of content. Linking to that OneNote content from other applications is a frequent need. Here is how you do it…