Skills of using "Ctrl+Shift + number" Shortcut Keys in Excel

Original title: "have you ever used the shortcut key" Ctrl+Shift + number "? "

Today, I'd like to share with you some super-useful shortcuts in Excel, "Ctrl + Shift + numeric keys". You can quickly modify the cell format. Let's take a look.

1. Shortcut key for number format: Ctrl + Shift + 1

Function: set to "number format", round the decimal to an integer, and add a thousand separator.

2. Shortcut key for time format: Ctrl + Shift + 2

Function: set to "time format" to convert the numerical value into time format.

3. Shortcut key for date format: Ctrl + Shift + 3

Function: set to "date format" to convert the numerical value into a date format.

4. Shortcut key for currency format: Ctrl + Shift + 4

Function: set to "currency format", add a currency symbol to the value, a thousand separator, and retain two decimal places.

5. Shortcut key for percentage format: Ctrl + Shift + 5

Function: set to "percentage format" to convert the numerical value to the percentage format.

6. Shortcut key for scientific counting: Ctrl + Shift + 6

Function: set to "scientific counting" to change the numerical value into scientific counting format.

7. Add the shortcut key of outer frame line: Ctrl + Shift + 7

Use: applies the outline border to the selected cell.

Use: select the area where you need to add an outer border, and then use the shortcut key "Ctrl + Shift + 7" to add it.

8. Quickly select the entire table shortcut: Ctrl + Shift + 8

Use: select the current range around the active cell.

Use: position the mouse over any area of the table and use the shortcut key "Ctrl + Shift + 8" to quickly select the entire table.

This article comes from the official account of Wechat: Word Alliance (ID:Wordlm123), author: Wang Wangqi