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 Column to the Right.

•On the Toolbar, in the Cells section, click the arrow to the right of Insert Cell, Column, or Row button and select  Insert Column to the Left or  Insert Column to the Right.

•Right-click the selected cell or the selected column header and choose Insert > Column to the Left / Column to the Right 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, follow these steps:

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

2.Insert columns in one of the following ways:

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

•On the Toolbar, in the Cells section, click the arrow to the right of Insert Cell, Column, or Row button and select  Insert Column to the Left or  Insert Column to the Right.

•Right-click anywhere in the selected range and run Insert > Column to the Left or Column to the Right command from the context menu.

•To insert columns to the left, press  Option+L. To inserts column 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 the columns in one of the ways described above.

To quickly insert 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 following ways:

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

•On the Toolbar, in the Cells section, click the arrow to the right of Insert Cell, Column, or Row button and select  Insert Row Above or  Insert Row Below.

•Right-click the selected cell or the selected row header and choose Insert > Row Above / Row Below from the context menu.

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

To add several rows, follow these steps:

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 following ways:

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

•On the Toolbar, in the Cells section, click the arrow to the right of Insert Cell, Column, or Row button and select  Insert Row Above or  Insert Row Below.

•Right-click anywhere in the selected range and run Insert > Row Above or 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, do the following:

1.Select any entire column on the sheet.

2.Insert the rows in one of the ways described above.

To insert cells without replacing existing data, the shift cell insertion functions are used. The existing data is automatically shifted to the right or down, depending on the selected insertion option, by the number of cells to be inserted. All links and formulas that use the cells shifted as a result of the insertion are automatically updated.

To add a single blank cell or a range of blank cells, follow these steps:

1.Select the single cell or range above or to the left of which you want to add blank cells. The inserted range will be the same size as the selected range, and the cells will be inserted relative to the upper-left cell of the selected range.

2.Insert cells in one of the following ways:

•In the Table menu, select Insert > Cells and Shift Right / Cells and Shift Down.

•On the Toolbar, in the Cells section, click the arrow to the right of Insert Cell, Column, or Row and select  Insert Cells and Shift Right or  Insert Cells and Shift Down from the drop-down menu.

•Right-click the selected cell or range and choose Insert > Cells and Shift Right / Cells and Shift Down from the context menu.

To insert the copied cells with shift, follow the steps below:

1.Copy the required cells.

2.Select the single cell or range above or to the left of which you want to insert the copied cells. When a range is selected, cells will be inserted relative to the upper-left cell of the range.

3.Insert the copied cells in one of the following ways:

•In the Table menu, select Insert Copied Cells > Shift Cells Right / Shift Cells Down.

•On the Toolbar, in the Cells section, click  Insert Copied Cells and select  Insert Copied Cells and Shift Right or  Insert Copied Cells and Shift Down from the drop-down menu.

•Right-click the selected cell or range and choose Insert Copied Cells > Shift Cells Right / Shift Cells Down from the context menu.

The copied cells will be pasted with the original formatting intact.