![]() ![]() The big three continue to work: Alt+F+O is File, Open, Alt+F+N is File, New. Alt+F opens the File menu, where you are supposed to use the new shortcut keys. Gotcha: Only some of the keystrokes from the old File menu continue to work. I can't imagine anyone memorizing Alt+HA to open the Help, About dialog.) The F1 keystroke still invokes help. (Although"¦ there wasn't that much helpful on the old Help menu. Microsoft decided that Alt+H would open the Home tab in all its products, so people who used to use the menu shortcuts for Help are sunk. Gotcha: The old keyboard shortcut Alt+H to open Help does not work anymore. (It's ironic that we have to work more slowly in Excel 2010/2013, isn't it?) If you slow down slightly, the Excel 2003 menu keys will work more reliably. Microsoft actually had this fixed during the Excel 2010 beta, but they broke it again in the Excel 2010 final version. It seems that while Excel is busy displaying the ToolTip, the fact that I typed C doesn't make it into the keyboard buffer. For example, if I rapidly type Alt+O+C+A to invoke F ormat, Column, AutoFit Selection, about half the time, Excel thinks that I typed F ormat, AutoFormat. I find that I have to pause briefly after typing Alt plus the first keystroke. Gotcha: It takes Excel a fraction of a second to display the ToolTip. In Excel 2003, you could look at the Data menu to learn what to do after typing Alt+D, but Excel doesn't offer this feature. Gotcha: Excel doesn't provide any feedback about what command you are typing. When you type the final bit of the shortcut, Excel closes the ToolTip and performs the command. In this figure, the ToolTip shows that Alt+E+I has been typed, which is two-thirds of the shortcut to reach Edit, Fill, Justify. At this point, you can continue typing the rest of the Excel 2003 menu shortcut. If you press Alt and E, V, I, O, T, D, or W, Excel will display a ToolTip above the ribbon that says Office 2003 Access Key. To use an Excel 2003 shortcut, you press Alt and the first letter rapidly. A few of the keyboard shortcuts from the File menu still work, but others do not. In Excel, any Excel 2003 keyboard shortcuts you memorized between the Edit and Window menus continue to work. ![]() My favorites, for example, are Alt+E+S+V for Edit, Paste Special, Values, Alt+O+C+A for F ormat, Column, AutoFit Selection, and Alt+E+I+J for Edit, F ill, Justify. Many people who used the old Excel regularly memorized a few Alt keyboard shortcuts. ![]() Strategy: Your old keystrokes still work you just have to invoke them a bit more slowly than usual. Microsoft completely eliminated the Edit menu, so what shortcuts do I use now? For example, I often used Alt+E+I+J to invoke Edit, Fill, Justify. I used to use a lot of keyboard shortcuts. Problem: I can't find anything on the ribbon. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |