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.



[TABLE="class: grid, width: 192"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64, align: right"]10[/TD]
[TD="width: 64, align: right"]1[/TD]
[TD="width: 64, align: right"]9[/TD]
[/TR]
[TR]
[TD="align: right"]20[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD="align: right"]30[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]27[/TD]
[/TR]
[TR]
[TD="align: right"]40[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]36[/TD]
[/TR]
[TR]
[TD="align: right"]50[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]45[/TD]
[/TR]
[TR]
[TD="align: right"]60[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]54[/TD]
[/TR]
</tbody>[/TABLE]

 

[shg]

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