<div>
Oh, I have the column headers hidden, so that would explain why I didn't realize that... Lol<br />
<br />
I think the only way to change them without showing the column headers is through VBA though...
</div>


Oh, I have the column headers hidden, so that would explain why I didn't realize that... Lol

I think the only way to change them without showing the column headers is through VBA though...

<div>
Yes - that's not difficult to do, but I'd need to know what your requirement was - for example how would you trigger the rename, what column, what new name, etc
</div>


Yes - that's not difficult to do, but I'd need to know what your requirement was - for example how would you trigger the rename, what column, what new name, etc

<div>
It's static - a one time thing. I'm pretty proficient in VBA so it was no big deal. For anyone searching behind this, I simply created a loop that went something like this:<br />
<br />
ActiveSheet.ListObjects(1)<wbr />.ListColum<wbr />ns(x).Name<wbr /> = &quot;new_col_name&quot;<br />
<br />
where x is the column # you wish to rename
</div>


It's static - a one time thing. I'm pretty proficient in VBA so it was no big deal. For anyone searching behind this, I simply created a loop that went something like this:

ActiveSheet.ListObjects(1).ListColumns(x).Name = "new_col_name"

where x is the column # you wish to rename

<div>
<div class="content wysiwyg-content">
I have a large data table in Excel 2010. If I add a new column, it defaults the name of that column to &quot;Column#&quot;. Is there any way to change the name?<br />
<br />
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 &quot;=[@Column3]&quot; for example. I want to change that to &quot;=[@mycolname]&quot;<br />
<br />
Any easy way to do this? I'm comfortable with VBA but was hoping for a non VBA solution<br />
<br />
Thanks!
</div>
</div>


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

Thanks!

Change Header names in DataTable (Structured References) - Excel 2007+

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.