- Control keyboard shortcuts in Excel for the web by overriding browser keyboard shortcuts. Excel for the web works in a browser. Browsers have keyboard shortcuts, some of which conflict with shortcuts that work in Excel on the desktop.
- Assigning a shortcut to an existing macro In Excel 2010 and 2007, from the View tab, click Macros, and then select View Macros. In Excel 2003 and earlier, from the Tools menu, select Macro, and then Macros. A dialog box containing all macros in all open workbooks will appear.
Related articles:
Excel Shortcuts - List of the most important & common MS Excel shortcuts for PC & Mac users, finance, accounting professions. Keyboard shortcuts speed up your modeling skills and save time. Learn editing, formatting, navigation, ribbon, paste special, data manipulation, formula and cell editing, and other shortucts.
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 |
In Microsoft Excel, it is often easier to assign a macro to a shortcutkey combination (e.g., in Windows, Ctrl-r
, and inMac OS X, Option-Command-r
) than to abutton. You can assign the key when you create the macro or afteryou've created it. Follow the appropriate directions below.
Assigning a shortcut to a new macro
- In Excel 2010 and 2007, from the View tab, clickMacros, and then select Record Macro.... The
Record Macro
dialog box will appear.In Excel 2003 and earlier, from the Tools menu, selectMacro, and then Record New Macro....
- In the 'Macro name:' field, enter a name for your macro.
- In the 'Shortcut key:' field, choose the key you would like topress in conjunction with the
Ctrl
key (in Mac OS X,Option-Command
) to trigger the macro. This can be any key,but you should check the key combination before assigning it to amacro. Excel has some predefined key combinations that you will eraseif you assign one of your macros to the same key. - The save/store option allows you to choose where you would like tostore the macro and key combination. If the macro isdocument-specific, from the drop-down menu, choose ThisWorkbook. If you would like to save the macro and key in a newworkbook, choose New Workbook. If you would like to save themacro to your permanent macro workbook, choose Personal MacroWorkbook. This will keep the macro and key combination active nomatter what you are working on.
- Click OK, and then create your macro as usual.
Assigning a shortcut to an existing macro
Microsoft Excel 2010 Shortcut Keys Mac Photoshop
- In Excel 2010 and 2007, from the View tab, clickMacros, and then select View Macros.
In Excel 2003 and earlier, from the Tools menu, selectMacro, and then Macros....
- A dialog box containing all macros in all open workbooks willappear. Click the macro for which you would like to create a keycombination, and the name will appear in the field on top of the list.
- Click Options.... A dialog box that containsinformation about the macro will open.
- In the 'Shortcut Key:' field, enter the key you wish to assign inconjunction with the
Ctrl
key (in Mac OS X,Option-Command
) to trigger the macro. This can be any key,but you should check the key combination before assigning it to amacro. Excel has some predefined key combinations that you will eraseif you assign one of your macros to the same key. - Click OK as needed to close any open dialog boxes.