Updated: 05/01/2023 by Computer Hope
The Ctrl+Shift+1, Ctrl+Shift+!, or ctrl+! keyboard shortcut is used to format the number in the selected cell to the comma number format in Microsoft Excel.
How to use the Ctrl+Shift+1
To use this keyboard shortcut, press and hold either Ctrl and Shift key, and while continuing to hold them, press the 1 key.
Ctrl+Shift+! in Microsoft Excel
Pressing Ctrl+Shift+! in Microsoft Excel formats the number in the selected cell to the comma format. For example, instead of a cell showing "1000000", it would show "1,000,000" with comma format.
Ctrl+Shift+1 in Google Sheets
Pressing Ctrl+Shift+1 in Google Sheets formats the number in the selected cell to decimal format. For example, instead of a cell showing "100", it would show "100.00" with decimal format.
Below are links to related keyboard shortcuts and individual key pages.
Comma, Exclamation mark, Keyboard shortcut, Keyboard terms