searching for a string in a Numbers file

It does not search table or sheet names or within formulas. It does search table cells, shapes, and text boxes. It will find a search word in a formula if the word appears in the result of the formula but this is because it is looking at the value of the cell not the formula itself. It searches all sheets and cannot be restricted to any particular sheet, table, or object.

It is finding your word in only one cell of one table probably because that is the only place that meets the criteria stated above.

I believe SGIII wrote a shortcut/script to search within formulas. I am not aware of anything to search table and sheet names but there are usually so few of them that they can be done manually without much effort.

nazoreos,

This might be stating the obvious, and if so I apologize. Knowing what data you might wish to locate in the future will inform how you design your document. There's a tendency want to be concise in the layout and not have extra columns and tables, but sometimes taking things in smaller steps, like putting input data or intermediate results in a separate column or table will make the documents easier to maintain.

Jerry