Microsoft Office Tutorials and References
In Depth Information
For more information about alignment, see “Aligning data in cells” earlier in this chapter.
For more about entering line breaks and tabs in cells, see “Formula-bar formatting” in
You’ll find the Angled Borders.xlsx file with the other examples on the companion website.
To apply borders, you can click the preview area where you want the border to appear, or
you can click the buttons located around the preview area. An additional preset button,
Inside, becomes active only when you have more than one cell selected. If you click the
Outline button, borders are applied only to the outside edge of the entire selection. The
None preset removes all border formats from the selection.
Borders often make a greater visual impact on your screen when you remove
worksheet gridlines. Click the View tab on the ribbon, and clear the Gridlines check box in
the Show/Hide group to remove gridlines from your worksheet. For more information
about gridlines, see “Controlling other elements of the Excel interface” in Chapter 3.
The default, or Automatic, color for borders is black. To select a line style, click the type of
line you want to use in the Line area, and then click any of the buttons in the Border area
or click the preview box directly to apply that style in the selected location. (The first finely
dotted line in the Style area is a solid hairline when printed.) To remove a border, click the
corresponding button—or the line in the preview window—without selecting another style.
By using the commands in the Draw Borders group at the bottom of the Borders menu
(shown in Figure 9-52), you can create complex borders quickly and easily. When you click
Draw Border, you enter border-drawing mode , which persists until you click Draw Border
again or press Esc. After you activate this mode, you can drag to create lines and boxes
along cell gridlines, as shown in Figure 9-54. If you click Draw Border Grid, not only are
borders drawn along the boundaries of the selected cells, but they’re also drawn along all the
gridlines in the selection rectangle, as shown at the bottom of Figure 9-54.
If you make selections in the Line Color and Line Style galleries at the bottom of the
Borders menu prior to using either Draw Border command, the borders you draw reflect
your color and style selections. Clicking Erase Border predictably activates the opposite of
border-drawing mode: border-erasing mode . Dragging while in erase mode removes all
borders within the selection rectangle.