Microsoft Office Tutorials and References
In Depth Information
Working with Alignment and Spacing
Chapter 10
Making Your Worksheet Look Good
Format Cells dialog box. Click the Date category, as
seen in Figure 10-9, which displays a variety of
date formats. Select a format for the selected cells
and click the OK button.
Alternative Method
Another method to select Font color is
through the Font group Dialog Box Launcher,
which displays the Format Cells dialog box.
Font color selection is on the Font tab.
Working with Date Formats
As you learned in Chapter 8, "Creating a Basic
Worksheet," Excel may not display a date in the same
format as you entered the data. A couple of date
format options are accessible through the Number
Format drop-down menu, but more extensive
options are offered in the Format Cells dialog box.
Select the cell that has a date you want formatted
and then, from the Home tab, click the Number
group Dialog Box Launcher, which displays the
Figure 10-9
A few of the available Excel date formats.
Working with Alignment and Spacing
In the previous section, you worked
with the appearance of cells as to their font
face, size, color, and so forth. In this section,
you discover how to change the worksheet itself so
you can see more (or less) of the information in
the individual cells, and especially how the cell
contents line up with the cell edges.
Adjusting Column Width
By default, Excel columns are 8.43 characters wide.
When the content of a cell is too long to fit into its
cell, depending on the type of data, Excel may
automatically widen the column or display the
information in a different format. You can
manually resize a column so all data displays correctly.
Search JabSto ::

Custom Search