Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this community
Some formulas (ARRAYFORMULA, QUERY) can yield values that "spill over" into neighboring cells, as described here: https://support.google.com/docs/answer/6208276?hl=en.
When you select the cell where the array-valued formula is specified, you can see the formula definition. However, if you select cells that were "spilled into", you only see its calculated value.
Is there a way to tell that a cells value is being governed by a "neighboring" formula?
To quickly find if a cell is filled by an array formula or an array expression, select the cell and press Delete. If the value in the cell disappears completely, it is not filled by an array formula. You can then choose Edit > Undo to restore the value in the cell.
If the value gets erased for a second, but then almost immediately gets restored, there must be an array formula to the left or up of the cell that fills it.
If the cell you are interested in is blank to start with, insert the character a in the cell. That will cause any array formula to the left or up of the cell to show a #REF error. Delete the a to re-enable the array formula.
