Timeline for How to see which formulas reference a given cell in Google Sheets?
Current License: CC BY-SA 4.0
16 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 4, 2023 at 8:25 | comment | added | törzsmókus | this does not find references via ranges (except when it is one of the start:end cells), let alone named ranges | |
| Mar 24, 2023 at 7:50 | comment | added | Pierre-Luc Paour |
To exclude A50, the regex can be improved to \$?A\$?5\D (not a digit after 5). It's incredible GSheet still does not do this natively, when Excel has had this feature for years.
|
|
| Feb 10, 2023 at 6:10 | comment | added | Roberto | Caveat: may not work if you are using things like VLOOKUP, MATCH, INDEX... | |
| Jun 16, 2022 at 13:26 | comment | added | Rubén - Volunteer Moderator -♦ | @HeathRaftery Thanks for your reply, regular expression fixed. | |
| Jun 16, 2022 at 13:20 | history | edited | Rubén - Volunteer Moderator -♦ | CC BY-SA 4.0 |
Fix regular expression
|
| Jun 16, 2022 at 11:38 | comment | added | Heath Raftery |
I've suggest an edit. Until it is approved, it is that the regex appears to be wrong and should have been \$?A\$?5, but you may as well expand it to ^=.*\$?A\$?5 to only search for formulas.
|
|
| Jun 16, 2022 at 11:36 | review | Suggested edits | |||
| Jun 16, 2022 at 13:17 | |||||
| Jan 28, 2022 at 16:13 | comment | added | Eugene Kaurov | Any idea how to find formula linking to A6? The formula is A5:A8 so regular expression '$?A:$?5' will not find it. | |
| Jan 23, 2022 at 20:32 | comment | added | Rubén - Volunteer Moderator -♦ | @cellepo In the Find and Replace dialog, click the Search dropdown and select This Sheet. | |
| Jan 23, 2022 at 20:23 | comment | added | cellepo | Anyone know how to search only within same tab/sheet? | |
| Nov 4, 2021 at 17:46 | comment | added | Rubén - Volunteer Moderator -♦ | @MegaMatt Thanks. I added a related tip. | |
| Nov 4, 2021 at 17:45 | history | edited | Rubén - Volunteer Moderator -♦ | CC BY-SA 4.0 |
Added a tip
|
| Nov 4, 2021 at 17:16 | comment | added | MegaMatt | I'd also suggest looking for version with dollar signs: $A5 and $A$5 | |
| Oct 21, 2021 at 22:05 | comment | added | Luca Bezerra |
Adding to this, use Cmd+Shift+H on a Mac to open the dialog. Alternatively, go to the Edit menu and click on Find and Replace.
|
|
| Jan 8, 2017 at 22:46 | vote | accept | trusktr | ||
| Jan 8, 2017 at 21:55 | history | answered | Rubén - Volunteer Moderator -♦ | CC BY-SA 3.0 |