Determining Which Commands Work in Legacy Mode It happens that O is the shortcut on the File menu for Open, so pressing Alt+F+O in Excel 2010 also performs File, Open.įigure 5.7 The Office 2003 access key ToolTip shows which keys you have used so far while entering a legacy shortcut.
In Excel 2003, pressing Alt+F+O performs File, Open. Some of the keyboard shortcuts associated with the File menu in Excel 2003 continue to work in Excel 2010. Alt+H takes you to the Home tab instead of the few commands on the Help menu, and Alt+W takes you to the View tab. None of the keyboard accelerators associated with Window or Help work in Excel 2010. If you are moving from Excel 2003 to Excel 2010, you will have the best success when trying to access commands on the Edit, View, Insert, Format, Tools, and Data menus. The keyboard accelerator commands in Excel 2003 were Alt+F, Alt+E, Alt+V, Alt+I, Alt+O, Alt+T, Alt+D, Alt+W, and Alt+H. In Excel 2003, the main menus were File, Edit, View, Insert, Format, Tools, Data, Window, and Help. If you were an intermediate Excel user who regularly used the Excel 2003 keyboard accelerators but had to look at the screen to use them, you should start using the new keyboard accelerators discussed at the beginning of this chapter. However, there is good news for the power Excel gurus who have favorite Alt shortcut keys burned into their minds-most of them will continue to work as they did in Excel 2003. If you have some of these commands memorized, when you hear that the menu in Excel 2010 is completely gone, you might be worried that you have to relearn all the shortcut keys. If you are a power Excel user, you probably have a few of these commands memorized, such as Alt+E+I+J for Edit, Fill, Justify Alt+E+S+V for Edit, Paste Special, Values and Alt+D+L for Data Validation. Then you can perform the Justify command by pressing J. Instead of pressing Alt+E+I+J all at once, when the Edit menu is displayed, you can display the Fill flyout menu by pressing I. Figure 5.6 Pressing Alt+E+I+J performs Edit, Fill, Justify.
0 kommentar(er)
