Search limited to a sheet or table in Numbers
When I search in Numbers, it searches the whole file and gives all the occurrences of it in the whole file, which is very confusing. Is there a way to search the current table in which I am working.
When I search in Numbers, it searches the whole file and gives all the occurrences of it in the whole file, which is very confusing. Is there a way to search the current table in which I am working.
The native search in Numbers searches the whole document. There are not options to search only part of a document.
However, you can use this Find in Selection Automator Service (Dropbox download) to search within selected cells.
One installed, you select a range of cells in a table and choose Find in Selection from the Numbers > Services menu.
To install just double-click the downloaded package and give permission at System Preferences > Security & Privacy.
Also make sure Automator.app is listed and checked at System Preferences > Security & Privacy > Privacy > Accessibility.
SG
The native search in Numbers searches the whole document. There are not options to search only part of a document.
However, you can use this Find in Selection Automator Service (Dropbox download) to search within selected cells.
One installed, you select a range of cells in a table and choose Find in Selection from the Numbers > Services menu.
To install just double-click the downloaded package and give permission at System Preferences > Security & Privacy.
Also make sure Automator.app is listed and checked at System Preferences > Security & Privacy > Privacy > Accessibility.
SG
Search limited to a sheet or table in Numbers