Y O U R M I C R O S O F T O F F I C E A N D O T H E R D O C U M E N T T O O L S

11

number of columns—two in this example—to the right.

Shift cells down: Inserts the same number of new cells as the number of cells you highlighted vertically in step 2. For example, if you selected an area containing two cells vertically (A1 and A2), selecting Shift cells down inserts two vertical cells; so the original A1 and A2 (and their contents) are now A3 and A4. The highlighted area and all cells below it move the same number of rows—two in this example—down.

Entire row: Inserts the same number of new rows as the number of cells you highlighted vertically in step 2. For example, if you selected an area containing two cells vertically (A1 and A2), selecting Entire row inserts two rows; so the original rows 1 and 2 (and their contents) are now rows 3 and 4. The rows containing the highlighted area and all rows beneath it move the same number of rows—two in this example—down.

Entire column: Inserts the same number of new columns as the number

of cells you highlighted horizontally in step 2. For example, if you selected an area containing two cells horizontally (A1 and B1), selecting Entire column inserts two columns; so the original columns A and B (and their contents) are now columns C and D. The columns containing the highlighted area and all columns on the right move the same number of columns—two in this example—to the right.

5Select OK.

TIP To add a new worksheet, press Menu and select Format > Modify Sheets. Select Insert, enter a name for the worksheet, and press OK. To change the order of the worksheets, highlight a worksheet you want to move, select Move Up or Move Down, and press OK.

Formatting cells

1Open the workbook you want to format.

2Highlight the cells you want to format.

3Press Menu (right softkey) and select Format > Cells.

C H A P T E R

E X C E L M O B I L E ® 253

Page 253
Image 253
Palm PMG0501000P manual Number of columns-two in this example-to the right, Formatting cells