How to Use Excel 2007’s Research Task Pane
How to Use the Thesaurus in Excel 2007
How to Create a New Custom Dictionary in Excel 2007

Working with the Excel 2007 Mini Toolbar

Microsoft Office Excel 2007 makes it easy to apply common formatting changes to a cell selection right within the Worksheet area, thanks to its new mini toolbar feature.

The Excel 2007 mini toolbar contains these buttons from the specified groups on the Home tab:

  • Font group: Font, Font Size, Increase Font Size, Decrease Font Size, Bold, Italic, Border, Fill Color, and Font Color (all buttons in this group except the Underline button)

  • Alignment group: Center and Merge & Center buttons

  • Number group: Accounting Number Format, Percent Style, Comma Style, Increase Decimal, and Decrease Decimal buttons

  • Clipboard group: Format Painter button.

Follow these steps to use the mini toolbar:

  1. Select the cell or cells in the worksheet that you want to format.

  2. Right-click anywhere in the cell selection.

    The mini toolbar appears immediately above the cell selection’s shortcut menu.

    Apply common formatting changes with the mini toolbar in Excel 2007.
    Apply common formatting changes with the mini toolbar in Excel 2007.
  3. Click one or more buttons on the mini toolbar to apply formatting to the current cell selection.

Press Esc at any time to make the mini toolbar and shortcut menu disappear. If you have already made a selection from the mini toolbar, move the mouse pointer away from the mini toolbar or select another cell to make it disappear.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Translating Text in Excel 2007
Figuring Out the Excel 2007 Formula Bar
Examining the Excel 2007 Status Bar
Exploring the Excel 2007 Program Window
Working in Excel 2007’s Page Layout View
Advertisement

Inside Dummies.com