Formatting elements: Font (How to)

Last week I talked about the various options for formatting the font, and this week I’m going to talk about how to actually access and use them.

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 “Font” tab.
  4. In the “Font” screen, select all of the options you want.
  5. When you are done, click “OK”.
  6. Click on the “OK” button.

In Excel 2007 & Excel 2010:

  1. Go to the Home tab.
  2. Find the Font group. In my version it’s 2nd from the left.
  3. In the Font group, you can either click on one of the visible icons it it has what you want, or click on the arrow in the lower-right corner for the complete menu.

In Google Spreadsheet:
Google Spreadsheet has scattered the options in various places.

  • Font size: At the top, in the menus, click on “Format”. Then in the menu that appears, click on “Font size”, then on the size you want. You can also do this by looking for the “10pt” in the row of icons and clicking the up or down arrows next to it. Google does not let you specify a different size than the pre-set options.
  • Font color: In the row of icons, look for a big black A with a thick line underneath it. By default that line is black, but if you click on that icon you can change the color of the font, and the new color will appear beneath the A.
  • Font family: At the top, in the menus, click on “Format”. Then in the menu that appears, click on “Font”, then on the font you want.
  • Font style: “Bold”, “Underline”, “Italic”, and “Strikethrough” are all available in the “Format” menu at the top. “Bold” and “Strikethrough” are also available in the row of icons.

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 either the “Font” tab or the “Font Effects” tab depending on what you want to change about the font.
    • Font size: This is in the “Font” tab.
    • Font color: This is in the “Font Effects” tab.
    • Font family: This is in the “Font” tab.
    • Font style: This is mostly in the “Font Effects” tab, with the exception of “Bold” and “Italic”, which are in the “Font” tab.