Number Formatting Keyboard Shortcuts

Mpatswe Francis

13 January 2024 • 150 Views • 0 Share • Published in Technology

In Excel, you can use keyboard shortcuts to quickly apply number formatting to cells. Here are some common number formatting keyboard shortcuts:

Ctrl + Shift + $:
- Applies the Currency format.
Ctrl + Shift + %:
- Applies the Percentage format.
Ctrl + Shift + #:
- Applies the Date format.
Ctrl + Shift + @:
- Applies the Time format.
Ctrl + 1:
- Opens the Format Cells dialog box, where you can choose various formatting options, including number formatting.
Ctrl + Shift + !:
- Applies the Number format with two decimal places, a comma as a thousands separator, and a minus sign (-) for negative values.
Ctrl + Shift + ^:
- Applies the Scientific format.
Ctrl + Shift + ~:
- Applies the General format.

Remember, these shortcuts are applicable when a cell or a range of cells is selected. If you have specific formatting needs or if you want to customize the formatting further, you can use the Format Cells dialog (Ctrl + 1) to access a wide range of formatting options.