Skip navigation

numbers question

306 Views 8 Replies Latest reply: Feb 19, 2013 5:16 AM by AlexanderFun RSS
AlexanderFun Level 1 Level 1 (0 points)
Currently Being Moderated
Feb 18, 2013 4:38 PM

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

  • Jerrold Green1 Level 7 Level 7 (28,160 points)
    Currently Being Moderated
    Feb 18, 2013 4:50 PM (in response to AlexanderFun)

    Just the same way, I believe.

     

    Jerry

  • Jerrold Green1 Level 7 Level 7 (28,160 points)
    Currently Being Moderated
    Feb 18, 2013 5:54 PM (in response to AlexanderFun)

    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

  • Wayne Contello Level 6 Level 6 (12,625 points)
    Currently Being Moderated
    Feb 18, 2013 6:26 PM (in response to AlexanderFun)

    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

  • Yellowbox Level 4 Level 4 (3,900 points)
    Currently Being Moderated
    Feb 19, 2013 1:29 AM (in response to AlexanderFun)

    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.

  • Jerrold Green1 Level 7 Level 7 (28,160 points)
    Currently Being Moderated
    Feb 19, 2013 5:08 AM (in response to AlexanderFun)

    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

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.