Rename/Change column label

[sgrho1]

Can anyone tell me how to change the column label? For example, I want to change Column "A" to Column "Name". I thought I knew, but I can't figure it out. Thanks in advance.

 

[Carvel]

click column "A", then click Insert/Name/Define and then type the name

alternatively, you can click column "A" and then click on the cell reference identifier, then type the name directly.

- Kevin

 

[sgrho1]

ray:
Lifesaver. Thanks. Its always the simple things that completely slip your mind.

 

[Rhuturaj]

Predefine

The Column name Which are the by default there in the Excel. In A B C D E. I f We want to changed that to Numbers. and again want revert back to Alphabet how do we do that. please assist. tried Alot

 

[Jon von der Heyden]

Go to Tools > Options > General (tab)

Check R1C1 reference style for numbers, uncheck for letters.

HTH

 

[Rhuturaj]

thanku man .....excellent

 

[Achtungheiss]

OK, so by following these directins, I can name the columns and I can make the labels show either A-Z or numbers. How can I get the names of the columns to appear instead of letters and numbers?

 

[Jon von der Heyden]

Hi and welcome to the board.

You can only have your columns appears A;B;C etc. or 1;2;3 etc.
Use row 1 to house field names.

 

[ashishparekh]

I am unable to find cell reference identifier in office 2007, please help

 

[Jon von der Heyden]

Hi and welcome to the board!

What do you mean by 'cell reference identifier'? Where is this found in earlier versions?