Excel Hack

Formatting shortcuts in Excel

Excel provides a number of useful shortcut keys for changing the formatting of data entered in cells. Various functions exist, such as shortcuts for changing the appearance of text, such as bold and underline, etc. In this article, we will introduce shortcuts for applying specific formats to cells. By using these shortcuts to change the formatting of cells and make them look better, you should be able to manage your data more easily.

Formatting shortcut

Display the Format Cells dialog box with the font tab open

Windows
Ctrl + Shift + F or Ctrl + Shift + P
Access Key: Alt + H + F + N

Mac
control + shift + P

Apply general format

Windows
Ctrl + Shift + ~ (tilde)

Mac
control + shift + ~ (tilde)

Apply currency format

Windows
Ctrl + Shift + $ (dollar)

Mac
control + shift + $ (dollar)

Apply percentage format

Windows
Ctrl + Shift + % (percent)

Mac
control + shift + % (percent)

Apply scientific format

Windows
Ctrl + Shift + ^ (caret)

Mac
control + shift + ^ (caret)

Display the Format Cells dialog box with the font tab open

This is a shortcut key that brings up the Format Cells dialog box with the font tab open.

Total Time: 1 minute

Select a cell

Select a cell

Select the cells for which you want to change the format.

The Format Cells dialog box appears

The Format Cells dialog box appears

Press Ctrl + Shift + F or Alt + H + F + N to display the Format Cells dialog box. With the font tab open, the Format Cells dialog box could be displayed.

Number formatting

Apply general format

Select a cell

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

Press Ctrl + Shift + ~

Press Ctrl + Shift + ~ (tilde) to apply the general format.

Apply currency format

Select a cell

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

Press Ctrl + Shift + $

Press Ctrl + Shift + $ (dollar) to apply the currency format.

Apply percentage format

Select a cell

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

Press Ctrl + Shift + %

Press Ctrl + Shift + % (percent) to apply the percentage format with no decimal places.

If you want to display the number of decimal places, you must make the setting from the Format Cells dialog box.

Press Ctrl + 1

Press Ctrl + 1 to display the Format Cells dialog box.

Press N to select the number tab. Press Alt +D to select decimal places, then press (Up Arrow key) to select how many decimal places to display.

Decimal point displayed

Press Enter to apply the percentage format with the number of decimal places displayed.

Apply scientific format

Select a cell

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

Press Ctrl + Shift + ^

Press Ctrl + Shift + ^ (caret) to apply the scientific form.

Articles related to Format & Shortcut

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments