Entering a Sequence Automatically

1.Highlight both the cells containing the information you want to automate and the adjacent destination cells.

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

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

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

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

6.Select OK.

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.

Adding Cells, Rows, and Columns

1.Open the workbook you want to add to.

2.Highlight the area where you want to insert elements.

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

4.Select how you want to insert the elements:

Shift cells right: Insert a new cell. The highlighted cell and all cells on the right move one column to the right.

Shift cells down: Insert a new cell. The highlighted cell and all cells below it move down.

Entire row: Insert a new row. The entire row in which the highlighted cell is located and all rows below it move down.

298

Section 5B: Increasing Your Productivity

Page 298
Image 298
Palm TREOPROBLKSPT manual Entering a Sequence Automatically, Adding Cells, Rows, and Columns, 298