Microsoft Office Tutorials and References
In Depth Information
Formatting Cell Appearance
Formatting Cell
Appearance
Figure 16-8:
Special number formats are ideal for
formatting sequences of digits into a
common pattern. For example, in the
Type list, if you choose Phone
Number, then Excel converts the sequence
of digits 5551234567 into the proper
phone number style—(555) 123-
4567—with no extra work required on
your part.
Formatting Cell Appearance
Formatting cell values is important because it helps maintain consistency among
your numbers. But to really make your spreadsheet readable (and even beautiful),
you’ll need to enlist some of Excel’s tools for controlling things like alignment, color,
and borders and shading.
You can format a cell’s appearance in two ways. You can find the button you need
on the Home tab of the ribbon, or you can go back to the more comprehensive
Format Cells dialog box. Just select the single cell or group of cells that you want to
work with, and then choose Home Cells Format Format Cells. Or, right-click the
selection, and then choose Format Cells. The following sections walk you through
the options in the Format Cells dialog box.
Tip: Even a small amount of formatting can make a worksheet easier to interpret by drawing the viewer’s
eye to important information. Of course, as with formatting a Word document or designing a web page,
a little goes a long way. Don’t feel the need to bury your worksheet in exotic colors and styles just because
you can.
 
Search JabSto ::




Custom Search