Add Formatting to an Excel 07 worksheet
To distinguish between different areas of a worksheet or different rows/columns it is sometimes necessary to place borders around cells or apply shading to cells or a range. Applying borders and shading can give you worksheet a more organized look and can make it easier to read. Excel makes it easy to add borders and apply shading.
Excel also allows you to apply special number formatting such as Social Security number or Zip Code. You also have the option of displaying or not displaying zero values.
Add Borders
Add a Style
Apply Special Number Formats
Apply Special Date Formats
Merge and Center
Apply Text Wrap
Reposition Text
- Select the cell or range of cells you want to apply a border.
-
On the Home tab, in the Font group, click on the arrow on Borders button.
- Observe the borders palette.
- For more choices, select More Borders at the bottom of the list.
- Select the type of border you want to apply.
- Deselect the cell or range.
- Select the cell or range of cells you want to apply a style.
-
On the Home tab, in the Styles group, click on Cells Styles.
- Observe the color palette.
- Select the type of shading you want to apply.
- Deselect the cell or range.
- Select the cell or range of cells you want to apply special number formatting.
- On the Home tab, locate the Numbers group.
-
Click the Dialog Box Launcher icon.
- The Number tab should be selected.
- From the Category list, select Special.
- From the Type list, select the type of appropriate formatting.
- Click OK.
- Deselect the cell or range.
- Select the cell or range of cells you want to apply date formatting.
- On the Home tab, locate the Numbers group.
- Click the Dialog Box Launcher icon.
- From the Category list, select Date.
- From the Type list, select the type of appropriate format.
- Click OK.
When you merge two or more adjacent horizontal or vertical cells, the cells become one larger cell that is displayed across multiple columns or rows. When you merge multiple cells, the contents of only one cell (the upper-left cell for left-to-right languages, or the upper-right cell for right-to-left languages) appear in the merged cell.
- Select two or more adjacent cells that you want to merge.
-
On the Home tab, in the Alignment group, click Merge and Center.
Note: To split a merged cell, select the merged cell, click Merge and Center again.
If you want text to appear on multiple lines in a cell, you can format the cell so that the text wraps automatically, or you can enter a manual line break
- Select the cells you want to format.
-
On the Home tab, in the Alignment group, click Wrap Text.
For the optimal display of the data on your worksheet, you may want to reposition the data within a cell. You can change the alignment of the cell contents, use indentation for better spacing, or display the data at a different angle by rotating it.
- Select the cell or range of cells that contains the data that you want to reposition.
- On the Home tab, in the Alignment group, do one of the following:
-
To change the vertical alignment of cell contents, click Top Align
, Middle Align 
, or Bottom Align 
.
-
To change the horizontal alignment of cell contents, click Align Text Left
, Center 
, or Align Text Right 
.
-
To change the indentation of cell contents, click Decrease Indent
or Increase Indent 
.
-
To rotate the cell contents, click Orientation
, and then select the rotation option that you want.