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

    Jon von der Heyden's Avatar
    Join Date
    Apr 2004
    Location
    Blackboys, East Sussex, UK
    Posts
    9,968

    Default Re: Rename/Change column label

    Go to Tools > Options > General (tab)

    Check R1C1 reference style for numbers, uncheck for letters.

    HTH

  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

    Jon von der Heyden's Avatar
    Join Date
    Apr 2004
    Location
    Blackboys, East Sussex, UK
    Posts
    9,968

    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.

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

    Default Re: Rename/Change column label

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

  10. #10
    MrExcel MVP
    Moderator

    Jon von der Heyden's Avatar
    Join Date
    Apr 2004
    Location
    Blackboys, East Sussex, UK
    Posts
    9,968

    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?

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