Ctrl+Shift+1
The Ctrl+Shift+1, Ctrl+Shift+!, or ctrl+! keyboard shortcut is most commonly used to format the number in the selected cell to the comma number format in Microsoft Excel. Below are other programs that use this keyboard shortcut and related information.
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 number 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.
Related keyboard shortcuts and keys
Below are links to related keyboard shortcuts and individual key pages.