killospring.blogg.se

Excel quick access toolbar move below ribbon
Excel quick access toolbar move below ribbon












excel quick access toolbar move below ribbon excel quick access toolbar move below ribbon

I met several people who embraced the QAT. In the Choose Commands From drop-down menu, the second choice is “Commands Not in the Ribbon.” For a complete list of these hidden commands, right-click the QAT and choose Customize Quick Access Toolbar. You can also add commands to the QAT that can’t be found in the ribbon, such as the icons for Superscript, Subscript, and Speak Cells. You can easily add any icon to the QAT by right-clicking the icon in the ribbon and choosing Add To Quick Access Toolbar. By adding an icon to the QAT, users could have quick access to it without having to change tabs in the ribbon. For example, even after learning where the AZ and ZA sort buttons were on the Data tab, using them still required a click to choose the Data tab and then another click to return to the Home tab.

excel quick access toolbar move below ribbon

When Office 2007 introduced the ribbon, users were frustrated trying to find where Microsoft had placed various commands and then having to take multiple steps to get to them. You could customize it to add additional icons for your favorite or most-used commands. It debuted in Excel 2007 with default icons for Save, Undo, and Redo. The QAT is a tiny row of icons that can appear either above the ribbon, as shown in the figure, or below the ribbon.














Excel quick access toolbar move below ribbon