Insert columns or rows

To quickly insert one column, follow these steps:

1.Select a cell or a column to the left or to the right of which you want to add a new column.

2.Insert a column in one of the following ways:

•In the Table menu, select Insert Column to the Left or Insert Column to the Right.

•On the Toolbar, select the Cells section and click  Insert Column to the Left or  Insert Column to the Right.

•Right-click the selected cell or heading of the selected column and select the Insert Column to the Left or Insert Column to the Right command from the context menu.

•To insert column to the left, press Option+L. To insert column to the right, press Option+R.

To add several columns, perform the following actions:

1.Select the number of columns and cells horizontally equal to the number of columns to be inserted.

2.Insert the columns in one of the following ways:

•In the Table menu, select Insert Column to the Left or Insert Column to the Right.

•On the Toolbar, select the Cells section and click Insert Column to the Left or Insert Column to the Right.

•Right-click anywhere on the selected range and select the Insert Column to the Left or Insert Column to the Right command from the context menu.

•To insert columns to the left, press Option+L. To insert columns to the right, press Option+R.

To double the number of columns on the sheet, do the following:

1.Select any entire row on the sheet.

2.Insert columns in one of the following ways:

•Right-click the column heading area and select the Insert Column to the Left or Insert Column to the Right command from the context menu.

•To insert columns to the left, press Option+L. To insert columns to the right, press Option+R.

To quickly add one row, follow these steps:

1.Select a cell or row to the left or right of which you want to add a new row.

2.Insert a row in one of the ways:

•In the Table menu, select Insert Row Above or Insert Row Below.

•On the Toolbar, select the Cells section and click the  Insert Row Above or  Insert Row Below.

•Right-click anywhere on the selected range and select the Insert Row Above or Insert Row Below command from the context menu.

•To insert rows above, press Option+A. To insert rows below, press Option+B.

To add several rows, do the following:

1.Select the number of rows and cells vertically equal to the number of rows to be inserted.

2.Insert rows in one of the ways:

•In the Table menu, select Insert Row Above or Insert Row Below.

•On the Toolbar, select the Cells section and click  Insert Row Above or  Insert Row Below.

•Right-click anywhere on the selected range and select the Insert Row Above or Insert Row Below command from the context menu.

•To insert rows above, press Option+A. To insert rows below, press Option+B.

To double the number of rows on the sheet, proceed with the following:

1.Select any entire column on the sheet.

2.Insert rows in one of the ways:

•Right-click the row heading area and select the Insert Row Above or Insert Row Below command from the context menu.

•To insert rows above, press Option+A. To insert rows below, press Option+B.