Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel Beginners Query

  • 07-11-2010 3:49pm
    #1
    inde
    Closed Accounts Posts: 49 ✭


    Hey, I am new to Microsoft Excel. I want to put a title on my columns. So in Column A1 will be replaced with the title.

    If I can't do that how do I put a title on the columns?
    Would really appreciate an answer!


Comments

  • #2
    woolymammoth
    Registered Users, Registered Users 2 Posts: 1,772 ✭✭✭woolymammoth


    inde wrote: »
    So in Column A1 will be replaced with the title
    you mean cell A1..

    I'm not sure I understand your question. You can type whatever you like in the cell at the top of a column.


  • #3
    Basq
    Registered Users, Registered Users 2 Posts: 44,195 ✭✭✭✭Basq


    Do you mean you want to define your own title instead of the cell headings (A,B,C,D etc)?

    I don't think it's possible as these are used for reference.


  • #4
    inde
    Closed Accounts Posts: 49 ✭inde


    Yes that is what I want!

    I just don't know how to do it.


  • #5
    woolymammoth
    Registered Users, Registered Users 2 Posts: 1,772 ✭✭✭woolymammoth


    I don't think you can do that. is there a reason you need to though? if it's about scrolling, you can freeze the top row.


  • #6
    inde
    Closed Accounts Posts: 49 ✭inde


    How do I freeze the top row then? That means I put the Title in the first cell and freeze it?

    Thanks !


  • Advertisement
  • #7
    woolymammoth
    Registered Users, Registered Users 2 Posts: 1,772 ✭✭✭woolymammoth


    have a look at the attachment. what version of excel are you using?

    you might find some of these useful.
    http://www.gcflearnfree.org/excel
    http://www.customguide.com/computer-training/quick-references


  • #8
    Bizzi Lizzy
    Registered Users, Registered Users 2 Posts: 286 ✭✭Bizzi Lizzy


    You can change the Column Headings i.e A,B,C,D etc to anything you want, but they won't show up on the sheet. To do this you need to select the column, then highlight the text in the name box at the top left hand corner of the sheet (i.e. A1) and just type in what ever you want to call it.

    But remember it will still show up as column A on the sheet, but when you select column A you will see whatever you called it in the name box.

    You can get around this by using row one as your header row, type what ever you want the columns to be called, then go into tools, options, and turn off headers but this also gets rid of your of your row numbers.


  • #9
    inde
    Closed Accounts Posts: 49 ✭inde


    I am using Excel 2007.

    I am a bit lost!
    I just want titels for each of the columns is all!


  • #10
    woolymammoth
    Registered Users, Registered Users 2 Posts: 1,772 ✭✭✭woolymammoth


    inde wrote: »
    I am using Excel 2007.

    I am a bit lost!
    I just want titels for each of the columns is all!
    ok, well the easiest thing to do is use the top row for your titles. What's going in the worksheet if you don't mind me asking?


Advertisement