lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
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.
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 |