How to Add Comments to Excel 2013 Worksheet Cells
How to Merge Custom Styles into Other Excel 2013 Workbooks
How to Create a Custom Cell Style in Excel 2013

Format Cell Ranges with the Mini-Toolbar in Excel 2013

Excel 2013 makes it easy to apply common formatting changes to a cell selection right within the Worksheet area thanks to its mini-toolbar feature — nicknamed the mini-bar.

To display the mini-toolbar, select the cells that need formatting and then right-click somewhere in the cell selection. The mini-toolbar then appears immediately below or above the cell selection’s shortcut menu.

image0.jpg

The mini-toolbar contains most of the buttons from the Font group of the Home tab (with the exception of the Underline button). It also contains the Center & Merge and Center buttons from the Alignment group and the Accounting Number Format, Percent Style, Comma Style, Increase Decimal, and Decrease Decimal buttons from the Number group. Simply click these buttons to apply their formatting to the current cell selection.

In addition, the mini-toolbar contains the Format Painter button from the Clipboard group of the Home tab, which you can use to copy the formatting in the active cell to a cell selection you make.

To display the mini-toolbar on a touchscreen device, tap and hold any cell in the selected range. Note that the mini-toolbar that appears is a little different from the one you see when you right-click a cell selection with a physical mouse.

This one contains a single row of command buttons that combine editing and formatting functions — Paste, Cut, Copy, Clear, Fill Color, Font Color, and AutoFill followed by a Show Context Menu button (with a black triangle pointing downward).

Tap the Show Context Menu button to display a pop-up menu of other editing and formatting options. Tap the Format Cells button on this menu to get access to all sorts of formatting options (see section that follows for details).

blog comments powered by Disqus
How to Use the Excel 2013 Format Painter
How to Select Cells in Excel 2013 with Go To
How to Select Cells in Excel 2013
Format Dates and Times in Your Excel Reports
Enhance Your Excel Reports with Conditional Formatting
Advertisement

Inside Dummies.com