Microsoft Excel Tips
and Tricks
Draw Borders in Excel Worksheets
For years Microsoft Word users have been able to create
tables that meet their own unique specifications. Now, Excel
version 2002 offers users a similar feature: Draw Borders.
Here's how to use it:
1.
On the Formatting toolbar, click the arrow next to
Borders, and then click Draw Borders on the
palette.
2.
On the Borders toolbar, click the arrow next to
Draw Border or Draw Border Grid, and then click
Draw Border on the palette.
3.
Do one or more of the following:
a.
Draw a border line on cells.
Click the line you want as a border or click and drag on the
lines you want as borders.
b.
Draw an outside border around a row.
Click in the center of a cell and drag across the row.
c.
Draw an outside border around a column.
Click in the center of a cell and drag down the column.
4.
When you are finished drawing borders, close the Borders
toolbar to leave Draw Borders mode.
Here are some keyboard shortcuts to use with the new Draw
Borders feature:
§
To draw borders around every cell within the row or column,
press the CTRL key while you drag the cursor.
§
To erase the borders you've drawn around a row or column,
press the SHIFT key while you drag the cursor across the row
or down the column.
§
To erase the borders you've drawn around every cell within a
row or column, press CTRL+SHIFT while you drag the cursor
across the row or down the column.
Editor's Note:
To apply a different line style to a border, click the arrow
next to Line Style, and then click a line style on
the palette. To apply a different line color to a border,
click Line Color, and then click a color on the
palette.
|