Excel Hack

Shortcut for number format in Excel

If you want to add a delimiter to a number entered in a cell, or display it to two decimal places, you can apply a number format to the cell. To apply numeric formatting to a cell, you need to select tools from the ribbon, or display the Format Cells dialog box and select format. However, if you use the shortcut keys shown below, you can apply a number format without taking your hands off the keyboard.

Number format shortcut

Windows
Ctrl + Shift + 1

Mac
command + shift + 1 or control + shift + 1

How to apply number formatting to cells

We will show you how to apply number formatting to cells using the shortcut keys.

Total Time: 1 minute

Select a cell

Select a cell

Select the cells to which you want to apply the number format.

Number format applied

Number format applied

Press Ctrl + Shift + 1 to apply the number format.