Microsoft Office Tutorials and References
In Depth Information
Another way you can make a cell stand apart from its neighbors is to add a border around
the cell. To place a border around one or more cells, select the cells, and then choose the
border type you want by selecting from the Border list in the Font group. Excel does
provide more options: To display the full range of border types and styles, in the Border
list, click More Borders. The Border page of the Format Cells dialog box contains the full
range of tools you can use to define your cells’ borders.
You can also make a group of cells stand apart from its neighbors by changing its shading,
which is the color that ills the cells. On a worksheet that tracks total package volume for
the past month, Lori Penor could change the ill color of the cells holding her data labels
to make the labels stand out even more than by changing the labels’ text formatting.
Tip You can display the most commonly used formatting controls by right-clicking a selected
range. When you do, a Mini Toolbar containing a subset of the Home tab formatting tools
appears above the shortcut menu.
If you want to change the attributes of every cell in a row or column, you can click the
header of the row or column you want to modify and then select your desired format.