Microsoft Office Tutorials and References
In Depth Information
Verifying Formulas Using Range Finder
1 ENTER FORMULAS | 2 ENTER FUNCTIONS | 3 VERIFY FORMULAS
4 FORMAT WORKSHEET | 5 CHECK SPELLING | 6 PRINT WORKSHEET
To Format Dates and Center Data in Cells
Why? With the column titles and total rows formatted, the next step is to format the dates in column J and center the
dependents in column B. The following steps format the dates in the range J4:J12 and center the data in the range B4:B16.
1
Select the range to contain the
new date format, cells J4:J12 in
this case.
Tap or click the Format Cells:
Number Format Dialog Box
Launcher (HOME tab | Number
group) to display the Format Cells
dialog box.
If necessary, tap or click the
Number tab (Format Cells dialog
box), tap or click Date in the
Category list, and then tap or click
3/14/12 in the Type list to choose
the format for the selected range
(Figure 2 – 36).
Format Cells: Number
Dialog Box Launcher
Format Cells
dialog box
Number tab
Date selected
desired date
type selected
2
Tap or click the OK button (Format
Cells dialog box) to format the
dates in the current column using
the selected date format style.
OK button
Figure 2 – 36
3
Select the range B4:B16 and then
tap or click the Center button
(HOME tab | Alignment group)
to center the data in the selected
range.
Select cell E4 to deselect the
selected range (Figure 2 – 37).
Center button
numbers
centered
cell E4 selected
Can I format an entire column at
once?
Yes. Rather than selecting the
range B4:B16 in Step 3, you
could have tapped or clicked the
column B heading immediately
above cell B1, and then tapped or
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 J.
date style
applied
Figure 2 – 37
Other Ways
1. Press and hold or right-click range, tap or click Format Cells on
shortcut menu, tap or click Number tab (Format Cells dialog box),
tap or click desired number format, tap or click OK button
2. Press CTRL + 1, tap or click Number tab (Format Cells dialog box), tap
or click desired number format, tap or click OK button
 
Search JabSto ::




Custom Search