Microsoft Office Tutorials and References
In Depth Information
Adding Borders and Shading
Adding Borders and Shading
On the screen, each cell has a light
gray border around it, but those borders do
not print by default. That’s called the grid ,
and it is there for the ease of viewing each cell
independently. In fact, you can turn the grid
display off and on by clicking View>Show>Gridlines.
If you want borders around your cells, whether
around the entire cell, or just on a part of the cell,
Excel provides a tool to easily create printable
lines. You can also add pizzazz to your worksheet
by adding backgrounds and patterns.
Placing Borders Around Cells
You can add border lines to individual cells and
groups of cells. A border can appear around all
sides of the cell or only on certain sides, such as the
top or bottom. Different from an underline, which
runs directly under letters and numbers, a border
flows across the entire width or height of a cell.
Figure 10-20
Creating cell border lines.
Select the border you want. Excel applies the
border to the selected cells. Optionally, click the More
Borders option, which opens the Format Cells
dialog box. From there you can select even more
border styles, colors, and options.
To add a border, select the appropriate cells.
Choose Home>Font and then click the arrow next
to the Borders button. A variety of border options
appears, as you see in Figure 10-20.
Applying Cell Background
Colors
Adding a background color to a cell or group of cells
can make your worksheet more interesting and can
call attention to specific areas of the worksheet.
Excel calls the background color the Fill color.
Last Used Border
The Borders button ScreenTip may display
Bottom Border, Top Border, or whatever
border was last used.
Search JabSto ::




Custom Search