Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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.


Posted on Jul 11, 2021 3:50 AM

Reply
Question marked as Top-ranking reply

Posted on Jul 11, 2021 4:49 AM

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

1 reply
Question marked as Top-ranking reply

Jul 11, 2021 4:49 AM in response to shreenureddy

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

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.