Microsoft Office Tutorials and References
In Depth Information
Borders and Fills
by clicking one of the eight Border buttons (which contain a single bold
horizontal, vertical, or diagonal line), or click directly inside the Border box. If you
change your mind, clicking a border line makes it disappear.
Follow the numbered
steps in this figure to
choose the line style
and color, and then
apply the border. Here,
Excel will apply a solid
border between the
columns and at the top
edge of the selection.
1. Choose the type
of border line here
2. Choose the
border color here
3. Apply the border where you
want it by clicking in here
For example, if you want to apply a border to the top of your selection, click the
top of the Border box. If you want to apply a line between columns inside the
selection, click between the cell columns in the Border box. The line appears
indicating your choice.
Tip: The Border tab also provides two shortcuts in the tab’s Presets section. If you want to apply a
border style around your entire selection, select Outline after choosing your border style and color.
Choose Inside to apply the border between the rows and columns of your selection. Choosing None
removes all border lines.
Here you can select the background color, pattern color, and pattern style to
apply shading to the cells in the selection (see Figure 16-15). Click the No Color
box to clear any current color or pattern in the selected cells. When picking a
pattern color, you may notice that certain colors are described as theme colors .
These theme colors are a set of coordinated colors that change whenever you
pick a new theme for your workbook, as described in the Tip on page 532.