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.
Tell me more
×
Super User is a question and answer site for
computer enthusiasts and power users. It's 100% free, no registration required.
|
|
|
Think of them a bit like database tables. The column names need to be unique. See http://msdn.microsoft.com/en-us/library/bb833052(v=office.11).aspx |
|||
|
|
When inside a table object, the labels become more akin to field names rather than text lables and are treated as objects themselves. Therefore, can't have two named the same within the same object. Kind of like having two files in the same location with the same name - can't be done.That's the "why. The poorman's work around is to deselect the header row check in the Table Style Options group of the Design Table Tools contextual tab. Then go and manually label the cells. The first time you sort, you must do so on the first data row. Thereafter, it works as you would expect. However, filtering is a different issue. If you need to filter, it will recreate the Col1, Col2, Col3 structure in a separate row underneath your labels. After you have filtered though, you can turn off the header row once again. |
||||
|
|
|
Another solution: Pick a table style with a white or black colored headder. After Excel creates the table and adds in the (unwanted) numbers go through the labels and highlight only the number. Change the color of the number to match the background. The number is still technicaly there but you no longer see it! |
|||
|
|
|
Another feasible option:
|
||||
|
|
