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

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

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.