Move your Quick Access Toolbar (2007/2010)

If you're trying to adjust to the Excel 2007/2010 layout, you may want to experiment with all of your available options. Every Excel user works a bit differently, and you may find that a slightly altered screen layout better accommodates your work flow.

One thing you can change about your Excel layout is the position of the Quick Access Toolbar. While it displays above the Ribbon by default, you can change this setting.

To move the Quick Access Toolbar below the Ribbon:

• Open your workbook in Excel.
• Right-click on the arrow to the right of your Quick Access Toolbar to open a shortcut menu
• Choose Show Below The Ribbon from the menu, as shown in Figure A.

Now you'll see that the Quick Access Toolbar displays below your Ribbon and above your Excel formula bar.