Contents
Prev  Chapter 5. Formatting  Next

Contents

Abstract

Change cell content appearance: font sizes, font types

The font style, size and colour of any group of cells whether text, number or date may be changed.

  1. Select the cells.

  2. Format->Cells

  3. Click the Font tab.

  4. Select the font, typeface, size and colour.

  5. Click OK.

Apply formatting to cell contents such as: bold, italic, underline, double underline

The simplest way to add underlining, bold or italic is to:

  1. Select the cells to be formatted.

  2. Click the desired effect on the object bar.

[Note] Note

You could have also changed the font style and size using the object bar.

Double underline does not appear by default on the object bar. In this case:

  1. Select the cells to be formatted.

  2. Format->Cells

  3. Click the Font effects tab.

  4. Click down on the Underlining drop down window to view the different underlining options.

  5. Select the desired type of underlining.

  6. Click OK.

Apply different colours to cell content, cell background

Suppose you have a single row of cells or a row of cells which you wish to display in a particular colour.

  1. Select the cells to be formatted.

  2. Format->Cells

  3. Click the Font effects tab.

  4. Click on the drop down arrow next to Font colour to display the possible colours.

  5. Select the colour you wish to use then click the OK colour.

You can also change the background of the cells which, by default, is white.

  1. Select the cells to be formatted.

  2. Format->Cells

  3. Click on the Background tab.

  4. Select the colour you wish to apply to the cell backgrounds and click the OK button.

Copy the formatting from a cell, cell range to another cell, cell range

Copying the formatting of a cell to another cell or range of cells involves a couple of steps.

The following example illustrates the process.

In the following screen, cell A6 has been formatted to Roman, 12 point, bold, red. We wish to copy this formatting to cells A5 and A7:A9.

  • Format->Stylist

This displays the Cell styles dialogue. This dialogue contains five icons:

The first icon is the Cell styles icon while the second is the Page styles icon.

On the right hand side, the first icon (paint can) is the Fill format mode icon. The next is the New style from selection and the last the Update style icon. An icon can be selected from each group independently.

[Tip] Tip

If you let your cursor hover over the icons, a tip will be displayed telling you what the icon is.

  1. Select the Cell styles icon.

  2. Select the cell whose format you wish to copy and click the New style from selection icon.

  3. Enter an appropriate style name for the formatting and click OK.

    The new style name will appear in the list of styles.

  4. Select the style and click on the Fill format mode icon.

    The cursor will now be displayed as a paint can.

  5. Hold down the left mouse button and drag the cursor over the cells whose format you wish to change.

  6. When you have finished, click on the Fill format mode icon once more.

    This will change the cursor back to its normal pointing function.

Apply text wrapping to contents within a cell

Suppose we have a column of cells that we wish to use to write notes. By default, if we write in a cell, the text will appear to spill over into the next cell. If we enter text in the next cell, part of our old text will cease to be visible.

The answer to this problem is to cause the text to wrap within the cell.

  1. Select the range of cells in which you wish text to wrap.

  2. Format->Cells

  3. Select the Alignment tab.

  4. Check the Automatic line break check box.

  5. Click OK.

The effect is shown below.

Prev  Up  Next
Chapter 5. Formatting  Home  Alignment, Border Effects