Palm PMG0501000P manual Entering a sequence automatically, Adding cells, rows, and columns

11

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

C H A P T E R

3Select the Category list, and then select the type of function you want to insert.

4Select the Function list, and then select the specific function you want to insert.

5Select OK.

Entering a sequence automatically

1Tap and drag with the stylus to highlight both the cells containing the info you want to automate and the adjacent destination cells.

2Press Menu (right softkey) and select Edit > Fill.

3Select the Direction list, and then select the direction you want to populate.

4Select the Fill type list, and then select Series.

5Select the Series type list, and then select the type of series you want. If you select Date or Number, enter a Step value increment.

TIP Select Autofill as the series type to quickly fill cells with repetitive data such as numbers or repeated text. Autofill takes the content of the first cell in the highlighted row or column and copies it down or across the rest of the selection.

6Select OK.

Adding cells, rows, and columns

1Open the workbook you want.

2Highlight the area where you want to insert elements.

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

4Select how you want to insert the elements:

Shift cells right: Inserts the same number of new cells 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 Shift cells right inserts two horizontal cells; so the original A1 and B1 (and their contents) are now C1 and D1. The highlighted area and all cells on the right move the same

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