shortround4
Level 1 (4 points)
Photos for Mac

Q: how to type part of a word and have Numbers suggest the whole word as previously used?

I track a budget in a table, using a limited set of category names in a column.  After typing in a few items and category names, later items use the same category names.  In Numbers 2.0, I could type the first characters of a category name and Numbers would suggest/guess the whole category name as used in earlier entries. That allowed me to choose it quickly without retyping the whole word. How to do this in Numbers 3.0?

MacBook Pro, iOS 7.0.4, Numbers 3.0 issue

Posted on Dec 30, 2013 8:34 AM

Close
shortround4

Q: how to type part of a word and have Numbers suggest the whole word as previously used?

  • All replies
  • Helpful answers

  • by Peggy,

    Peggy Peggy Dec 30, 2013 8:56 AM in response to shortround4
    Level 8 (38,920 points)
    Applications
    Dec 30, 2013 8:56 AM in response to shortround4

    This is one of many features that were eliminated or changed in Numbers 3.0. Leave feedback for the Numbers team using the link in the Numbers menu. Then go to the Mac App Store & review & rate Numbers 3.0.

     

    Peggy_sig.png

  • by shortround4,

    shortround4 shortround4 Dec 30, 2013 1:53 PM in response to Peggy
    Level 1 (4 points)
    Photos for Mac
    Dec 30, 2013 1:53 PM in response to Peggy

    Thanks for the quick response.  I left feedback for the Numbers team and hope enough other people will do likewise such that Apple reinstates the feature.

     

    Regarding the screen shot you sent, I don't read German, but I think the it is suggesting using TCP/IPv6.  I don't see the connection between that and the missing Numbers feature.  Is there one?

  • by Yellowbox,Helpful

    Yellowbox Yellowbox Dec 30, 2013 6:09 PM in response to shortround4
    Level 6 (10,515 points)
    Mac OS X
    Dec 30, 2013 6:09 PM in response to shortround4

    Hi shortround,

     

    Apple has announced coming soon:

     

    • Customize toolbar
    • Improvements to zoom and window placement
    • Multi-column and range sort
    • Auto-complete text in cells
    • Page headers and footers
    • Improvements to AppleScript support

     

    http://support.apple.com/kb/HT6049

     

    Regards,

    Ian.

     

     


  • by Badunit,Helpful

    Badunit Badunit Dec 30, 2013 6:31 PM in response to shortround4
    Level 6 (11,705 points)
    iTunes
    Dec 30, 2013 6:31 PM in response to shortround4

    This topic is very abundant on this forum right now. In fact, as I write this reply, the top three topics in the Numbers discussion forum are about autocomplete and there is a fourth on the first page.  I wonder if people think about scanning or searching the existing topics before starting a new one. It is much more useful to others if the topic is covered and answered completely in one thread versus spread across many.

  • by SGIII,

    SGIII SGIII Dec 30, 2013 6:34 PM in response to shortround4
    Level 6 (10,782 points)
    Mac OS X
    Dec 30, 2013 6:34 PM in response to shortround4

    choose it quickly without retyping the whole word. How to do this in Numbers 3.0?

     

     

    Here's how you can do something like this in Numbers 3.0.  In many (probably most) situations it's better than "auto complete".

     

    Numbers 3 has an enhanced Pop-Up Menu functionality that 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