Renaming columns

BamaDawg75

New Member
Joined
Aug 27, 2002
Messages
3
Can anyone tell me how to rename the columns?

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

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
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.....
 
Upvote 0
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)".
 
Upvote 0
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
 
Upvote 0
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. :cool:
 
Upvote 0

Forum statistics

Threads
1,218,888
Messages
6,145,016
Members
450,585
Latest member
airc72

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top