Page 163 - Excel 2013 All-in-One For Dummies

Formatting Cells from the Ribbon 145
Group
Button Name
Underline
Borders
Fill Color
Font Color
Top Align
Middle Align
Bottom Align
Orientation
Wrap Text
Function
Applies and removes underlin- ing in the entries in your cell selection.
Opens a Borders drop-down menu from which you can assign a new border style to or remove an existing border style from your cell selection.
Opens a drop-down Color palette from which you can assign a new background color for your cell selection.
Opens a drop-down Color palette from which you can assign a new font color for the entries in your cell selection.
Aligns the entries in your cell selection with the top border of their cells.
Vertically centers the entries in your cell selection between the top and bottom borders of their cells.
Aligns the entries in your cell selection with the bottom border of their cells.
Opens a drop-down menu with options for changing the angle and direction of the entries in your cell selection.
Wraps all entries in your cell selection that spill over their right borders onto multiple lines within the current column width
Hot Keys
Alt+H3U (single) or Alt+H3D (for double)
Alt+HB
Alt+HH
Alt+HFC
Alt+HAT
Alt+HAM
Alt+HAB
Alt+HFQ
Alt+HW
(continued)
Alignment
Book II Chapter 2
Formatting Worksheets