How to Navigate the Excel 2010 Ribbon
How to Insert a Link to Send an E-mail in an Excel 2010 Worksheet
How to Customize the Excel 2010 Ribbon

Working with the Excel 2010 Mini Toolbar

Excel 2010's mini toolbar makes it easy to apply common formatting changes to a cell selection within the worksheet area. The 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 next to the cell selection.

  3. Click one or more buttons on the mini toolbar to apply their formatting to the current cell selection.

    Apply common formatting changes with the mini toolbar in Excel 2010.
    Apply common formatting changes with the mini toolbar in Excel 2010.

Press Esc at any time to remove the mini toolbar and shortcut menu. 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.

blog comments powered by Disqus
How to Get Help in Excel 2010
How to Select Excel 2010 Commands with Keyboard Shortcuts
What's New in Excel 2010?
How to Customize the Excel 2010 Quick Access Toolbar
Hot Keys for Common Excel 2010 Formula Commands