Microsoft Office Tutorials and References
In Depth Information
Adding Custom Borders and a Background Color to a Range
4
Click the light border in the Style
area (column 1, row 7) and then
click the Vertical Line button in the
Border area to preview the black
vertical border in the Border area
(Figure 4–7).
How should I create my desired
border?
As shown in Figure 4–7, you can
add a variety of borders with
different colors to a cell or range
of cells to improve its appear-
ance. It is important that you
select border characteristics in the
order specifi ed in the steps; that
is, (1) choose the border color; (2)
choose the border line style; and
(3) choose the border type. If you
attempt to do these steps in any
other order, you may not end up
with the desired borders.
light border
selected
border
preview
vertical lines
will be added
to the inside
cell borders
Vertical
Line button
OK button
Figure 4–7
5
Click the Fill tab and then click
light blue (column 9, row 3) in the
Background Color area.
Click the OK button and then
select cell B8 to deselect the range
B2:E6, add a black outline with
vertical borders to the right side
of each column in the range B2:
E6, and add a light blue fi ll color
to the range (Figure 4–8).
medium border
and light blue
background
applied to
range B2:E6
Other Ways
1. Select range, click Fill
Color button arrow on
Home tab on Ribbon,
click color, click Borders
button arrow on
Ribbon, click border
2. Click Format Cells: Font
Dialog Box Launcher on
Ribbon, click Fill tab,
click color, click Borders
tab, click border
light vertical border
applied to right side
of each column in
selected range
Figure 4–8
 
 
Search JabSto ::




Custom Search