Above the command list on the left is the Choose Commands From drop-down list from which you can filter the list. The left side of the Excel Options box displays a list of Excel commands, and the right side shows the commands currently on your Quick Access toolbar. click the Customize Quick Access Toolbar button and then click the More Commands option near the bottom of its drop-down menu.To open Quick Access Toolbar dialog box, do one of the following: You can add, remove, and change the order of the commands on the Quick Access Toolbar by using the Options command. Use the Options command to customize Quick Access Toolbar To quick remove a command button that you add to the Quick Access Toolbar, simply right-click the command button on the Quick Access Toolbar and then click Remove from Quick Access Toolbar on its shortcut menu. Quick remove a command button from the Quick Access Toolbar Excel then immediately adds the command button to the end of the Quick Access toolbar. To quick add a Ribbon command button to the Quick Access toolbar, simply right-click its command button on the Ribbon and then click Add to Quick Access Toolbar on its shortcut menu. Quick add a Ribbon command button to the Quick Access Toolbar
Excel removes its command button from the toolbar and the check mark from its option on the drop-down menu. To remove a command button that you add to the Quick Access Toolbar in this manner, click the option a second time on the Customize Quick Access Toolbar button’s drop-down menu. Excel then adds a button for that command to the end of the Quick Access Toolbar and a check mark to its option on the drop-down menu. To add any of the other commands on this menu to the toolbar, you simply click the option on the drop-down menu. Touch/Mouse Mode (available in Excel 2013).When you click the Customize Quick Access Toolbar button, a drop-down menu appears containing the following commands: Use Customize Quick Access Toolbar’s drop-down menu to add command buttons You can make Excel easier to use by customizing the Quick Access Toolbar to include the Excel commands you use most often. By default, the Quick Access Toolbar is located at the top left of the Excel title bar, above the Ribbon tabs, alternatively, you can display the Quick Access toolbar below the Ribbon, and the Quick Access Toolbar contains three buttons: Save, Undo, and Redo, but you can add any of Excel’s commands that you use often. The Quick Access Toolbar (QAT) is an area of the user interface that provides quick access to commands.
0 kommentar(er)
