I wonder how does work the following and is it documented somewhere?
I have the sheet:
A B ----------------- 1 2 3 =$A:$A 4 5 =$A:$A
For column B (row 3 and 5) I see corresponding values from column A. It looks like
=$A:$A (or even
=$A$2:$A$5 etc) works like
=$A$5 in some automagical manner (and no needs to specify different formulas for every cell in B).
I like such behaviour but wish to be sure that it is a reliable solution.