In need of an Excel solution for a work issue? Here are a good amount of Excel informations: Excel 2007 introduced a major new feature: Excel Tables. When you set up an Excel Table (or just “Table”) Excel names each column of data automatically. Also, when you add adjacent rows or columns to a Table, Excel expands the Table to include this new data, also automatically. This is in contrast to Simple Tables, where we must take the manual steps needed to add border cells and define range names. To create this Table, set up data arranged as you see in this example; select the headers and data; choose Insert, Tables, Table; in the Create Table dialog, ensure that “My table has headers” is checked; then choose OK. (more…)