excle中所有的快捷键（国外英文资料）.doc

excle中所有的快捷键（国外英文资料） The best answer is in the help, for example, Im in 2007, and Im searching for the shortcut keys in the help, and you can find the Excel keyboard and the function keys, which are as follows Ctrl + shortcut The key that Ctrl + Shift + (unhide all hidden lines in the selected range. Ctrl + Shift +) unhide all hidden columns in the selected range. Ctrl + Shift + applies the outer box to the selected cell. Ctrl + Shift_ removes the outer box from the selected cell. Ctrl + Shift + apply normal digital format. The Ctrl + Shift + $application has two decimal currency formats (negative in parentheses). Ctrl + Shift + % application does not take the percentage format of the decimal place. Ctrl + Shift + ^ application index format with two decimal places. Ctrl + Shift + # applies a date format with dates, months, and years. Ctrl + Shift + @ applies the time format of hours and minutes and AM or PM. Ctrl + Shift +! The application has a numeric format with two decimal places, thousands of delimiters, and minus (minus) (for negative). Ctrl + Shift + * selects the current area of the active cell (a data area enclosed by blank lines and blank columns). In the data perspective table, it will select the entire data perspective table. Ctrl + Shift + : enter the current time. Ctrl + Shift + to copy the value from the cell above the active cell to the cell or edit column. Ctrl + Shift + + (+) displays the insert dialog that is used to insert a blank cell. The Ctrl + minus sign (-) displays the delete dialog box for removing the selected cell. Ctrl +; Enter the current date. Ctrl + ` switch shown in the worksheet cell value and formula. Ctrl + copies the formula from the cell above the active cell to the cell or edit column. Ctrl + 1 shows the cell format dialog. Ctrl + 2 to apply or uninstall the bold format. Ctrl + 3 application or untilting format Settings. Ctrl + 4 to apply or cancel the underscore. Ctrl + 5 application or undelete line. Ctrl + 6 switches betwe