You need to format numbers in Excel to make large values easier to read. Adding thousand separators manually is a slow process. The Ctrl+Shift+1 keyboard shortcut applies this format instantly. This article explains how the shortcut works and provides the steps to use it.
Key Takeaways: Excel Thousand Separator Shortcut
- Ctrl+Shift+1: Applies the Number format with two decimal places and a thousand separator to selected cells.
- Home > Number Format Dropdown > Number: The equivalent ribbon command for the same formatting.
- Ctrl+Shift+~ (Tilde): Reverts formatted numbers back to the General number format.
What the Ctrl+Shift+1 Number Format Does
The Ctrl+Shift+1 shortcut applies Excel’s built-in Number format. This format displays numbers with a comma as the thousand separator and shows two decimal places by default. For example, the value 1234567.89 becomes 1,234,567.89. This format does not change the underlying cell value, only its visual presentation.
The format is tied to your system’s regional settings in Windows. The comma separator is standard for regions like the United States. In European regions, the system may use a period as the thousand separator and a comma for decimals. The shortcut uses whatever separator is defined in Windows Settings > Time & Language > Region.
Prerequisites for Using the Shortcut
You must select one or more cells containing numerical data first. The shortcut works on a single cell, a range, or entire columns. It will not work on cells formatted as Text, even if they contain digits. You can apply it to blank cells, but the format will only be visible once a number is entered.
Steps to Apply the Thousand Separator Format
- Select your target cells
Click on a single cell or click and drag to select a range of cells with numbers. - Press the keyboard shortcut
Hold down the Ctrl and Shift keys, then press the number 1 key. Release all keys. The selected cells will instantly update to show the formatted numbers. - Verify the formatting
Look at the formatted cell. You should see commas separating thousands. Check the formula bar to confirm the original numerical value remains unchanged.
Using the Ribbon as an Alternative Method
If you prefer using the mouse, you can achieve the same result from the Home tab.
- Select your cells
Highlight the cells you want to format. - Navigate to the Number group
On the Home tab, find the Number group of commands. - Choose the Number format
Click the dropdown menu in the Number group. It typically shows “General.” Select “Number” from the list. This applies the identical format as Ctrl+Shift+1.
Common Mistakes and Formatting Limitations
Shortcut Does Nothing or Applies Wrong Format
If pressing Ctrl+Shift+1 has no effect, your cells may be formatted as Text. Text-formatted cells ignore number formatting shortcuts. Fix this by selecting the cells, going to Home > Number > dropdown, and choosing “General.” Then re-enter the numbers or use Paste Special > Values to convert them.
Needing Fewer or More Decimal Places
The default format shows two decimals. To increase decimal places, select the formatted cells and click the Increase Decimal button in the Home > Number group. To decrease decimals, click the Decrease Decimal button. You can also open the Format Cells dialog with Ctrl+1 to set a precise number of decimals.
Removing the Thousand Separator Format
To revert to a plain number without commas, use the Ctrl+Shift+~ shortcut. This applies the General format. Alternatively, use the ribbon dropdown on the Home tab and select “General.” This removes all specific number formatting.
Keyboard Shortcuts for Related Number Formats
| Format Style | Keyboard Shortcut | Ribbon Path |
|---|---|---|
| Number with thousand separator | Ctrl+Shift+1 | Home > Number > Number |
| General format (no specific format) | Ctrl+Shift+~ (Tilde) | Home > Number > General |
| Time format | Ctrl+Shift+@ | Home > Number > Time |
| Date format | Ctrl+Shift+# | Home > Number > Short Date |
| Currency format | Ctrl+Shift+$ | Home > Number > Currency |
| Percentage format | Ctrl+Shift+% | Home > Number > Percentage |
You can now format large numbers for readability in one keystroke. Use Ctrl+Shift+1 on financial data or any column of figures. Try the Ctrl+Shift+$ shortcut next to apply a currency symbol. For advanced control, remember that Ctrl+1 opens the full Format Cells dialog where you can create a custom number format.