Searching in Numbers
Cannot search a number f ex 23, it finds 2300 etc
I just want to find 23
Have you tried clicking the "gear" icon and choosing 'Whole Words'?
SG
15 replies
You were right. This is easy to miss. It should be default.
One more question reguarding SEARCH.
While using categories which are collapsed, Numbers cannot find the search.
One has to expand all categories ? if I have 10 sheets, can I expand the categories all at one click ?
Hi Bomiboll,
I started to type a reply, then I deleted it.
Bomiboll wrote:
Another search problem is that Numbers does not find the name of a table
Type the table name in a spare cell in each table. (You could add another Header Row to make a spare row).
Regards,
Ian.
"I can do that but is not a nice solution"
I think it's the nicest you'll find.
Find, in Numbers, will not search text boxes, sheet names or table names, but it will search table cells.
Regards,
Barry
I tested with Excel. There is no such issue there.
If I search 4 it will find 4 and not 34 or 45 etc
Do you mean Smart Categories in tables (not sheets)? I don't know of a way to expand them in 10 tables at once.
SG
What do you mean smart categories in sheets ? I only know of categories in tables
if I have 10 sheets, can I expand the categories all at one click
I was responding to the wording of your post above.
SG
Another search problem is that Numbers does not find the name of a table
.
I do not understand what you refer to, Apr 16 ??
I can do that but is not a nice solution
Is this mentioned in the help files ?
This forum is the best help file 😎
OK Yellow
Searching in Numbers