rosemaryfromnj

Q: numbers changes in update - missing features?

In the upgraded numbers, there are 2 functions I no longer seem to have. One is where text from an above cell would auot suggest after typing a letter or two. The other is using the tab key to travel from the end of one row to the beginning of the next. It keeps adding another column. Can anyone help? Many thanks!

iBooks, iOS 7

Posted on Nov 8, 2013 10:55 AM

Close

Q: numbers changes in update - missing features?

  • All replies
  • Helpful answers

  • by SGIII,

    SGIII SGIII Nov 8, 2013 2:04 PM in response to rosemaryfromnj
    Level 6 (10,796 points)
    Mac OS X
    Nov 8, 2013 2:04 PM in response to rosemaryfromnj

    Hi Rosemary,

     

    The typing recognition thing is not in Numbers 3.0. Apple has announced they will be restoring it in upcoming releases over the next six months. It's called "Auto-complete text in cells."

     

    Meanwhile, you could consider formatting the column where you frequently enter repeating values as Pop-up Menu. In some ways it's a better approach:

     

    If you frequently enter repeating values in a column you could consider formating the cells as Pop-Up Menu:

     

    pop-up-choose-format.png

     

    If you've selected the whole column before formatting as Pop-Up Menu, your existing values in that column will pre-populate a menu automatically:

     

    pop-up-format-column.png

     

    Then you remove the values you don't want in the menu, such as the column header (and quite possibly some previous spelling and capitalization inconsistencies 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 for that column whenever you add rows:

    pop-up-choose.png

     

    That's all there is to it!

     

    There's no keyboard shortcut to activate the menu such as they had in the old Numbers (I hope they'll add one) but the Pop-Up Menu approach has some advantages over autocompletion: no spelling inconsistencies or lack of capitalization when there should be capitalization, etc.

     

    And should you ever want to take your Numbers with you, in a touch interface pop-ups are more efficient than activating a virtual keyboard and tapping the first few letters of items.

     

    See this thread for other workarounds for features not included in Numbers 3.0.

     

    SG

  • by SGIII,

    SGIII SGIII Nov 8, 2013 2:08 PM in response to rosemaryfromnj
    Level 6 (10,796 points)
    Mac OS X
    Nov 8, 2013 2:08 PM in response to rosemaryfromnj

    For navigation within a spreadsheet see the enormous list of keyboard shortcuts accessible via the Help menu.  A link to that page is here.  I get lost in it, but there don't seem to be many entries for 'tab' in there.  It seems the down arrow is the thing now, not quite as convenient.

     

    SG