Microsoft Office Tutorials and References
In Depth Information
To create a grid of cell borders in the two tables:
1. Select the nonadjacent range A6:E19;A22:H26 .
2. Click the Borders list arrow on the Formatting toolbar, then move the pointer over
the gallery of borders to highlight the All Borders option as shown in Figure 3-14.
3. Click the All Borders option (third row, second column from the left) in the borders gallery.
A thin border appears around each cell in the selected range.
4. Click any cell to deselect the range and to see the applied border.
You can also place a border around the entire range itself (and not the individual cells) by
selecting a different border style. Try this by creating a thick border around the cell range.
To create a thick border around a selected range:
1. Select the nonadjacent range A6:E19;A22:H26 again.
2. Click the Borders list arrow on the Formatting toolbar, and then click the Thick Box
Border option (third row, fourth column from the left) in the borders gallery.
3. Click any cell to deselect the range so you can see the thick border applied to the tables.
The interior borders should be unchanged.
If you want a more interactive way of drawing borders on your worksheet, you can use
the Draw Borders button, which is another option on the borders gallery. To see how this
option works, you will add a thick black line under the column titles in both of the tables.
To draw borders using the Draw Borders button:
1. Click the Borders list arrow on the Formatting toolbar, and then click the Draw
Borders button at the bottom of the borders gallery. The pointer changes to , and a
floating Borders toolbar opens with four tools. The Draw Border button (currently selected)
on the Borders toolbar draws a border line on the worksheet; the Erase Border button
erases border lines; the Line Style button specifies the style of the border line; and the Line
Color button specifies the line color.
2. Click the Line Style list arrow to display a list of line style options, and
then click the thick line option (the ninth from the top) in the list.