Microsoft Office Tutorials and References
In Depth Information
Altering the Alignment
The Font tab in the Format Cells dialog box brings together under one roof
fonts, font styles (bold and italics), effects (strikethrough, superscript, and
subscript), and color changes. When you want to make many font-related
changes to a cell selection, working in the Font tab may be your best bet. One
of the nice things about using this tab is that it contains a Preview box that
shows you how your font changes appear (onscreen at least).
To change the color of the entries in a cell selection, click the Font Color
button’s drop-down menu in the Font group on the Home tab and then select the
color you want the text to appear in the drop-down palette. You can use Live
Preview to see what the entries in the cell selection look like in a particular
font color by moving the mouse pointer over the color swatches in the
palette before you select one by clicking it (assuming, of course, that the palette
doesn’t cover the cells).
If you change font colors and then print the worksheet with a black-and-white
printer, Excel renders the colors as shades of gray. The Automatic option
at the top of the Font Color button’s drop-down menu picks up the color
assigned in Windows as the window text color. This color is black unless you
change it in your display properties. (For help on this subject, please refer to
Microsoft Windows 7 For Dummies or Microsoft Windows 8 For Dummies, both
by Andy Rathbone — and be sure to tell Andy that Greg sent ya!)
Altering the Alignment
The horizontal alignment assigned to cell entries when you first make them is
simply a function of the type of entry it is: All text entries are left-aligned, and
all values are right-aligned with the borders of their cells. However, you can
alter this standard arrangement anytime it suits you.
The Alignment group of the Home tab contains three normal horizontal
alignment tools: the Align Left, Center, and Align Right buttons. These buttons
align the current cell selection exactly as you expect them to. On the right
side of the Alignment group, you usually find the special alignment button
called Merge & Center.
Despite its rather strange name, you’ll want to get to know this button.
You can use it to center a worksheet title across the entire width of a table
in seconds (or faster, depending upon your machine). Figure 3-12 shows
you how this works. To center the title, Mother Goose Enterprises – 2013
Sales, entered in cell A1 over the entire table (which extends from column A
through E), select the cell range A1:E1 (the width of the table) and then click
the Merge & Center button in the Alignment group on the Ribbon’s Home tab.