You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

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.