These commands perform various operations on entire columns or rows in
the worksheet.
The Column/Row command provides the following options:
- Insert
- Inserts a new row or column into the worksheet.
Append Insert a new row or column immediately following the source
row or column with a copy of the contents of the source row or
column.
- Delete
- Deletes a row or column from the worksheet.
- Pull
- Reinsert (pull) deleted rows or columns back into the
worksheet.
- Remove
- Remove expressions from the affected rows or columns, leaving
only the values of the expressions in the affected cells.
- Hide
- Hides a row or column on the worksheet.
- Show
- Unhides a row or column on the worksheet.
- Format
- Specifies the numeric display format for a column.