EDITING SPREADSHEET

Editing spreadsheets

Enter the data 

1.      Click a cell, and then type data in that cell.

2.      Press ENTER or TAB to move to the next cell.

Tip     To enter data on a new line in a cell, enter a line break by pressing ALT+ENTER.

3.      To enter a series of data, such as days, months, or progressive numbers, type the starting value in a cell, and then in the next cell type a value to establish a pattern.

For example, if you want the series 1, 2, 3, 4, 5..., type 1 and 2 in the first two cells.

Select the cells that contain the starting values, and then drag the fill handle across the range that you want to fill.

Tip    To fill in increasing order, drag down or to the right. To fill in decreasing order, drag up or to the left.