Show All

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

   • To change the appearance of the text, click a button in the Text format group.

   • To change the font or size of the text, click a different font in the Font list or a different size in the list next to it.

   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.

   • Under Text Format, click the format you want in the Number Format list.

   Place borders around cells

   • Under Cell format, next to Border, select the border color, style, width, and placement options you want.

   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

   • To align text horizontally, click Align Left , Center , or Align Right under Text format.
   • To align text vertically, click Align Top , Align Middle , or Align Bottom under Text format.

   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.