Format cells in a spreadsheet

  1. Select the cells you want to format.
  2. On the spreadsheet toolbar, click Commands and Options , and then click the Format tab.
  3. Do one or more of the following:

    Change text font or size

    Change a number format

    When you change the format of a number in a cell, the displayed value for the number is changed, but not the stored value. For example, the stored value for the date 6/22/2000 is a serial number: 36699. This number remains the same, even when the cell's number format is changed to Thursday, June 22, 2000.

    Place borders around cells

    Change the background color of cells

    1. Under Cell format, next to Cell, click the arrow next to Fill Color .
    2. On the color palette, click the color you want.

    Align data in a cell

    Note   By default, text is aligned to the left side of a cell, and numbers, dates, and times are aligned to the right side of a cell.