I’m using Apple numbers and I would like to know how to do something. I have a list of 200 names on a spreadsheet. I would like to create a cell in which if I begin to type a person’s name, or a combination of a name on the list, it would automatically narrow that list to the names that apply to what I typed. Does anyone know how to do this or know what it’s called?
In some variations its called auto complete.
Numbers has an included version that works automatically, but requires the list of items to be in the same column of the same table.
The feature is turned on and off with a preference setting in Numbers Preferences:
First checkbox in the Editing section.
Note that this is a global setting which applies to ALL Numbers documents if it is turned on.
The feature automatically builds a list of all entries made in a column, and shows a list of all items matching what you have typed so far in a new cell in that column. You can click an item in the list at any time to immediately enter it in the current cell.
Regards,
Barry
Thanks! I gave it a quick try and it did work. I'll see later on if it'll work if I hide the column. Thanks for responding and for the helpful information!
Create a searchable box in Apple numbers
