You activate Excel 2010 hot keys by pressing the Alt key before you type the mnemonic letter for a particular task. Hot key sequences for the most common formula-related commands in Excel 2010 begin with the sequence Alt+M because the M in forMulas was the only mnemonic key still available (F is assigned to the File menu commands). After you know to press Alt+M to access Formula tab commands, it’s pretty easy sailing.
| Hot Key | Excel Ribbon Command | Function |
|---|---|---|
| Alt+MF | Formulas→Insert Function | Opens the Insert Function dialog box (same as clicking the Insert Function button on the Formula bar |
| Alt+MUS | Formulas→AutoSum→Sum | Selects the occupied range above the cell cursor and inserts SUM formula to total the range |
| Alt+MUA | Formulas→AutoSum→Average | Selects the occupied range above the cell cursor and inserts AVERAGE formula to calculate the average of total in the range |
| Alt+MUC | Formulas→AutoSum→Count Numbers | Selects the occupied range above the cell cursor and inserts COUNT formula to count the number of values in the range |
| Alt+MI | Formulas→Financial | Opens a drop-down menu listing all Financial functions — click name to insert function into current cell |
| Alt+ME | Formulas→Date & Time | Opens a drop-down menu listing all Date and Time functions — click name to insert function into current cell |
| Alt+MN | Formulas→Name Manager | Opens Name Manager dialog box showing all range names in workbook where you can add, edit, and delete names |
| Alt+MMD | Formulas→Define Name | Opens New Name dialog box where you can assign a name to the cell selection or define a new constant |
| Alt+MS | Formulas→Use in Formula | Displays drop-down menu with range names in workbook that you can insert into current formula by clicking |
| Alt+MC | Formulas→Create from Selection | Opens Create Names from Selection dialog box where you indicate which rows and columns to use in naming cell selection |
| Alt+MH | Formulas→Show Formulas (Ctrl+`) | Displays and then hides all formulas in cells of the worksheet |
| Alt+MXA | Formulas→Options→Automatic | Turns automatic recalculation back on |
| Alt+MXE | Formulas→Options→Automatic Except for Data Tables | Turns automatic recalculation back on for all parts of the worksheet except for ranges with Data Tables |
| Alt+MXM | Formulas→Options→Manual | Turns on manual recalculation |
| Alt+MB | Formulas→Calculate Now (F9) | Recalculates formulas throughout the entire workbook when manual recalculation is turned on |
| Alt+MJ | Formulas→Calculate Sheet (Shift+F9) | Recalculates formulas in the current worksheet when manual recalculation is turned on |
dummies
Source:http://www.dummies.com/how-to/content/hot-keys-for-common-excel-2010-formula-commands.html
No comments:
Post a Comment