Renaming columns

[BamaDawg75]

Can anyone tell me how to rename the columns?

I want to change them from "A,B,C,..."
Thanks!

 

[Chris Davison (VBA)]

Welcome to the Board,

tools
options
general
R1C1 reference style

will change your ABCDE to 12345 etc

otherwise, you're into real "workaround" solutions which aren't exactly the most practical on earth.....

 

[BamaDawg75]

Can I not change the column names to stuff like "Name, Address, etc"?

I am working on an Excel assignment for school and we are supposed to "rename the columns (not just A,B,C, etc)".

 

[Legacy 98055]

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

 

[BamaDawg75]

I have no idea what my prof. is talking about. I believe his instructions must be incorrect, because this is supposed to be a "the basics" assignment, and no one I have found knows any way to do this.

Thanks for the suggestions...This is a terrific web site. Makes me wished I used Excel more.