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.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I found the shortcut for search and replace within a selected column, but...what if you only want to search? For example, my research log includes 1,000+ entries. I need to manually review all citations in Column Q that include the words "kirk session." Don't want to change them; just take a quick look.
(Tried editing the shortcut linked above, but couldn't get it to function properly, drats.)
MacBook Pro (M1, 2020)
The cell has to contain the exact thing you are searching for. If the cells you are looking for have "Kirk Cousins" in them, you need to search on "Kirk Cousins", not "Kirk". Case does not matter, though. It is comparing your search term to the value of the cell. "Kirk" is not equal to "Kirk Cousins".
paperqueen wrote:
@Badunit,
Soooo...a search for "kirk" only works if "kirk" is the only word in a cell?
Would hit on kirk cousins, kirk session, kirk• register(provided "kirk" has a space after it.)
Might exclude kirkyard (as part of a different word)
Now that know the specifics, should be able to modify shortcut to do this.
SG
@Badunit,
Soooo...a search for "kirk" only works if "kirk" is the only word in a cell?
Forgive me if I'm missing something obvious, but in my mind, a search for "kirk:"
If yes, the Shortcut won't work. As noted in the OP, the column I'd like to search to contains source citations (i.e., lots of text).
@SGIII,
Hmmm...looked promising, but when I run it....
Hi paperqueen,
Try a filter with Text contains kirk session.
Regards,
Ian.
I'm a little confused. Why do you need a shortcut to find in Numbers when Numbers has this functionality built in?
Come to think of it, Numbers also has a Find and Replace feature, so I'm not sure what this shortcut is meant to achieve.
Here is this shortcut similar to the 'Find Replace in Selection' shortcut to which you linked:
Find Occurrences in Selection.
A filter is better if you expect a large number of "hits" and just want to view those rows.
This shortcut can be better than a filter in situations where you want to cycle through and view the values in their original context in the table (i.e. still see the rows above and below the ones that contain your search term).
Unlike the built-in Find and Replace in Numbers, this shortcut searches only in the range you have selected rather than the entire document.
SG
I should have been more clear.
The phrase "kirk session" appears in multiple columns. Using the normal text search scans the entire document, hitting on dozens (and dozens and dozens) of occurrences I don't want to review.
Limiting the search to one specific column is the goal.
Does that help clarify things a bit?
Search--but not replace--in selected column
