![]() 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |