Numbers Pop-up menu - number of options?
In Numbers there is a CELL option to make it a Pop-up Menu. I currently have (6) items on the list, and can not add any more. Would someone know where/how to edit this?
Thanks in advance!
Mac Studio
In Numbers there is a CELL option to make it a Pop-up Menu. I currently have (6) items on the list, and can not add any more. Would someone know where/how to edit this?
Thanks in advance!
Mac Studio
Chizzer wrote:
Screenshots.... the first cell has them all in the drop-down... 2nd and all other rows does not.
Once you have the Pop-Up menu values as you like them in one cell then you need to propagate them to the other cells. That does not occur automatically.
Select the cell, command-c to copy, select the cells below, command-v to copy.
Any "menu choices" you already have in the other cells will be overwritten, so you might want to keep a backup so you can refer to, and restore, the original values.
SG
Chizzer wrote:
Screenshots.... the first cell has them all in the drop-down... 2nd and all other rows does not.
Once you have the Pop-Up menu values as you like them in one cell then you need to propagate them to the other cells. That does not occur automatically.
Select the cell, command-c to copy, select the cells below, command-v to copy.
Any "menu choices" you already have in the other cells will be overwritten, so you might want to keep a backup so you can refer to, and restore, the original values.
SG
You can certainly have more than 6 items in a pop-up menu. The limit is 250 items. You edit the list in Cell tab of the format sidebar. Hit the + to add an additional item.
You can also select multiple cells in a table (such as a column of cells), format them as pop-up menu, and all will become pop-up menus with those items on the list.
Hello there... thank you.
To clarify.... I have added new items, and when I go to use the drop-down in the field... they remove themselves from the list... gone. I have added them and saved the sheet over and over... I have quit numbers reopened and tried again, same results.
Screenshots.... the first cell has them all in the drop-down... 2nd and all other rows does not.
Yea, that did it, thanks kindly!
Numbers Pop-up menu - number of options?