Excel cell formatting shortcut keys

The

Use of shortcut keys in your application allows us to avoid switching back and forth between the keyboard and the mouse, saving a lot of time and significantly increasing productivity. Master some of the most commonly used shortcuts, you can bid farewell to the rookie era, rapid growth for the computer application of the master. The following shortcuts are used to format cells in Excel and are sure to help you.

Ctrl + Shift + ~: Applying the General number format

General format does not contain a specific number format, which is equivalent to selecting General on the Number tab in the Format Cells dialog box. such as the original number format is "currency" or "percent" form, use this shortcut to clear these formats, revert to the normal format.
(footage)
We can compare it by using the normal method of right-clicking on a cell, selecting the command from the pop-up menu, formatting cells, and then selecting General in the dialog box. It's certainly a lot of trouble compared to using shortcut keys.

Ctrl + SHIFT + $: Apply the currency number format with two decimal places (negative numbers in parentheses)

Ctrl + SHIFT +%: Apply the percent format without decimal places

Ctrl + SHIFT + ^: Apply the scientific notation number format with two-bit decimal places

Ctrl + Shift +!: Applies the number format with two-bit decimal places, thousands separators, and minus sign (-) for negative numbers

Ctrl + Shift +: Apply to Selected cells Border

Ctrl + Shift + _: Deselect the outer border of the selected cells

Ctrl + B: Apply or remove bold formatting

Ctrl + I: Apply or remove font italic formatting

Ctrl + U: Apply or Cancel Underline

Ctrl + 5: Apply or remove strikethrough

Ctrl + 1: Display the Cell Formatting dialog box

Ctrl + 0: Hide the column of the cell

Ctrl + 9: Hide the cell's row
Ctrl +-: Deleting the selected cells pops up a dialog box to select

You can practice several times in Excel, and you will notice that some shortcuts are easier to remember, such as "CTRL + Shift +%" corresponds to "percent", "Ctrl + I" "is to set italics and so on. When you are familiar with these shortcuts, you willFree from the tedious mouse operation!