Customize the Quick Access Toolbar : Quick Access Toolbar « Introduction « Microsoft Office Excel 2007 Tutorial






Click the Customize Quick Access Toolbar list arrow. 
           Then click More Commands.
Click the Customize Quick Access Toolbar list arrow. Then click More Commands.
Then click the Choose commands from list arrow. 
           Then click All Commands or a specific Ribbon.
Then click the Choose commands from list arrow. Then click All Commands or a specific Ribbon.
Then Click the Customize Quick Access Toolbar list. 
           Then click For all documents
Then Click the Customize Quick Access Toolbar list. Then click For all documents
Select the current workbook if you only want the commands available in the workbook.
Select the current workbook if you only want the commands available in the workbook.
Click the command from left column or remove what you have in the right column. 
           Then click Add or Remove.
Click the command from left column or remove what you have in the right column. Then click Add or Remove.
Click <Separator>, 
           Then click Add to insert a separator line between buttons.
Click <Separator>, Then click Add to insert a separator line between buttons.
Click the Move Up and Move Down arrow buttons to arrange the order.
Click the Move Up and Move Down arrow buttons to arrange the order.
Click OK
Click OK








1.8.Quick Access Toolbar
1.8.1.Move the Quick Access Toolbar to another locationMove the Quick Access Toolbar to another location
1.8.2.Rest the Quick Access Toolbar to its original stateRest the Quick Access Toolbar to its original state
1.8.3.Add or remove a common button in Quick Access ToolbarAdd or remove a common button in Quick Access Toolbar
1.8.4.Add a Ribbon button or group to Quick Access ToolbarAdd a Ribbon button or group to Quick Access Toolbar
1.8.5.Remove a button or group in Quick Access ToolbarRemove a button or group in Quick Access Toolbar
1.8.6.Customize the Quick Access ToolbarCustomize the Quick Access Toolbar