showing results of an array formula

[lezawang]

Hi
I did simple formula = range1 - range2 and then hit ctrl+alt+enter and I got -2. By accident, I double clicked on -2 and went inside the cell in edit mode then I click anywhere outside that cell, then excel showed me the result as you can see below:

My question, how can I get excel to display the result like that without me double clicking the cell then click outside (that was by accident).
Also please, I entered ctrl+alt+enter to make the formula array formula. I remember around 1 year ago, ExcelIsFun said in one his video that the Office 365, you do not need to enter Ctrl+Alt+delete anymore, did I hear that right? Thank you very much.

Book2
	A	B	C	D
1	1	3
2	1	1
3	1	1
4	1
5	1
6
7				-2
8				0
9				0
10				#N/A
11				#N/A
12
Sheet1

Cell Formulas
Range	Formula
D7:D11	D7	=range1-range2
Dynamic array formulas.

Named Ranges
Name	Refers To	Cells
range1	=Sheet1!$A$1:$A$5	D7
range2	=Sheet1!$B$1:$B$3	D7

 

[Fluff]

My question, how can I get excel to display the result like that without me double clicking the cell then click outside (that was by accident).

Just enter the formula normally (ie without CSE)