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 the Option+L key combination. To insert column to the right, press the Option+R key combination.

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 the Option+L key combination. To insert columns to the right, press the Option+R key combination.

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 the Option+L key combination. To insert columns to the right, press the Option+R combination.

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 the Option+A key combination. To insert rows below, press the Option+B key combination.

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 the 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.