Insert columns, rows or cells

Insert columns

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:
   • On the Home tab, in the Cells group, click the arrow to the right of the  Insert cell, column or row button and select  Insert column to the left or  Insert column to the right.

tip

The appearance of the  Insert cell, column, or row button depends on the last command invoked using it and may differ from the one shown here.

•Right-click the selected cell or the selected column header and choose Insert cell, column or row > Column to the left / Column to the right from the context menu.

•To insert a column to the left, press Alt+L. To insert a column to the right, press Alt+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:
   • On the Home tab, in the Cells group, click the arrow to the right of the  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 cell, column or row > Column to the left or Column to the right command from the context menu.
   • To insert columns to the left, press Alt+L. To insert columns to the right, press Alt+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.

Insert rows

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:
   • On the Home tab, in the Cells group, click the arrow to the right of the  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 cell, column or row > Row above / Row below from the context menu.
   • To insert a row above, press Alt+A. To insert a row below, press Alt+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:
   • On the Home tab, in the Cells group, click the arrow to the right of the  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 cell, column or row > Row above or Row below command from the context menu.
   • To insert rows above, press Alt+A. To insert rows below, press Alt+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.

Insert cells with shift

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.

tip

You cannot perform a shift insertion into a range with filtered cells.

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:
   • On the Home tab, in the Cells group, click the arrow to the right of the  Insert cell, column or row button and select  Insert cells and shift right or  Insert cells and shift down.
   • Right-click the selected cell or range and choose Insert cell, column or row > 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:
   • On the Home tab, in the Cells group, click the arrow to the right of the  Insert copied cells button and select  Insert copied cells and shift right or  Insert copied cells and shift down.

tip

The appearance of the  Insert copied cells button depends on the last command invoked using it and may differ from the one shown here.

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

tip

In the current version of MySpreadsheet, shift insertion is not available when working with a document in the View and Collaboration modes.