- #Where is the transpose button in excel 2010 upgrade#
- #Where is the transpose button in excel 2010 free#
However, there are no letters on the table style choices in the gallery.įigure 5.4 After opening a gallery, you use the arrow keys to navigate through the gallery and press Enter to select a style. As you can see in Figure 5.4, you can invoke the New Table Style and New Pivot Style commands at the bottom of the gallery by pressing N and P, respectively. This opens the gallery of possible table styles. Selecting Options from a Galleryįigure 5.4 shows the results of pressing Alt+H+T, which is the equivalent of selecting Home, Format Table. There might be some arcane, logical reason why 5 and 6 are used for increase and decrease indent, but it is unknown by most people. Similarly, in the Home tab, O now opens the Format drop-down, although since Microsoft no longer underlines the accelerator key in the menu name, O will never make sense to someone new to Excel. In Excel 2003, F was used for File so O was used for Format. Some take a little pondering: FA for the dialog launcher in Figure 5.3 makes sense in that it opens the legacy Format dialog and moves to the Alignment tab. Other shortcut keys seem to be assigned at random. Some shortcut keys seem to make sense: AT for Align Top, AM for Align Middle, AB for Align Bottom, AL for Align Left, W for Wrap Text, and M for Merge. Note that after you press Alt to display the accelerators in the ToolTips, you do not have to continue holding down the Alt key.įigure 5.3 After pressing the letter to switch to the ribbon, type the letter or letters to invoke a particular command. On very busy Ribbon tabs, some commands require two keystrokes: for example, A+C for Align Center in the Alignments Group of the Home tab, as shown in Figure 5.3.
#Where is the transpose button in excel 2010 free#
When you choose a ribbon tab, the keytips on the Quick Access toolbar disappear, so Microsoft is free to use the letters A through Z and the numbers 0 through 9. You now see that every icon on the ribbon has a keytip. Selecting Icons on the RibbonĪfter you press the Alt key, you can press one of the keytip letters to bring up the appropriate tab. If you want to memorize those keytips, you need to make sure you do not add a new Quick Access toolbar icon at the beginning of the list. Unfortunately, the keytips for the Quick Access toolbar change every time you add new buttons or rearrange buttons on the Quick Access toolbar. Figure 5.1 shows the ToolTips.įigure 5.2 New ribbon tabs get new letters, making sure the old letters remain constant. In addition, number ToolTips appear over each icon in the Quick Access toolbar. Tiny letter ToolTips appear over each tab of the ribbon. Keep in mind that if you prefer using the slash key, you must use / in place of Alt with new keyboard accelerators. 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.
#Where is the transpose button in excel 2010 upgrade#
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.