Set shortcut keys for Excel cell formatting

Source: Internet
Author: User

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!

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.