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 desktop still supports Ctrl + Shift + Enter. There is no setting you need to enable for it.
Try these checks:
- Test in desktop Excel. If you are using Excel in a browser or an exam simulator, try the installed Excel application first.
- 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.
- 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.
- Try the other Ctrl and Shift keys, or another keyboard. Temporarily close keyboard-remapping tools and apps that use global shortcuts.
- 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?