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

144 Formatting Cells from the Ribbon
Formatting Cells from the Ribbon
Some spreadsheet tables require a lighter touch than formatting as a table offers. For example, you may have a data table where the only emphasis you want to add is to make the column headings bold at the top of the table and to underline the row of totals at the bottom (done by drawing a borderline along the bottom of the cells).
The formatting buttons that appear in the Font, Alignment, and Number groups on the Home tab enable you to accomplish just this kind of targeted cell formatting. See Table 2-1 for a complete rundown on the use of each of these formatting buttons.
Table 2-1
Group
Font
The Formatting Command Buttons in the Font, Alignment, and Number Groups on the Home Tab
Button Name
Font
Font Size
Increase Font Size
Decrease Font Size
Bold
Italic
Function
Displays a Font drop-down menu from which you can assign a new font for the entries in your cell selection.
Displays a Font Size drop-down menu from which you can assign a new font size to the entries
in your cell selection. Click the Font Size text box and enter the desired point size if it doesn’t appear on the drop-down menu.
Increases by one point the font size of the entries in your cell selection.
Decreases by one point the font size of the entries in your cell selection.
Applies and removes boldface in the entries in your cell selection.
Applies and removes italics in the entries in your cell selection.
Hot Keys
Alt+HFF
Alt+HFS
Alt+HFG
Alt+HFK
Alt+H1
Alt+H2