3
I love using the formatting styles for tables in Excel 2007, but in my data I'm using the same column name for multiple columns.
When I format my table using the pre-defined styles, it automatically adds an incremental number to each subsequent column name which I don't want. Is there any way to stop this from happening? If I attempt to manually rename the column back to the original name, it automatically appends the incremented number.
+1, yes, Excel tables are much more than just formatting shortcuts and provide very useful ways of referencing the data within a table, with column names being an extremely useful method. Allowing multiple columns to have the same name would 'break' this feature. – Mike Fitzpatrick – 2011-02-09T08:05:23.027