Page 1 of 2 12 LastLast
Results 1 to 10 of 19

Rename/Change column label

This is a discussion on Rename/Change column label within the Excel Questions forums, part of the Question Forums category; Can anyone tell me how to change the column label? For example, I want to change Column "A" to Column ...

  1. #1
    New Member
    Join Date
    Apr 2004
    Posts
    2

    Default Rename/Change column label

    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.

  2. #2
    Board Regular
    Join Date
    Apr 2004
    Location
    Halifax
    Posts
    180

    Default Re: Rename/Change column label

    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

  3. #3
    New Member
    Join Date
    Apr 2004
    Posts
    2

    Default Re: Rename/Change column label


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

  4. #4
    New Member
    Join Date
    Oct 2008
    Posts
    2

    Post 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

  5. #5
    MrExcel MVP
    Moderator

    Technicality
    Jon von der Heyden's Avatar
    Join Date
    Apr 2004
    Location
    Blackboys, East Sussex, UK
    Posts
    10,473

    Default Re: Rename/Change column label

    Go to Tools > Options > General (tab)

    Check R1C1 reference style for numbers, uncheck for letters.

    HTH
    Regards,
    Jon von der Heyden

    Posting guidelines | Forum rules | FAQs

    Blog: Excel Evolution Blog | Twitter: @ExcelEvo | Facebook: Follow me here

    English is a weird language. It can be understood through tough thorough thought, though!

  6. #6
    New Member
    Join Date
    Oct 2008
    Posts
    2

    Default Re: Rename/Change column label

    thanku man .....excellent

  7. #7
    New Member Achtungheiss's Avatar
    Join Date
    Jun 2010
    Posts
    1

    Default Re: Rename/Change column label

    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?

  8. #8
    MrExcel MVP
    Moderator

    Technicality
    Jon von der Heyden's Avatar
    Join Date
    Apr 2004
    Location
    Blackboys, East Sussex, UK
    Posts
    10,473

    Default Re: Rename/Change column label

    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.
    Regards,
    Jon von der Heyden

    Posting guidelines | Forum rules | FAQs

    Blog: Excel Evolution Blog | Twitter: @ExcelEvo | Facebook: Follow me here

    English is a weird language. It can be understood through tough thorough thought, though!

  9. #9
    New Member
    Join Date
    Aug 2006
    Posts
    9

    Default Re: Rename/Change column label

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

  10. #10
    MrExcel MVP
    Moderator

    Technicality
    Jon von der Heyden's Avatar
    Join Date
    Apr 2004
    Location
    Blackboys, East Sussex, UK
    Posts
    10,473

    Default Re: Rename/Change column label

    Hi and welcome to the board!

    What do you mean by 'cell reference identifier'? Where is this found in earlier versions?
    Regards,
    Jon von der Heyden

    Posting guidelines | Forum rules | FAQs

    Blog: Excel Evolution Blog | Twitter: @ExcelEvo | Facebook: Follow me here

    English is a weird language. It can be understood through tough thorough thought, though!

Page 1 of 2 12 LastLast

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com