Casio fx-CG20 kClearing Cell Contents and Formatting, uTo clear cell contents and formatting, uTo insert a row or column of blank cells, To clear this:, •To insert rows

uTo 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 4(INSERT).

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

3. Press 1(ROW) to insert the applicable number of rows or 2(COLUMN) 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.

kClearing Cell Contents and Formatting

You can clear cell contents only, formatting only, or both contents and formatting.

•Content clear: Clears values, formulas, and other cell data.

•Format clear: Returns the character color, area color, and paint style settings of the cells to their initial default settings. This operation also clears conditional formatting (page 9-21).

uTo clear cell contents and formatting

1.Select the cell or range of cells you want to clear.

2.Perform the operations below to specify the cells you want to clear.

To clear this:	Perform this key operation:
Cell contents only	5(CLEAR)1(CONTENT)
Cell formatting only	5(CLEAR)2(FORMAT)
Cell contents and formatting	5(CLEAR)3(ALL)

9-18