1.Select one or more cells inside the row(s) or column(s) you want to delete.

•If you want to delete lines 2 through 4, for example, you could select A2:B4, C2:C4, or any other range of cells that includes the lines to be deleted.

•If you want to delete columns A and B, for example, you could select A1:B1, A2:B4, etc.

2.Press (DEL).

•This enters delete standby. If you decide you want to cancel the delete operation at this time, press ).

3.To delete the entire line(s) that include the cells you selected in step 1, press (ROW). To delete the entire column, press (COL).

STo delete the contents of all the cells in a spreadsheet

1.Press (DEL)(ALL).

2.In response to the confirmation message that appears, press (Yes) to delete the data or (No) to cancel without deleting anything.

STo insert a row or column of blank cells

1.Perform one of the following operations to specify the location of the insert and the number of rows or columns to be inserted.

•To insert rows

Starting with the row immediately below of the row where you want the insert to be performed, select the same number of rows that you want to insert.

Example: To insert three rows above row 2, you could select A2:A4, B2:C4, etc.

•To insert columns

Starting with the column immediately to the right of the column where you want the insert to be performed, select the same number of columns that you want to insert.

Example: To insert three columns to the left of column B, you could select B2:D4, B10:D20, etc.

2.Press (INS).

•This will enter insert standby. If you decide you want to cancel the insert operation at this time, press ).

3.Press (ROW) to insert the applicable number of rows or (COL) to insert columns.

•A Range ERROR occurs if an insert operation causes existing cells that contain data to move outside the range of A1:Z999.

STo clear the contents of specific cells

Select the cell or range of cells you want to clear and then press (CLR).

9-13