Need help with excel

Discussion in 'Computers and Technology' started by Rise and Fall, Jan 31, 2010.

Thread Status:
Not open for further replies.
  1. Rise and Fall

    Rise and Fall Level IV

    Joined:
    Dec 22, 2009
    Messages:
    1,790
    Likes Received:
    101
    is it possible to name my columns?

    so like on the top where the columns show A, B, C, D...

    i want to be able to name them myself

    is that possible?

    +rep for help
     
  2. Everlast

    Everlast Level I

    Joined:
    Jan 31, 2010
    Messages:
    57
    Likes Received:
    0
    From what i can remember, i dont think you can. But maybe this will help
    "
    It sort of is by using Named cells.

    Type the Word: Name1 in cell B1 then while B1 still being selected use the fill handle (little black square bottom right of cell) drag down as far as needed.

    Now highlight Column A:B and hold down the Alt key and push I then N then C and select "Right column" only and click OK. Clear Column B.

    All your cells in Column A that had a name opposite will now be named.

    type =Name1 in any cell and you will see.
    "
    Let me know if that works.
     
  3. Joneswilliamsc

    Joined:
    Apr 28, 2010
    Messages:
    4
    Likes Received:
    0
    Interesting...I don't think so that it may be possible. Well I have never thing such before as you are talking about. And the trick which you have given but I am not able to understand it. You have to say me from where I can open that menu. I am really very interested in it so tell me it in details.

    Please do not gravedig. This topic has lost its relevancy long ago.
     
Thread Status:
Not open for further replies.