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.