Inserting and Deleting Rows and Columns

To insert a column or row click Insert > Rows or Insert > Columns.

To insert several columns, drag across the column headers (for example from B to D) for the number of columns you want to add. Then click Insert > Columns.

To insert several rows, drag across the row headers (for example from 15 to 17) for the number of rows you want to add. Click Insert > Rows.

To delete columns or rows, select the column(s) or row(s) you want to delete by clicking the column or row headers and choose Edit > Delete. If the Delete dialog box appears, specify in which direction you want to close up the row or column and click OK. (The dialog box doesn't appear is there is no data that would be deleted by deleting the column(s) or row(s)).