Skip navigation

auto fill in Numbers

268 Views 3 Replies Latest reply: Jan 21, 2014 10:31 AM by SGIII RSS
James Thomson Level 1 Level 1 (85 points)
Currently Being Moderated
Jan 21, 2014 6:27 AM

I was sure I could find this without posting another question, but only Safari stuff came up.

 

Before I upgraded to Numbers 3.0.1 whenever typing in a cell it would auto fill from anything else in the document already present.  This is now turned off and I can't find preference to turn it back on.  Thanks.

iMac, OS X Mavericks (10.9.1)
  • SGIII Level 4 Level 4 (3,290 points)
    Currently Being Moderated
    Jan 21, 2014 7:43 AM (in response to James Thomson)

    Hi James,

     

    Auto-complete is temporarily absent from Numbers 3, due back within a few months according to Apple.

     

    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

  • SGIII Level 4 Level 4 (3,290 points)
    Currently Being Moderated
    Jan 21, 2014 10:31 AM (in response to James Thomson)

    Thanks for the green tick. Glad the info helped. I hope Apple comes through too.  Meanwhile, do give the new Pop-Up a try. It really is much easier now. And it works particularly well on iOS if you ever have the need to work on your documents (data entry) there.

     

    SG

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.