Set shortcut keys for Excel cell formatting

Using 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 improving 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 + ~: Apply the General number format

The 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.

We can compare it by using the normal method of right-clicking on a cell, selecting the command "format cells" from the pop-up menu, and then selecting General in the dialog box. It's certainly a lot of trouble compared to using shortcut keys.

Ctrl + Shift + $: Applies a currency number format with two decimal places (negative numbers in parentheses)

Ctrl + Shift +%: Apply percent format with no decimal digits

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

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

Ctrl + Shift +: Apply outer border to selected cells

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

Ctrl + B: Apply or cancel bold formatting

Ctrl + I: Apply or remove font italic formatting

Ctrl + U: Apply or remove underscores

Ctrl + 5: Apply or remove strikethrough

Ctrl + 1: Display the Format Cells dialog box

Ctrl + 0: Hide cell columns, three-link footage

Ctrl + 9: Hide cells in rows

Ctrl +-: Deletes the selected cells and pops up a dialog box to select

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