Results 1 to 6 of 6
  1. #1
    Numbers Pop-up Menu Problem
    Does anyone know how to edit an existing popup menu in the new update. Every time I select the cell then hit the paint brush, I scroll down to pop-up menu and hit the “i” with a circle around it. It used to then show me the existing categories I set up and allow me to add or rearrange the order, now it just defaults to “item 1,item 2, item 3” and does not show my custom categories. If I have to add a category to an existing cell, I have to enter all the other ones again manually along with the new one. This cannot be right. Am I missing something? This just seems very counter intuitive. I use this mainly for budgeting and I have a lot of categories on this spreadsheet.

  2. #2
    I’m having the exact same problem.

  3. #3
    While I don’t have a proper fix, I do have a workaround that I just found:

    https://discussions.apple.com/thread...22#26446631022

    “In a spare table or column, enter the values that you want to populate the Pop-up.
    Select those cells.
    Format Panel > Cell > Data Format > Pop-Up Menu”

    I tried it and it works great. Even when this bug is fixed, I’ll probably use this technique to populate my pop-up menus anyway. (This is a nasty bug. I don’t get why I’m not finding more comments around about it.)

  4. #4
    Numbers Pop-up Menu Problem
    chscag's Avatar
    Member Since
    Jan 23, 2008
    Location
    Keller, Texas
    Posts
    56,338
    Your Mac's Specs
    2017 27" iMac, 10.5" iPad Pro, iPhone 6s+, iPhone 7+, Numerous iPods, Mojave
    Thanks for posting the work around. Not too many folks use Numbers for spreadsheet work. Most are still Excel users.

  5. #5
    This is a great work around! Thanks for posting. This was driving me crazy.

  6. #6
    Glad itÂ’s been useful. Definitely an annoying bug.

    IÂ’m happy to know about this technique anyway. It makes it easier to globally update pop-up cells with a modified list without having to fuss over restoring the target cellsÂ’ original values. Before, when updating by pasting an updated pop-up cell into a target cell, this would overwrite whatever element of the list was already there (unless the value of the source cell was already the same as the target cell). Now, it updates the list of a cell while preserving the value already there. If the value of the cell is not in the list youÂ’re replacing it with, it simply adds the new value to the list.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. problem with date in numbers-cell
    By brompton007 in forum Switcher Hangout
    Replies: 2
    Last Post: 04-17-2017, 10:00 AM
  2. Numbers with pop-menu etc..
    By Jammis in forum macOS - Apps and Games
    Replies: 0
    Last Post: 01-16-2016, 03:38 PM
  3. Word 2011– Problem with page numbers
    By Andrea Russo in forum macOS - Operating System
    Replies: 0
    Last Post: 10-14-2013, 08:09 AM
  4. Weird numbers problem.
    By chris meredith in forum macOS - Apps and Games
    Replies: 0
    Last Post: 03-26-2013, 04:33 AM
  5. Problem in Numbers
    By flynavy in forum macOS - Apps and Games
    Replies: 0
    Last Post: 01-12-2011, 02:19 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •