8 Replies Latest reply: Feb 19, 2013 5:16 AM by AlexanderFun
AlexanderFun Level 1 Level 1 (0 points)

How can i input a sequence in numbers like excel? thanks.

  • 1. Re: numbers question
    Jerrold Green1 Level 7 Level 7 (28,995 points)

    Just the same way, I believe.

     

    Jerry

  • 2. Re: numbers question
    AlexanderFun Level 1 Level 1 (0 points)

    Thanks, Jerry.

    Actuely, it desn't. May you help me what kind of measures i can do?

  • 3. Re: numbers question
    Jerrold Green1 Level 7 Level 7 (28,995 points)

    Read "Autofilling Table Cells" in the Numbers User Guide. It's in Chapter 4. You can download the guide from the Help Menu links.

     

    Jerry

  • 4. Re: numbers question
    Wayne Contello Level 6 Level 6 (13,615 points)

    in cell A1 and a value (let's say 1), then in A2 enter the "next" value (let's say 2), now select A1 and A2, then grab (click and hold) the little circle at the bottom right of the selection and drag down as needed to auto fill.  This works with numbers, days, dates months, etc

  • 5. Re: numbers question
    AlexanderFun Level 1 Level 1 (0 points)

    Hi, Wayne, anyway thanks.

     

    I'm sorry, i didn't explain in detail, in order to select automatically, we usually input some words or iterms often used, then by the data validation, we can make a sequence, that is to say, drop down list, so we can select acording to the list and input automatically. This is easy to create in excel, but in numbers, i don't know how to achieve this.

  • 6. Re: numbers question
    Yellowbox Level 5 Level 5 (4,570 points)

    Alexander,

     

    What you want is cells formatted as Pop-up menus. In the User Guide, see on Page 99

     

    Using a Checkbox, Slider, Stepper, or Pop-Up Menu in Table Cells

     

    You can set cell formats using the Cell Formats button in the Format bar, or in Inspector > Cells tab

     

    Screen Shot 2013-02-19 at 8.24.22 PM.png

    Regards,

     

    Ian.

  • 7. Re: numbers question
    Jerrold Green1 Level 7 Level 7 (28,995 points)

    Alex,

     

    We often take questions from users who aren't comfortable using English in the forums, or who are unfamiliar with the Numbers terminology. This is a very normal thing and we are not bothered by it. The more complete the problem statement is, the more easily we can come to understand the needs. It now seems that you are asking about a menu format. Numbers calls it a Pop-up Menu, as Ian notes. Unlike some more developed spreadsheet programs, Pop-up Menu cells must be programmed in the Cells Inspector. There is no feature to create the menu, or to edit the menu, in a table. We hope that feature will be added in a future upgrade of the Numbers application.

     

    Jerry

  • 8. Re: numbers question
    AlexanderFun Level 1 Level 1 (0 points)

    Hi, Jerry,

     

    Thank you very much, I have solved this problem with your help.

     

    Alex