dabell23

Q: Is This Auto Fill?

I am using Numbers v3 and still on the learning curve from v2. Formerly, in v2, I could beging to type a name, e.g. J-O and Joan, Jodi, Jonathan, etc. would appear in a drop-down as previous entries in the colum to select from. Is this no longer a supported feature in Numbers v3? I'm not sure what this functionality is called, perhaps AutoFill? Please comment. Thanks.

MacBook Pro (13-inch Late 2011), Mac OS X (10.7.3)

Posted on Dec 23, 2013 8:50 AM

Close

Q: Is This Auto Fill?

  • All replies
  • Helpful answers

  • by Wayne Contello,Solvedanswer

    Wayne Contello Wayne Contello Dec 23, 2013 8:53 AM in response to dabell23
    Level 6 (19,416 points)
    iWork
    Dec 23, 2013 8:53 AM in response to dabell23

    This feature was dropped in going from Numbers '09 to Numbers 3.  Apple is planning according to this link:

    http://support.apple.com/kb/HT6049?viewlocale=en_US&locale=en_US

     

    To add the feature back.  Until then you can continue to use the previous version (located in the folder "/Applications/iWork '09")

  • by SGIII,

    SGIII SGIII Dec 24, 2013 4:06 AM in response to dabell23
    Level 6 (10,796 points)
    Mac OS X
    Dec 24, 2013 4:06 AM in response to dabell23

    Hi dabell23

     

    If you frequently enter repeating values in a column and don't want to type the same text over and over again, note that Numbers 3 has an enhanced Pop-Up Menu functionality that in many sitiuations is a better choice than "auto-complete" since it helps prevent typos or capitalization inconsistencies from creeping in and messing up your data. It is also much more efficient than auto-complete in Numbers for iOS, should you ever want to sync to an iPad or iPhone and do data entry there.

     

    Pop-Up Menu is much enhanced over what it was in Numbers 2.3, and is easy to set up:

     

    pop-up-choose-format.png

     

    Select the whole column or range before formatting as Pop-Up Menu and your existing values in that column or range will pre-populate a menu automatically:

     

     

    pop-up-format-column.png

     

     

    Then you can remove the values you don't want in the list, such as the column header (and possibly some previous spelling errors too!):

     

    pop-up-remove-item.png

     

     

    And after this easy one-time setup all you have to do thereafter is to choose from the pop-up list when you add rows:

    pop-up-choose.png

     

     

    See this post for more details on how this handy feature has been enhanced in Numbers 3.0.

     

    Should you ever want to take your Numbers with you and do data entry on an iPad or iPhone, in a touch interface, pop-ups are much more efficient than typing the first few letters of items. You can scroll with ease through a list of dozens of items to make a pick. Anybody using Numbers cross-platform should favor Pop-Up so they can use their documents efficiently for data input on the go, which can be a productivity booster.

     

    See this thread for this and other workarounds for Numbers 3.0.

     

    SG

  • by dabell23,

    dabell23 dabell23 Dec 24, 2013 7:23 AM in response to SGIII
    Level 1 (0 points)
    Dec 24, 2013 7:23 AM in response to SGIII

    Thank you so much for the great information. You have redeemed the new Numbers for me.  Happy holidays.

     

    David

  • by mquist0,

    mquist0 mquist0 Dec 24, 2013 8:25 AM in response to SGIII
    Level 1 (0 points)
    Dec 24, 2013 8:25 AM in response to SGIII

    I was also having this problem and I was not aware of the pull down feature which helps alot. I do still want the auto complete back but your post was very helpfull. Thanks for your help