array operation

[lezawang]

Hi
I just watched a video and he said that to do

=A1:A6-B1:B6

I need to press CTRL+Shift+Enter

I selected cells C1:C6 then typed =A1:A6-B1:B6, in cells C1 and pressed Ctrl+Enter only and I got the right answers. So how come that works without using Array? I am a bit confused here.
Thank you.

10	1	9
20	2	18
30	3	27
40	4	36
50	5	45
60	6	54

<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[shg]

Excel is using an implied intersection, which you can Google to read about.