What I mean in the title is if I want to looking for just only the part of formula's word such as =ArrayFormula( in one hit from the menu bar like Search > Formula.
Asked
Active
Viewed 64 times
0
halfer
- 19,824
- 17
- 99
- 186
Deby Ferdian
- 69
- 3
- 9
-
Not sure what your issue is, you can specify to search formulas' contents in the search dialogue. – Robin Gertenbach Apr 10 '17 at 06:56
-
Oh my God thank you It's so useful for me I have just know this. Thanks again! – Deby Ferdian Apr 10 '17 at 12:32
-
1@halfer I posted an answer – Robin Gertenbach Apr 11 '17 at 16:50
1 Answers
1
When pressing Ctrl+F the search dialog appears
Clicking on the three dots makes a dialog appear.
By default formulas' contents are not searched
Ticking "Also Search within Formulae" will change the display of all cells containing formulae and search those too.
Robin Gertenbach
- 10,316
- 3
- 25
- 37