Format cells in a spreadsheet
- In the design window, make sure the spreadsheet is activated. For instructions, see Help for your design program.
- Select the cells you want to format.
- On the toolbar, click Commands and Options , and then click the Format tab.
- Do one or more of the following:
-
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.
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.
- Under Cell format, next to Border, select the border color, style, width, and placement options you want.
Change the background color of cells
- Under Cell format, next to Cell, click the arrow next to Fill Color .
- On the color palette, click the color you want.
- To align text horizontally, click Align Left , Center , or Align Right .
- To align text vertically, click Align Top , Align Middle , or Align Bottom .
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.
-