Formatting elements: Borders (How to)

Last week I talked about the do’s and don’ts of borders formatting in tables, and this week I’m going to talk about how to actually format the borders of a cell in various programs.

In Excel 97:

  1. Click on the header for the Format menu or type alt-o.
  2. In the menu that opens, click on “Cells…” or type “e”.
  3. In the window that pops up, click on the “Border” tab.
  4. Click on the style you want, or leave it on the default (thin solid line). Excel 97 has a variety of thin and thick options for solid, dotted, and dashed lines, and one option for double lines.
  5. Click on drop-down menu to select the color you want, or leave it on “Automatic”.
  6. Click on the border(s) you want, or select from the “Default” options. Excel 97 will let you have different styles/colors for different borders on the same cell.
  7. Click on the “OK” button.

In Excel 2007:

  1. Go to the Home tab.
  2. Find the Cells group. In my version it’s 2nd from the right.
  3. In the Cells group, click on “Format”.
  4. In the menu that appears, click on “Format Cells…” or type E.
  5. In the window that pops up, click on the “Border” tab.
  6. Click on the style you want, or leave it on the default (thin solid line). Access 2007 has a variety of thin and thick options for solid, dotted, and dashed lines, and one option for double lines.
  7. Click on drop-down menu to select the color you want, or leave it on “Automatic”.
  8. Click on the border(s) you want, or select from the “Default” options. Access 2007 will let you have different styles/colors for different borders on the same cell.
  9. Click on the OK button.

In Google Spreadsheet:

  1. In the row of buttons, look for and click on the square with two lines through it (it looks like four squares put together to make a larger square, or a child’s drawing of a window).
  2. In the menu that pops up, click on the border combination you want. In the list of options, lines that are solid will appear, and lines that are dotted will be removed. There are no style or color options for borders in Google Docs.

In OpenOffice Calc:

  1. Click on the header for the Format menu or type alt-o.
  2. In the menu that opens, click on “Cells…” or type “L”.
  3. In the window that appears, click on the “Borders” tab.
  4. Click on the style you want, or leave it on the default (0.05 pt thick). Open Office has double lines, and lines of varying thickness, but no dotted or dashed lines.
  5. Click on drop-down menu to select the color you want, or leave it on “Black”.
  6. Click on the border(s) you want, or select from the “Default” options. Open Office will let you have different styles/colors for different borders on the same cell.
  7. If, desired set the shadow position, distance, and color you want. The distance is how far out it stretches and is displaced. It will never extend past the cells bordering on the cell you’re formatting.
  8. If desired, set the minimum distance between the border and the text.
  9. Click on the “OK” button.

In Microsoft Works Spreadsheet:

  1. Click on the header for the Format menu or type alt-o.
  2. In the menu that opens, click on “Border…” or type “b”.
  3. In the window that appears, click on the color you want in the “Select border color” box.
  4. Set the “Line type”, or leave it on the default (solid thin line). Works has options for thin, medium, and thick solid lines, as well as double, dotted, and dashed lines.
  5. Select the border(s) you want. Works will let you have different borders of different line styles & colors.
  6. Click on the “OK” button.