microsoft office keyboard shortcuts 2010

If you prefer using the Alt key, you should clear the Transition Navigation Keys check box. If Transition Navigation Keys is selected, then the slash character shown in the Microsoft Office Menu Key will be used instead of Alt to invoke shortcuts. In the Advanced category, scroll to near the bottom for Lotus Compatibility. To do so, select the Office icon and then select Excel Options. You should check the setting before proceeding. It is possible that you turned on this setting in Excel 1995 and each successive upgrade of Excel has inherited the setting. Note that an arcane command exists in the Excel Options dialog that can cause the new keyboard accelerators not to work for you. Notice that Excel places a ToolTip above each command, with an associated accelerator key. To access the new accelerators, press and release the Alt key.

Excel 2010 tries to ensure that every command can be invoked from the keyboard. In legacy versions of Excel, many popular commands had keyboard accelerators, but other commands did not.

The goal of the new Excel 2010 keyboard accelerators is to allow you to access every command by using only the keyboard. This chapter points out which of the old keyboard shortcuts still work, shows you some new shortcuts, and introduces you to the new keyboard accelerators. For instance, Ctrl+C still copies a selection, Ctrl+X cuts a selection, and Ctrl+V pastes a selection. In addition, many of the old Alt keyboard shortcuts still work and all the old Ctrl shortcut keys are still functional. Excel 2010 introduces new keyboard accelerators accessed using the Alt key. If you do a lot of typing, being able to access commands from the keyboard is faster than moving your hand to the mouse.

Microsoft office keyboard shortcuts 2010