Numbers

Hi Franchuk,

Badunit's suggestion, "Change one then copy/paste or drag-fill or use some other method to do the rest," assumes that the pop-up menu cells all contain the same list of menu items. If that is the case, setting one menu to 'blank', copying that cell, and filling it or pasting it into the others will do the job.

If the menu lists are different in each cell, you will need to set them individually. For that case, looking to the future, I would suggest you:

• Set all of the menus to 'blank,'

then working with each contiguous group of menus, Select and Copy the column containing those menus.

• Click on an empty space on 'this sheet' or a separate sheet, then Paste

Numbers will create a new, single column table containing copies of all the copied menus, each set to 'blank'.

For future resets:

• Select and copy the (first) set of 'reset' menu cells from the 'new' table.
• Select the first cell of that set of 'used' menu cells and Paste
• Repeat with the other sets as needed.

Regards,

Barry

No, you have to change them yourself. Change one then copy/paste or drag-fill or use some other method to do the rest.