To add any Ribbon command 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. Excel then immediately adds the command button to the very end of the Quick Access toolbar, immediately in front of the Customize Quick Access Toolbar button.

If you want to move the command button to a new location on the Quick Access toolbar or group with other buttons on the toolbar, you need to click the Customize Quick Access Toolbar button and then click the More Commands option near the bottom of its drop-down menu.

Excel then opens the Excel Options dialog box with the Customize tab selected. Here, Excel shows all the buttons currently added to the Quick Access toolbar with the order in which they appear from left to right on the toolbar corresponding to their top-down order in the list box on the right-hand side of the dialog box.

To reposition a particular button on the bar, click it in the list box on the right and then click either the Move Up button or the Move Down button until the button is promoted or demoted to the desired position on the toolbar.

To remove a button added from the Ribbon, right-click it on the Quick Access toolbar and then click the Remove from Quick Access Toolbar option on its shortcut menu.