Cells can be formatted to produce a variety of effects. To format a cell or
group of cells, select the cells you want and select "Cells" from
the Format menu. A dialog box will appear.
Following are a list of useful things you can do from this dialog box:
- Adjust number of decimal places
You can set the number of decimal places displayed in your answer by clicking
on the "Number" tab in the Format Cells dialog box. Select "Number"
as the desired format, then choose a number of decimal places.
- Force cells to be text
You can force a cell to be formatted as a text cell by choosing "Text"
as the format under the "Number" tab in the Format Cells dialog
box. (You can also force an individual cell to be a text cell by starting
with a single quote: '
- Change alignment
You can set the horizonal alignment (left, right, or center) or the vertical
alignment (top, bottom, or center) of a cell under the "Alignment"
tab. This can be useful if you use very tall or wide cells for text used to
label rows or columns.
- Change font
You can of course change the typeface, make a cell bold or italicized, or
change the size of text under the "Font" tab.
For more types of formatting, see Excel's help menu.
Return to Excel Guide