Forum Discussion
I want to use Ctrl+Shift+Enter in Excel 365.
In Excel 365, I want to enter an array constant using Ctrl+Shift+Enter. But it doesn't work. Since I’m preparing for a certification, I need to enter the array constant using Ctrl+Shift+Enter so tha...
Excel 365 does not require the use of Ctrl+Shift+Enter.
For example, if you input ={1,2;3,4} in cell A1 and press Enter, it will spill the array automatically into range A1:B2.
However, if you still wish to input the array constant using Ctrl+Shift+Enter for the purposes of completing an outdated certification course, you will need to start by selecting the entire output range, A1:B2, then input the array constant, ={1,2;3,4}, and press Ctrl+Shift+Enter to commit the results to the entire range.
If you only have the first cell selected, A1 in this example, Ctrl+Shift+Enter will only return 1, which is the first element in the array.