Brownhardwood

Q: How can I order by alphabet the list created on a dropdown menu?

How can I order by alphabet the list created on a dropdown menu?

iMac, OS X El Capitan (10.11.6)

Posted on Sep 6, 2016 11:58 PM

Close

Q: How can I order by alphabet the list created on a dropdown menu?

  • All replies
  • Helpful answers

  • by VikingOSX,

    VikingOSX VikingOSX Sep 7, 2016 1:34 AM in response to Brownhardwood
    Level 7 (20,564 points)
    Mac OS X
    Sep 7, 2016 1:34 AM in response to Brownhardwood

    Click on the cell with the Pop-Up menu cell data format. From the Cell tab on the right panel, you will see these menu items. Drag them to rearrange into alphabetical order. There is no provision to automatically sort that list of menu items.

  • by Yellowbox,

    Yellowbox Yellowbox Sep 7, 2016 4:11 AM in response to Brownhardwood
    Level 6 (10,430 points)
    Mac OS X
    Sep 7, 2016 4:11 AM in response to Brownhardwood

    Hi Brownhardwood,

     

    Select all the cells with Pop-Up Menus

    Format Panel > Cell > Data Format > Automatic

    Screen Shot 2016-09-07 at 8.58.34 PM.png

    Sort the Table by that Column (note that Column A follows the sort. That is normal Numbers behaviour.)

    Screen Shot 2016-09-07 at 9.00.26 PM.png

    Select the cells again and Format Panel > Data Format > Pop-Up Menu

    Screen Shot 2016-09-07 at 9.02.30 PM.png

    The Pop-Up Menu is now in alphabetical order without duplicates.

    Sort the Table by column A.

    Screen Shot 2016-09-07 at 9.04.21 PM.png

    The previously chosen Pop-Up Menu items are as they were (tied to the values in A).

     

    Regards,

    Ian.

  • by t quinn,

    t quinn t quinn Sep 7, 2016 7:01 AM in response to Brownhardwood
    Level 5 (4,960 points)
    Mac OS X
    Sep 7, 2016 7:01 AM in response to Brownhardwood

    Hi Brownhardwood,

     

    I use popup menus a lot. When I have a popup that has more than a few items I keep a table with a list of those popup values. Often the table has other functions relating to those popup items. This list I keep sorted as text. When I need to update the popup I do it here and copy/paste the popup.

     

    quinn