I want to use Ctrl+Shift+Enter in Excel 365.

If you’re trying to enter an older array formula, Ctrl+Shift+Enter should still work in Excel 365. That said, newer dynamic-array formulas usually don’t need it anymore - just press Enter and let Excel spill the results automatically.

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.

Excel 365 desktop still supports Ctrl + Shift + Enter. There is no setting you need to enable for it.

Try these checks:

1. Test in desktop Excel. If you are using Excel in a browser or an exam simulator, try the installed Excel application first.
2. Make sure you are editing the formula. In a blank workbook, select A1, type ={1,2,3}, then hold Ctrl and Shift while pressing Enter. Pressing the shortcut after leaving edit mode will not convert the formula.
3. Check the formula bar. Excel should add the outer braces, showing {={1,2,3}}. The cell results alone may look identical whether the shortcut worked or not.
4. Try the other Ctrl and Shift keys, or another keyboard. Temporarily close keyboard-remapping tools and apps that use global shortcuts.
5. Test Excel Safe Mode on Windows: close Excel, press Win + R, enter excel /safe, and repeat the test. If it works there, disable add-ins one at a time under File > Options > Add-ins in normal Excel to identify the conflict.

The test formula uses English/US separators. If Excel rejects the formula itself, your regional settings may require different separators.

When you press the shortcut, does nothing happen, does another action occur, or does Excel accept the formula without adding the outer braces? Also, are you testing in desktop Excel or the certification software?