Hi Bama.
Are you certain that you are required to replace Excel's column headings with names?
If it can be done, I have never seen it!
Perhaps you are speaking of named ranges?
By selecting an entire column, typing a name into the "Name box"(above A1), you will give that particular column a name. For example:
=SUM(A:A)
would sum the values in column A.
Rename Column A by selecting it, typing "MyValues" into the Name Box, and then write a friendlier sum function as:
=SUM(MyValues)
Is this what you are speaking of?
Tom