7carin

Q: numbers füllt den text nicht automatisch aus

Hallo

Ich hab eine Kundentabelle.

Seit dem Update wird der Text nicht mehr automatisch erkannt und

ich muss jedesmal die Kunden neu eingeben.

Vorher hat man eine Auswal an bereits eingegebenen Zelleninhalten

erhalten nach dem ersten Buchstaben.

Nach mehreren Stunden SUCHEN bin ich es leid und frage euch

Bitte um Hilfe wie ich diese Funktion wieder aktivieren kann...

Vielen Dank

Carin

iMac, OS X Mavericks (10.9.1)

Posted on Jan 11, 2014 2:08 AM

Close

Q: numbers füllt den text nicht automatisch aus

  • All replies
  • Helpful answers

  • by Yellowbox,Solvedanswer

    Yellowbox Yellowbox Jan 11, 2014 2:56 AM in response to 7carin
    Level 6 (10,515 points)
    Mac OS X
    Jan 11, 2014 2:56 AM in response to 7carin

    Hi Carin,

     

    Autofill has gone in Numbers 3.

     

    Apple has promised to bring it back as Auto-complete text in cells:

     

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

     

    Numbers

    • 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

     

    Search for SGIII to find a method that uses Pop-Up menus:

     

    Screen Shot 2014-01-11 at 9.54.42 pm.png

     

    Courtesy of Google Translate:

     

    Mit freundlicher Genehmigung von Google Translate:

    Hallo Carin,

    Autofill hat in der Nr. 3 verschwunden.

    Apple hat versprochen, um es wieder als Auto-komplette Text in Zellen zu bringen:

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

    Numbers
    Symbolleiste anpassen
    Improvements to zoom-und Fensterplatzierung
    Multi-Spalten-und Sortierbereich
    Auto-komplette Text in Zellen
    Kopf-und Fußzeilen
    Verbesserungen an den Applescript-Unterstützung

    Suche nach SGIII eine Methode, die Pop-Up-Menüs verwendetzu finden.

    Regards,

    Ian.

  • by 7carin,

    7carin 7carin Jan 11, 2014 3:48 AM in response to Yellowbox
    Level 1 (0 points)
    Jan 11, 2014 3:48 AM in response to Yellowbox

    Thanks a lot!!!!

    stupid but.... we wait...

    Carin

  • by Yellowbox,

    Yellowbox Yellowbox Jan 11, 2014 3:55 AM in response to 7carin
    Level 6 (10,515 points)
    Mac OS X
    Jan 11, 2014 3:55 AM in response to 7carin

    Hi Carin,

     

    Thank you for your reply. I am sure that SGIII will be here soon to show you how to use Pop-Up Menus while we wait for Apple to bring back Auto-complete text in cells.

     

    Regards,

    Ian.

  • by SGIII,

    SGIII SGIII Jan 11, 2014 10:05 AM in response to 7carin
    Level 6 (10,782 points)
    Mac OS X
    Jan 11, 2014 10:05 AM in response to 7carin

    Hi Carin,

     

    Here is the spiel on Pop-Up Menu.

     

    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 and 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