电脑使用快捷键（The computer uses a shortcut key）.doc

电脑使用快捷键（The computer uses a shortcut key） Input data If you want to Press Select the last cell. Shift+Enter Complete the cell input and select the next cell to the right. Tab Complete the cell input and select the last cell to the left. Shift+Tab Repeat last operation. F4 or Ctrl+Y Fill down. Ctrl+D Fill right. Ctrl+R Define name. Ctrl+F3 Insert hyperlinks (Hyperlinks: text or graphics with colors and underscores, and then click on the files, files, locations, or pages on the world wide web, or on Intranet pages. Hyperlinks can also be moved to newsgroups or Gopher, Telnet, and FTP sites. Ctrl+K Input date. Ctrl+; (semicolon) Input time. Ctrl+Shift+: (colon) The numeric drop-down list in the current column of the display area. Alt+ down key Enter special characters Press F2 to edit cells, open Num Lock, and then click the following key with the numeric keypad: If you want to Press The input character of the cents. Alt+0162 The input character pound. Alt+0163 The input symbols for the yen. Alt+0165 Enter euro symbol?. Alt+0128 Enter and calculate the formula If you want to Press In the formula, the insert function dialog box appears. Shift+F3 Insert the auto sum formula with the SUM function. Alt+= (equals sign) Toggles between display cell values and display formulas. Ctrl+` (left single quote) Calculates all worksheets in all open workbooks. F9 if you select part of the formula, then calculate the selected part. Then you can replace the selected part by using the calculated values by Enter or Ctrl+Shift+Enter (for array formulas). Calculates all worksheets in all open workbooks, regardless of whether they were changed after the last calculation. Ctrl+Alt+F9 Re check the subordinate formula and then calculate all the cells in all open workbooks, including cells that are not marked for calculation. Ctrl+Alt+Shift+F9 Edit data If you want to Press Edit the active cell and place the insertion point at the end of the cell content. F2 Edit cell annotation. Shift+F2 Inse