User Manual

9-18
u To 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.
k Clearing 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).
u To 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)