Microsoft Office Tutorials and References
In Depth Information
To Center Data in Cells and Format Dates
With the column titles and total rows formatted, the next step is to center the stock symbols in column B and
format the dates in column C. If a cell entry is short, such as the stock symbols in column B, centering the entries
within their respective columns improves the appearance of the worksheet. The following steps center the data in
the range B4:B12 and format the dates in the range C4:C12.
• Select the range B4:B12 and then
click the Center button on the
Ribbon to center the data in the
• Select the range C4:C12.
• Click the Format Cells: Number
Dialog Box Launcher on the
Ribbon to display the Format
Cells dialog box.
Date selected in
• When Excel displays the Format
Cells dialog box, if necessary click
the Number tab, click Date in
the Category list, and then click
3/14/01 in the Type list to choose
the format for the range C4:C12