Rearrange the commands in the Quick Access Toolbar

When you add commands to the Quick Access Toolbar, the command that is added at the last appears at the right most area in the Quick Access Toolbar. To rearrange the commands in the Quick Access Toolbar, perform the following steps:
1. Click the Microsoft Office Button and click Excel Options.
2. In the Excel Options dialog box, click Customize from the left pane.
3. In the right pane, click a command from the list that is in the right list box.
4. Click the Move Up or Move Down buttons to rearrange the commands.
5. Continue steps 3 and 4 for other commands. 6. Once you are done, click OK.

How to add commands that are not in the Ribbon to the Quick Access Toolbar in Excel 2007?

To add commands that are not in the Ribbon, perform the following:

1. Open Microsoft Excel.
2. Click the Microsoft Office Button and click Excel Options.
3. From the Excel Options dialog box, click Customize from the left pane.
4. From the right pane, under Choose commands from, click Commands Not in the Ribbon.
5. Click on a command and click the Add > > button.
6. Click OK

How to add a command to the Quick Access Toolbar in Excel 2007?

You can add a command to the Quick Access Toolbar by performing the following steps:
1. Open Microsoft Excel.
2. Click the Microsoft Office Button and click Excel Options.
3. From the Excel Options dialog box, click Customize from the left pane.
4. From the right pane, under Choose commands from, make a selection. The related commands appear below the drop-down box.
5. Click on a command and click the Add > > button.
6. Click OK

Add the Save As command to the Quick Access Toolbar in Excel 2007

To add the Save As command to the Quick Access Toolbar, perform the following steps:
1. Click the Microsoft Office button .
2. Right click Save As and click Add to Quick Access Toolbar.

Add Cell Styles gallery to the Quick Access Toolbar in Excel 2007

You can add the Cell Styles gallery to the Quick Access Toolbar by performing the following steps:
1. On the Home tab, in the Styles group, click Cell Styles.
2. Right click on any cell style and click Add Gallery to Quick Access Toolbar.

Related articles:

1.	Delete cell styles in Excel 2007
2.	Remove the cell style applied to the cells in Excel 2007
3.	Apply a cell style in Excel 2007
4.	Create new cell style in Excel 2007
5.	Add Cell Styles gallery to the Quick Access Toolbar in Excel 2007
6.	Create a cell style by modifying an existing cell style in Excel 2007
7.	Modify a cell style in Excel 2007
8.	Rename a custom cell style in Excel 2007
9.	Create a duplicate of an existing cell style in Excel 2007
10.	Copy cell styles from another workbook in Excel 2007

Add the Repeat command to the Quick Access Toolbar in Excel 2007

By default, the Repeat command does not appear on the Quick Access Toolbar. You have the Undo and Redo commands on the Quick Access Toolbar. You can add the Repeat command by performing the following steps:
1. Open Microsoft Excel.
2. Click the Microsoft Office Button and click Excel Options.
3. From the Excel Options dialog box, click Customize from the left pane.
4. From the right pane, under Choose commands from, click Popular Commands.
5. Scroll the list and click Repeat.
6. Click Add > >.
7. Click OK.

Move the Quick Access Toolbar in Excel 2007

In Excel 2007, the Quick Access Toolbar (QAT) is located to the right of the Microsoft Office Button by default. You can move the Quick Access Toolbar below the Ribbon or move back to the default position.

To move the QAT below the Ribbon, perform the following steps:
1. Click the Customize Quick Access Toolbar.
2. Click Show Below the Ribbon.

To move the QAT to the right of the Microsoft Office Button, perform the following steps:
1. Click the Customize Quick Access Toolbar.
2. Click Show Above the Ribbon.