I have created a pop-up list in a cell in Numbers. The problem is the list is too long to have to scroll up and down. Is there a way that I can start typing what I am looking for? I am using this for an invoice, where I have a pop-up list of the items to select from when filling out invoice.
[Re-Titled by Moderator]
iPad Pro, iPadOS 17
N_Arias wrote:
Is there a way that I can start typing what I am looking for?
Yes. Numbers > Settings >General > Editing: Show suggestions when editing table cells
Include a list of cells with the items from your Pop-Up. (Format as Automatic, not Pop-Up). Hide those rows. When you start typing in the same column, Numbers will suggest matches.
Regards,
Ian.
N_Arias wrote:
Is there a way that I can start typing what I am looking for?
Yes. Numbers > Settings >General > Editing: Show suggestions when editing table cells
Include a list of cells with the items from your Pop-Up. (Format as Automatic, not Pop-Up). Hide those rows. When you start typing in the same column, Numbers will suggest matches.
Regards,
Ian.
If it is in alphabetical order, once you've opened it you can type the first letter to get to the top of that section. That's about it, though.
Good you are not going to use a popup. The limit is 250 items. It will not handle your 500+ items.
Hi N_Arias,
Here is a list. It could be from your Pop-Up Menu in any order. Or, you can sort ascending if you wish. The sort order makes no difference.
Row 1 is a Header Row. Rows 2 to 22 are the key words to give you a hint. Hide rows 2 to 22 and start typing:
From those hints, click on a hint to choose it, or continue to type
Regards,
Ian.
Thank you for your reply. That might work for me; I would have to play with it. However, it is going to be a lot of work because I will need to make a list of item names for the cells that I am going to hide and another list from where I will pull the price for the invoice and I have 500+ items. I will need to figure out if I can just type one list and copy to the other one. By the way, I was unable to find the Numbers Settings.
Thank you so much for the help.
Is there a way to ’search’ a pop up list in Numbers to avoid having to scroll through entire list?
