Microsoft Office Tutorials and References
In Depth Information
Altering the Alignment
✓ If you want borderlines to appear around all four edges of each cell in
the cell selection (like a paned window), select the All Borders option
on this drop-down menu. If you want to draw the inside and outside
borders yourself around an unselected cell range in the active worksheet,
click the Draw Border Grid option, drag the mouse (using the Pencil
mouse pointer) through the range of cells, and then click the Borders
button on the Home tab.
To change the type of line, line thickness, or color of the borders you apply
to a cell selection, you must open the Format Cells dialog box and use the
options on its Border tab (click More Borders at the bottom of the Borders
button’s drop-down menu or press Ctrl+1 and then click the Border tab).
To select a new line thickness or line style for a border you’re applying, click
its example in the Style section. To change the color of the border you want
to apply, click the color sample on the Color drop-down palette. After you
select a new line style and/or color, apply the border to the cell selection by
clicking the appropriate line in either the Presets or Border section of the
Border tab before you click OK.
To get rid of existing borders in a worksheet, you must select the cell or cells
that presently contain them and then click the No Border option at the top of
the second section on the Borders button’s drop-down menu.
Applying fill colors, patterns, and
gradient effects to cells
You can also add emphasis to particular sections of the worksheet or one of
its tables by changing the fill color of the cell selection and/or applying a
pattern or gradient to it.
If you’re using a black-and-white printer, you want to restrict your color
choices to light gray in the color palette. Additionally, you want to restrict
your use of pattern styles to the very open ones with few dots when
enhancing a cell selection that contains any kind of entries (otherwise, the entries will
be almost impossible to read when printed).
To choose a new fill color for the background of a cell selection, you can
click the Fill Color button’s drop-down menu in the Font group on the Home
tab and then select the color you want to use in the drop-down palette.
Remember that you can use Live Preview to see what the cell selection looks
like in a particular fill color by moving the mouse pointer over the color
swatches. Click one to select it.