kanjo33
Level 1 (0 points)

Q: pop-up list

Numbers 3 appears to have lost the ability to have a pop-up list automatically created from previous values in the same column, and narrowed down to a shorter list as you begin to enter letters into the cell. Has anyone found it? Thanks !! (BTW there's nothing in 'Help' about pop-ups at all).

iMac, OS X Mountain Lion (10.8)

Posted on Nov 7, 2013 3:17 AM

by SGIII,Solvedanswer
SGIII SGIII
Level 6 (10,796 points)
Mac OS X
A:

Hi Karl,

 

I think you're talking about what Apple now calls "Auto-complete text in cells."

 

That feature is not in Numbers 3.0 but Apple has announced in this support document that it will be restored in upcoming releases within six months.

 

Meanwhile, you may find that the pop-up menu that Ian described is easy to set up and in some ways is better (no typos, or lack of capitalization where there should be capitalization, creeping into your data).

 

You don't have to put all the values in by hand. You can automatically populate the menu by first selecting the entire column and then formatting as pop-up menu.

 

For this and other ideas for working with Numbers 3.0 see this thread.

 

SG

Posted on Nov 8, 2013 7:28 PM

Close
kanjo33

Q: pop-up list

  • All replies
  • Helpful answers

  • by Yellowbox,

    Yellowbox Yellowbox Nov 7, 2013 3:46 AM in response to kanjo33
    Level 6 (10,535 points)
    Mac OS X
    Nov 7, 2013 3:46 AM in response to kanjo33

    Hi Kanjo,

     

    Enter your values first

    Screen Shot 2013-11-07 at 10.35.21 pm.png

     

    Select all cells in that Column, then Format Inspector > Cell > Data Format > Pop-Up Menu

     

    Screen Shot 2013-11-07 at 10.39.01 pm.png

     

    You can add or delete items later with the + or - buttons

     

    Screen Shot 2013-11-07 at 10.41.51 pm.png

     

    Here is a Pop-Up

     

    Screen Shot 2013-11-07 at 10.43.56 pm.png

     

    Regards,

    Ian.

  • by kanjo33,

    kanjo33 kanjo33 Nov 7, 2013 11:43 AM in response to Yellowbox
    Level 1 (0 points)
    Nov 7, 2013 11:43 AM in response to Yellowbox

    thanks, 'yellowbox', but what i am looking for is a dynamic pop-up list such as found in excel, that is self-creating and self-maintaining. i am reasonably certain that numbers used to do it.  ... karl

  • by SGIII,Solvedanswer

    SGIII SGIII Nov 8, 2013 7:28 PM in response to kanjo33
    Level 6 (10,796 points)
    Mac OS X
    Nov 8, 2013 7:28 PM in response to kanjo33

    Hi Karl,

     

    I think you're talking about what Apple now calls "Auto-complete text in cells."

     

    That feature is not in Numbers 3.0 but Apple has announced in this support document that it will be restored in upcoming releases within six months.

     

    Meanwhile, you may find that the pop-up menu that Ian described is easy to set up and in some ways is better (no typos, or lack of capitalization where there should be capitalization, creeping into your data).

     

    You don't have to put all the values in by hand. You can automatically populate the menu by first selecting the entire column and then formatting as pop-up menu.

     

    For this and other ideas for working with Numbers 3.0 see this thread.

     

    SG

  • by kanjo33,

    kanjo33 kanjo33 Nov 9, 2013 3:55 AM in response to SGIII
    Level 1 (0 points)
    Nov 9, 2013 3:55 AM in response to SGIII

    your assumption is correct, that's what i was actually looking for.  thank you !! ...karl