Y O U R M I C R O S O F T O F F I C E T O O L S

10

2Press Menu (right action key) 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.

6Select 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

1Open the workbook you want to add to.

2Highlight the area where you want to insert elements.

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

4Select how you want to insert the elements:

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

Shift cells down: Inserts a new cell. The highlighted cell and all cells below it move down one row.

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

Entire column: Inserts a new column. The entire column in which the highlighted cell is located and all columns to its right move one column 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 then press OK. To change the order of the worksheets, highlight a worksheet you want to move, and then select Move Up or Move Down. Press OK to finish.

C H A P T E R

E X C E L M O B I L E 179

Page 187
Image 187
Palm 750 manual Adding cells, rows, and columns