EXCEL的快捷键操作明细（国外英文资料）.doc

EXCEL的快捷键操作明细（国外英文资料） When compiling the audit manuscript, EXCELs shortcut key operation is detailed Work table Shift + F11 or Alt + Shift + F1 Insert the new worksheet. Ctrl + Page Down Move to the next worksheet in the workbook. Ctrl + Page Up Move to the last worksheet in the workbook. Shift + Ctrl + Page Down Select the current worksheet and the next worksheet. To cancel the selected multiple worksheet, press Ctrl + Page Down or, if you want to select another worksheet, press Ctrl + Page Up. Move within the selected area Enter Move from top to bottom in the selected area. Shift + Enter Move from the bottom up in the selected area. The Tab Move from left to right in the selected area. If you select the cell in a single column, move down. Shift + Tab Move from right to left in the selected area. If you select the cell in a single column, move up. Ctrl + end Move clockwise to the next corner of the selected area. Ctrl + Alt + to the right In the non-adjacent selected area, switch to the right to the next selected area. Ctrl + Alt + to the left To the left, switch to the next non-adjacent selected area. Select cells, rows, and columns and objects Ctrl + spacebar The selected column. Shift + spacebar Select the entire line. Ctrl + A Select the entire worksheet. Shift + Backspace When multiple cells are selected, only the active cell is selected. Ctrl + Shift + spacebar In the case of a selected object, select all the objects on the worksheet. Ctrl + 6 Toggle between the hidden object, the display object, and the display object placeholder. Keys to input, edit, format, and calculate data The input data Enter Complete the cell input and select the next cell. Alt + Enter Change lines in the cell. Ctrl + Enter. Fill the selected cell area with the current input item. Shift + Enter Complete the cell input and select the previous cell. The Tab Complete the cell input and select the next cell to the right. Shift + Tab Complete the cell input and select a cell from the left.