Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet
1
Home tab
Select the range to
Format Cells
dialog box
contain the new date
format, cells B4:B12 in
this case.
Click the Format Cells:
Number Dialog Box
Launcher (Home tab |
Number group) to
display the Format
Cells dialog box.
Number tab
Date selected
in Category list
03/14/01 style
selected in Type list
If necessary, click the
Number tab (Format
Cells dialog box), click
Date in the Category
list, and then click
3/14/01 in the Type list
to choose the format
for the selected range
(Figure 2 – 39).
dates in range
B4:B12 selected
OK button
Figure 2 – 39
2
Click the OK button
(Format Cells dialog
box) to format the
dates in the current
column using
the selected date
format style.
cell E4 selected
3
Select the range C4:C12
and then click the
Center button (Home
tab | Alignment group)
to center the data in
the selected range.
Excel displays dates in
range B4:B12 using date
style format, mm/dd/yy
Select cell E4 to
data centered in
range C4:C12
deselect the selected
range (Figure 2 – 40).
Can I format an entire column at once?
Yes. Rather than selecting the range B4:B12 in Step 1, you could have clicked the column B
heading immediately above cell B1, and then clicked the Center button (Home tab | Alignment
group). In this case, all cells in column B down to the last cell in the worksheet would have
been formatted to use center alignment. This same procedure could have been used to format
the dates in column C.
Figure 2 – 40
Other Ways
1. Right-click range, click
Format Cells on shortcut
menu, click appropriate
tab (Format Cells dialog
box), click desired format,
click OK button
2. Press CTRL + 1, click
appropriate tab (Format
Cells dialog box), click
desired format, click OK
button
 
Search JabSto ::




Custom Search