Datasheet

• Underline
• Align Text Left
• Center
• Align Text Right
• Merge and Center
• Accounting Number Format (corresponding to the Currency Style
button)
• Percent Style
• Comma Style
• Increase Decimal
• Decrease Decimal
• Decrease Indent
• Increase Indent
• Borders
• Fill Color
• Font Color.
15. Click the OK button to close the Excel Options dialog box and return
to the Excel program window.
Your Quick Access toolbar should now have the same buttons as the
one shown in Figure 1-10.
After adding all the buttons on the Standard and the Formatting toolbar (with
the exception of the Permission button that almost nobody uses, the Drawing
button that has no equivalent in Excel 2007, and the Zoom and Help buttons
that are always available in the Excel 2007 program window), the Quick
Access toolbar fills the entire width of the screen on many monitors. Keep in
mind that if you need to add extra buttons that can no longer be displayed on
the single row above the Formula bar, Excel automatically adds a More
Controls button to the end of the Quick Access toolbar. You then click this
More Controls button to display a pop-up menu containing all the buttons
that can no longer be displayed on the toolbar.
To add vertical bar separators to divide the buttons into groups as you see in
the original Standard and Formatting toolbars and shown in Figure 1-8, click
the <Separator> option located at the top of each Choose Commands From
list box followed by the Add button.
48
Part I: Getting In on the Ground Floor
05_037377 ch01.qxp 11/16/06 9:23 AM Page 48