10 Replies Latest reply: Jan 20, 2010 10:11 PM by KOENIG Yvan
Axelay Level 1 Level 1 (0 points)
How do i *name the columns* in numbers? eg currently they are just a, b, c, d, e, etc and i want them to be reciepts, content, blah blah, etc

Can someone please help? Thanks in advance^^
  • Level 8 Level 8 (41,780 points)
    Welcome to the club.

    Every user may download from the Help menu the PDF "Numbers User Guide" and the PDF named "iWork Formulas and Functions User Guide".

    These resources give the wanted responce :

    When you type a cell reference that includes the name of a header cell (all applications), table (Numbers only), or sheet (Numbers only), after typing 3 characters a list of suggestions pops up if the characters you typed match one or more names in your spreadsheet. You can select from the list or continue typing. To disable name suggestions in Numbers, choose Numbers > Preferences and deselect “Use header cell names as references” in the General pane.


    Yvan KOENIG (VALLAURIS, France) lundi 18 janvier 2010 08:07:24
  • Axelay Level 1 Level 1 (0 points)
    Hi again, thanks for attempting to help and i have downloaded the pdf's u mentioned but i am still havent figured it out.

    The problem is i dont even understand what you mean by "when u type a cell reference that includes the name of a header cell"

    I have a spreadsheet open in numbers that im entering information from reciepts in and at the moment the collumns look a little like this:
    |---A---|-----B---|----C----|----D---|---E----|
    |-------|---------|---------|--------|--------|
    |-------|---------|---------|--------|--------|
    |-------|---------|---------|--------|--------|
    |-------|---------|---------|--------|--------|
    |-------|---------|---------|--------|--------|
    |-------|---------|---------|--------|--------|

    I want it to look a little like this:

    |-NAME-|--BLAH---|--DATE---|--BLAH--|--ETC---|
    |-------|---------|---------|--------|--------|
    |-------|---------|---------|--------|--------|
    |-------|---------|---------|--------|--------|
    |-------|---------|---------|--------|--------|
    |-------|---------|---------|--------|--------|
    |-------|---------|---------|--------|--------|

    I already have entered the information in all of the cells beneath so i dont want to have to start the entire doc from scratch, surely there is some way to rename the columns?

    Message was edited by: Axelay
  • Level 8 Level 8 (41,780 points)
    If you download the User Guides but don't read them carefully, the result is the same.

    I took time to extract the meaningful lines :

    *To disable name suggestions in Numbers, choose Numbers > Preferences and deselect “Use header cell names as references” in the General pane.*




    It's difficult to help someone which doesn't read carefully what we write.

    You remind me this sentence :

    *you can lead a horse to water but you can't make him drink*

    Yvan KOENIG (VALLAURIS, France) lundi 18 janvier 2010 12:14:29
  • Badunit Level 6 Level 6 (11,400 points)
    When you have the table selected you will always have the ABC's across the top and numbers down the left side. There is no way to disable that, it is core to the application to be able to reference cells by a column letter and row number. When you click off of the table, these letters and numbers don't show. If you want to give your columns names, type the names in a header row. The names you type in a header row will be there even when the table is not selected.

    With "use header cell names as references" checked, if a cell has a name in the header row and a name in the header column, the cell can be referenced by those names instead of a letter-number combination.
  • nafs Level 1 Level 1 (0 points)
    I have found out the hard way to disable "use header names as references".

    Sometimes it just doesn't work, e.g. when you have periods in the header names.
  • Level 8 Level 8 (41,780 points)
    Surprising.

    Here, it behaves flawlessly.



    Yvan KOENIG (VALLAURIS, France) mardi 19 janvier 2010 12:38:00
  • jacuzzi Level 1 Level 1 (0 points)
    I am creating a very long of 110 rows and counting with 9 columns. The problem is, that when I scroll down to, say, row 40 I am not able to see my column headers any longer. This is obviously frustrating when I have to keep scrolling back up to check which category I am looking at.
    I understand that you cannot rename the program's headers (A, B, C, D, etc).

    So the question is, is there anyway have my column headers scroll with me (the way that the program's column labels do)? If this isn't possible, is there another way to get around this problem?

    Thanks!
    Jacqueline
  • Badunit Level 6 Level 6 (11,400 points)
    Go to the menu item Table/Freeze Header Rows
  • jacuzzi Level 1 Level 1 (0 points)
    Genius! Thank you.
  • Level 8 Level 8 (41,780 points)
    Do you know that every user may download well done User Guides thru the Help menu ?

    *Numbers User Guide* and *iWork Formulas and Functions User Guide* respond to questions like yours.

    Yvan KOENIG (VALLAURIS, France) jeudi 21 janvier 2010 07:11:44