Change Header names in DataTable (Structured References) - Excel 2007+
Posted on 2011-10-05
I have a large data table in Excel 2010. If I add a new column, it defaults the name of that column to "Column#". Is there any way to change the name?
So for example if I put a formula in cell A4 referencing cell D4 (which is part of a data table), the reference will become "=[@Column3]" for example. I want to change that to "=[@mycolname]"
Any easy way to do this? I'm comfortable with VBA but was hoping for a non VBA solution